Can a Shadow Copy of SQL 2000 databases files be used as a restore?
Posted
by Keith Sirmons
on Server Fault
See other posts from Server Fault
or by Keith Sirmons
Published on 2010-05-16T16:19:22Z
Indexed on
2010/05/16
16:30 UTC
Read the original article
Hit count: 461
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
© Server Fault or respective owner