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:

To revert a SQL 2005 or later database using database snapshots

  1. On the navigation bar, click the arrow next to Restore.

  2. Click New Restore Job.

  3. On the Properties pane, under Source, click Selections.

  4. 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.

  5. Click Run Now.

More Information

Restoring data by setting job properties

About restoring SQL databases and file groups