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

Restore by Tree in Microsoft SQL Server 2005, 2008, or 2012 Cluster Environments

You can submit each backup session as a separate restore job if you use the Restore by Tree method.

Follow these steps:

1. On the Restore Manager Source tab, select Restore by Tree from the drop-down list.
2. In the navigation tree, expand the Microsoft SQL Server virtual server name from which the database you want to restore was backed up. Click the yellow database icon to expand the database instance and click the database you want to restore to select it.
3. To use the most recent backup, skip to the next step.

   To use a backup other than the most recent backup, choose a Recovery Point session.

4. Right-click the database name you selected and select Agent Options from the pop-up window.

   The Agent Restore Options dialog opens. The dialog varies depending upon the restore sessions selected.

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.