SQL 2005 or later database snapshots created with Backup Exec can be used to revert a SQL 2005 or later database back to the state it was in at a previous point in time, without having to run a full database restore job.
When viewed by resource in the Restore Job Properties pane, SQL database snapshots appear as backup sets, in chronological order with the most recent snapshot appearing first.
The word SNAPSHOT appears in the backup set description.
The following caveats apply when reverting a database:
-
You cannot undo a SQL 2005 or later database that has been reverted.
-
Before reverting a database, Backup Exec deletes all existing database snapshots, including those created with SQL 2005 or later, with the exception of the snapshot used for the revert. After being deleted, the database snapshots cannot be recovered.