Restore to Alternate Disk Locations by Individual Session
66 Agent for Microsoft SQL Server Guide
11.
Click OK to close the Agent Restore Options dialog and submit the restore
job. For instructions about restoring by session, see the appropriate section
in this chapter.
12.
Repeat the preceding 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 the restore.
Note
: You must clear your previous selections before selecting options for
the next job.
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 Version History. The Version History dialog appears. Scroll to the right
to 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 Version History again and select the next backup session.
9.
Open the Agent Restore Options dialog. Clear the Automatic Selection
option.
