Creating SQL database snapshots

The Backup Exec SQL Agent works with the SQL 2005 database to create database snapshots, which are read-only, point-in-time copies of an existing host database.

To create database snapshots

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

  2. Click New Backup Job.

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

  4. Select the SQL 2005 database for which you want to create a database snapshot.

  5. On the Properties pane, under Settings, click Microsoft SQL.

  6. In the Backup method field, select Database Snapshot (SQL 2005 or later) - Read only, point-in-time copy of another database.

  7. Set the number of database snapshots per database to keep, or accept the default of four.

  8. Start the database snapshot job or select other backup options from the Properties pane, and then start the backup job.

More Information

Reverting SQL 2005 or later databases using database snapshots