Can a Shadow Copy of SQL 2000 databases files be used as a restore?
- by Keith Sirmons
Howdy,
I have a SQL 2000 instance (version 8.00.760) that is on a drive that gets regular shadow copies.
Can a shadow copy be used to restore the database?
It seems possible to stop the SQL service, restore the Data folder from the shadow copy (includes msdb, master, model, temp, and the user databases, then restart the service.
Would the files be in a crash consistent case in the worst case? If so, when restarting the service wouldn't it recover as if the power were pulled from the server?
Thank you,
Keith