asked
Database snapshot recovery
Hi, Just wanted to confirm if we can recover from snapshot incase of hard disk (where the database files are) failure I dont think we can but just wanted to confirm Thank You
You can't use it to recover from drive failure. The snapshot only contain the original values of changed records. Records that are unchanged doesn't even exist in the snapshot. Actually you need to remove the snapshot to be able to perform a restore. > "The database cannot be dropped, > detached, or restored" (books online) Read more about limitations of database snapshots at [
http://msdn.microsoft.com/en-us/library/ms189940.aspx][1] [1]:
http://msdn.microsoft.com/en-us/library/ms189940.aspx
@Håkan Winther is right. A snapshot is a changed data repository. The bulk of the data is read from the actual dB and only changed pages exist in the snapshot. You can use a snapshot to revert a dB to the snapshot LSN but not to recover it as you describe.
