Restore to Alternate Disk Locations by Individual Session
Chapter 4: Restoring Microsoft SQL Server Databases 65
7.
For the earliest of these backup sessions (the full backup on which the others
depend), make the appropriate changes to the file paths and names.
Important!
Do not edit the file names or paths for any of the sessions
except the full backup session.
8.
Complete the restore job packaging, and submit the restore job. For
instructions on restoring by session, see the appropriate section in this
guide.
Restore by Session Using a Separate Job for Each Session
If you restore databases using a separate job for each session, you can submit
each job on hold and then make each job ready individually as the previous one
finishes.
To package the database restore job as separate jobs
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 most recent full database
backup of the database you want to restore. This is the full backup on which
the more recent backup sessions depend.
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 option and edit the file names or paths as
appropriate.
5.
Select the Leave database nonoperational, but able to restore additional
transaction logs option
under Recovery Completion State.
6.
Click OK to close the Agent Restore Options dialog and submit the restore
job.
7.
Select the next backup session for the database you want to restore.
8.
Right-click the backup session and select Agent Options from the pop-up
window. The Agent Restore Options dialog opens.
9.
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.
