Introducing Arcserve Backup Agents and Options › Using Agents › Agent for Microsoft SQL Server › Restore Databases Using Restore by Session Method

Restore Databases Using Restore by Session Method

To perform a restore operation using Restore by Session method

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. To create a filter to view only the sessions from a specific server or the sessions from a specific database on a specific server, perform the following procedure:
   1. Select the Filter tab. 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, or a machine name and database name to restore the sessions of a particular database.

      If you are using Microsoft SQL Server 2000 or SQL server 2005, you can also enter a machine name, instance name, and database name to restore a database from a specific instance of Microsoft SQL Server.

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

3. Expand the media containing the backup you want to restore and select the session containing the specific database or log you want to restore.

   Note: Microsoft SQL Server backups have one Database, Partial, Files-and-FileGroups, or Transaction log backup for each session on the media.

4. Right-click the session containing the backup session you want to restore and choose Agent Options from the pop-up window.

   The Agent Restore Options dialog appears. This dialog varies depending on the backup method of the session selected, 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, 2012 or 2014 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.