Previous Topic: Restore by Session Using a Separate Job for Each SessionNext Topic: Perform an Offline Torn Page Restore Using Microsoft SQL Server 2000, 2005, 2008, or 2012

Restoring Microsoft SQL Server Databases › Restore to Alternate Disk Locations by Individual Session › Restore by Tree Using a Separate Job for Each Session

Restore by Tree Using a Separate Job for Each Session

If you are using the Restore by Tree method, you must submit each session as a separate restore job. You may want to submit each job on hold and make each job ready individually as the previous one finishes.

To restore sessions as separate jobs using the Restore by Tree method

  1. On the Restore Manager Source tab, select Restore by Tree from the drop-down list.
  2. In the navigation tree, expand the computer from which the database you want to restore was backed up. Click the yellow database icon to expand the database instance containing the database you want to restore and select the database.
  3. Click the first Recovery Point drop-down control to select a recovery point day. Click the second Recovery Point drop-down control to view all available sessions. Find the columns labeled Method and Backup Time.

    Note: Entries appear in reverse chronological order; more recent backups appear higher on the list.

  4. Select the most recent backup with the method Database and click Select.
  5. Right-click the selected database session and select Agent Options from the pop-up menu. The Agent Restore Options dialog opens.
  6. Edit the file names or paths as appropriate, and select the Leave database nonoperational, but able to restore additional transaction logs option under Recovery Completion State.
  7. Click OK to close the Agent Restore Options dialog and submit this restore job. For instructions about restoring by tree, see Restore Databases Using Restore by Tree Method.
  8. Click Recovery Point again and select the next backup session.
  9. Open the Agent Restore Options dialog. Clear the Automatic Selection option.
  10. If this is not the last session to be restored, select the Leave database nonoperational, but able to restore additional transaction logs option under Recovery Completion State.

    If this is the last session to be restored, confirm that the Leave database operational. No additional transaction logs can be restored option is selected under Recovery Completion State.

  11. Click OK to close the Agent Restore Options dialog.
  12. Submit the restore job. For instructions about restoring by tree, see Restore Databases Using Restore by Tree Method.
  13. Repeat these steps from the point at which you close the Agent Restore Options dialog and submit the restore job until all backup sessions have been submitted for a restore.