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.