Restore to Alternate Disk Locations by Individual Session
64 Agent for Microsoft SQL Server Guide
2.
Choose Agent Options.
The Agent Restore Options dialog opens.
3.
In the second folder tab, if the FileGroups and data files appear, you can use
Automatic Selection. Follow the appropriate procedures in this chapter to
restore your data.
Restore to Alternate Disk Locations by Individual Session
If the FileGroups and data files are not displayed in the section called Restore
database files as, you must restore the sessions individually to restore them to
an alternative disk location. To restore sessions to an alternative disk location
individually, use one of the following methods:
■
Restore by Session Using a Single Restore Job
(see page 64).
■
Restore by Session Using a Separate Job for Each Session
(see page 65).
■
Restore by Tree Using a Separate Job for Each Session
(see page 66).
Restore by Session Using a Single Restore Job
Use the Restore Manager in CA ARCserve Backup to restore databases by session
using a single restore job.
To restore databases by session using a single restore job
1.
On the Restore Manager Source tab, select Restore by Session from the
drop-down list. A list of the media you have used when backing up with CA
ARCserve Backup opens.
2.
Choose the media containing the backup you want to restore, expand the
session containing that backup, and select the current backup session.
3.
Right-click the backup session and select Agent Options from the pop-up
window. The Agent Restore Options dialog opens.
4.
Clear the Automatic Selection check box and select the Leave database
nonoperational, but able to restore additional transaction logs option under
Recovery Completion State.
Note:
You cannot restore any additional transaction logs if this option is not
selected.
5.
Click OK.
6.
For each additional required backup of the database, select the next most
recent session, open the Agent Restore Options dialog, clear Automatic
Selection, and select the Leave database nonoperational, but able to restore
additional transaction logs option under Recovery Completion State. Click
OK.
