Restoring an entire SQL database, a missing primary filegroup, or a filegroup containing a deleted or changed table

Use the following steps to restore an entire database (SQL 2000 and SQL 2005 only), a missing primary filegroup or a filegroup containing a deleted or changed table.

Use separate restore jobs to restore the primary filegroup, the rest of the filegroup backup sets, and the transaction logs.

To restore the entire database (SQL 2000 and SQL 2005 only), a missing primary filegroup, or a filegroup containing a deleted or changed table

  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 backup set containing the primary filegroup.

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

  6. On the Restore Job Properties dialog box, click Leave the database nonoperational; additional transaction logs or differential backups can be restored.

    See Redirecting restores for SQL.

  7. Start the restore job.

  8. After the primary filegroup is restored, select the rest of the filegroup backup sets containing the latest full and differential backups.

  9. On the Restore Job Properties dialog box, click Leave the database nonoperational; additional transaction logs or differential backups can be restored, and then start the restore job.

  10. When the full and differential backups are restored, select the backup set containing the transaction logs.

  11. On the Restore Job Properties dialog box, click Leave the database nonoperational; additional transaction logs or differential backups can be restored.

    This option restores all of the transaction logs. You also can select Point in time log restore or Restore log up to named transaction.

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

More Information

Restoring data by setting job properties

Restoring a missing or corrupted SQL nonprimary filegroup

About restoring SQL databases and file groups