Previous Topic: Restore by Session Using a Single Restore JobNext Topic: Restore by Tree Using a Separate Job for Each Session

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

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 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.

  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.