Database Simplified Headline Animator

Database Simplified

Sunday, 3 June 2012

Restore Database From Snapshot

This is another way of restoring database to a time when snapshot was taken but it has certain restrictions lets see what are those ?

  • Database should have only one snapshot.
  • Cannot restore files removed after taking snapshot.
  • Transaction log backup chain is broken So make sure you take full backup before restore.
  • Restore From snapshot will drop all full text catalogs.

You must understand that restoring database from snapshot is meant to bring your database to stage when snapshot was taken it cannot fix your data corruption issues.

Note : If you have multiple snapshot then you  must delete all the snapshot except one you want to revert to.

Syntax :

USE Master
Go RESTORE DATABASE DBName from
DATABASE_SNAPSHOT = 'SnapShot_DBName'
GO

During restore operation both actual database and snapshot data will be unavailable (i.e. Restoring Mode).

No comments:

Post a comment