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.
The following caveats apply when reverting a database:
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.
To revert a SQL 2005 or later database using database snapshots
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.