Reverting a SQL 2005 or later databases using database snapshots

You can revert a SQL 2005 or later database using database snapshots without having to run a full database restore jobs.

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 or later) are deleted, and the database is reverted. After the revert completes, the SQL 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

Reverting a SQL 2005 or later databases using database snapshots