Restoring from SQL database backups

If the database is using the simple recovery model, there are no transaction log backups to restore. You only need to restore the most recent full database backup and if you were running differential database backups, restore the most recent differential database backup.

See Restoring data by setting job properties.

Note:

Restoring a full SQL 2005 or later database backup over an existing SQL 2005 or later database with active database snapshots will eliminate all existing database snapshots for the SQL 2005 or later database being restored.

See Reverting SQL 2005 or later databases using database snapshots.

To restore from SQL database backups

  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. In the restore selections list, select the most recent full database backup set, and the most recent differential database backup set, if any, to restore.

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

  6. On the Restore Job Properties dialog box, click Leave the database ready to use; additional transaction logs or differential backups cannot be restored.

    See Setting restore options for SQL.

  7. Start the restore job or select other restore options from the Properties pane.

More Information

About restoring SQL databases and file groups

About SQL 2005/SQL 2008 database snapshots

Reverting SQL 2005 or later databases using database snapshots