Backing Up and Restoring in Cluster Environments › Restore by Session in Microsoft SQL Server 2000, 2005, 2008, or 2012 Environments

Restore by Session in Microsoft SQL Server 2000, 2005, 2008, or 2012 Environments

You can restore databases by session in a single restore job using the Restore by Session method.

Follow these steps:

1. On the Restore Manager Source tab, select Restore by Session from the drop-down list. A list of the media that you have used when backing up with Arcserve Backup opens.
2. To create a filter to restore only the sessions from a specific server or the sessions from a specific database on a specific server, perform the following steps:
   1. Click the Filter tab in the Restore Manager. The Filter dialog opens.
   2. Click the SQL Agent Filter tab. The SQL Agent Filter dialog opens.
   3. Enter a machine name to restore the sessions from a particular server, a machine name and database name to restore the sessions of a particular database, or a machine name, instance name, and database name to restore a particular instance of a database and click OK.

   Note: Once you apply the filter settings, expand the media item to view the results. If the media item was already expanded, collapse it and expand it again to see the results.

   If you do not want to create a filter, go to the next step.

3. Choose the media containing the backup you want to restore, expand the session containing that backup, and select the specific database or log you want to restore.
4. Right-click the name of the database or log you want to restore and select Agent Options from the pop-up window.

   The Agent Restore Options dialog opens.

5. Perform one of the following to select restore options:
   • Click OK to accept the default options and allow the Automatic Selection option select the appropriate restore sequence and options for the restore job. The Automatic Selection option is the default option for every restore job.
   • Manually select the options you want to use for this restore sequence and click OK. For more information about options, see Restore Options.

     Important! The Automatic Selection option on the Agent Restore Options dialog automatically selects the sessions which must be restored and applies the selected options appropriately to each session.

6. On the Source tab, ensure that the session you want to restore is selected.
7. In the Restore Manager, click the Destination tab and select a destination using one of the following procedures:
   • To restore to the original instance on the original server using the original database name, select the Restore files to their original locations option if not selected already.
   • To restore to a different server but to an instance of Microsoft SQL Server with the same version and instance name, clear the Original Location check box and select the destination machine. The destination machine must have an instance with the same name as the original and the same version of Microsoft SQL Server or higher.
   • To restore to a different server or a different instance on the original server using the original database name, clear the Restore files to their original locations option and select the Microsoft SQL Server instance for the destination server.
   • To restore using a different database name, clear the Restore files to their original locations option, select the destination server, and select the Microsoft SQL Server instance on the destination server. Enter a backslash and the new name of the database at the end of the displayed path, as in the following examples:

     \\SERVER1\MSSQLSERVER\Lightning
     

     \\SERVER2\WEATHER\Thunder
     

   • Note: If you are restoring a database backed up from a Microsoft SQL Server 7.0 instance to a Microsoft SQL Server 2000, Microsoft SQL Server 2005, 2008, or 2012 instance, you must explicitly select the target instance even if it is a default instance.
8. Click Submit.

   The Restore Media dialog appears.

9. Select the backup server where the restore job is going to run and click OK.

   The Session User Name and Password dialog opens.

10. Verify or change the user name or password for the Windows computer on which Microsoft SQL Server is loaded. To verify or change the user name or password, follow these steps:
    1. Select a session on the Machine tab and click Edit. The Enter User Name and Password dialog opens.
    2. Enter or modify the user name and password.
    3. If a session password was assigned to this session, enter the session password.
    4. To apply the user name and password you entered to all the sessions you are restoring, select the Apply [User Name and Password] to all rows option.
    5. Click OK.

    Note: We recommend that you use the user name and password of a domain administrator for machine authentication. Domain administrators are not dependent on the computer on which the Microsoft SQL Server instance is still running. Specify a domain user with the format DomainName\UserName.

11. Verify or change the user name or password for the database servers to which you are restoring. To verify or change the user name or password for the database servers, follow these steps:
    1. Select the DBAgent tab.
    2. Select a session and click Edit. The Enter User Name and Password dialog opens.
    3. Enter or modify the user name and password.
    4. If you want the user name and password you entered applied to all the sessions you are restoring, select the Apply [User Name and Password] to all rows option.
    5. Click OK.
12. Click OK on the Session User Name and Password dialog.

    The Submit Job dialog opens.

13. (Optional) Use the Submit Job dialog to select the job execution time, submit the job on hold, add an optional job name for the backup job, or select source priority.
14. Click OK to submit this job. If you selected Run Now, the Job Status window opens. Use this window to monitor your job. For more information about the Job Status window, see the Administration Guide.