Restoring Microsoft SQL Server Databases › Restore Databases Using Restore by Tree Method

Restore Databases Using Restore by Tree Method

To restore using the Restore by Tree method

1. On the Restore Manager Source tab, select Restore by Tree from the drop-down list.
2. In the navigation tree, expand the computer from which the database was backed up to view the database instances. Click the yellow database icon to expand the database instance containing the database you want to restore and click the database name to select it.
3. To use the most recent backup, go to the following step.

   To use a backup other than the most recent one, click the first Recovery Point drop-down control to select a recovery day. Next, click the second Recovery Point drop-down control to select a recovery session.

4. Right-click the database name you selected and choose Agent Options from the pop-up window. The Agent Restore Options dialog appears. The dialog varies depending on the backup method of the selected session and the version of SQL Server from which the database was backed up.
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.
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.