Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Microsoft SQL Server › Restore to Alternate Disk Locations by Individual Session › Restore by Session Using a Single Restore Job

Restore by Session Using a Single Restore Job

Use the Restore Manager in 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 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.
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.