Reverting SQL 2005 or later databases using database snapshots

SQL 2005 or later database snapshots created with Backup Exec can be used to revert a SQL 2005 or laterdatabase 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 2005 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 database that has been reverted.
Before reverting a database, Backup Exec deletes all existing database snapshots, including those created with SQL 2005, with the exception of the snapshot used for the revert. After being deleted, the database snapshots cannot be recovered.
You cannot redirect a database snapshot restore job.

To revert a SQL 2005 or later database using database snapshots

On the navigation bar, click the arrow next to Restore.
Click New Restore Job.
On the Properties pane, under Source, click Selections.
Select a database snapshot.

After you click Run Now, all previous SQL 2005 or later database snapshots (including those created by SQL 2005/SQL 2008) are deleted, and the database is reverted. After the revert completes, the SQL 2005 or SQL 2008 database cannot be returned to its previous state.
Click Run Now.