PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Configure general restore settings

To configure Microsoft SQL Server restores with the Microsoft app agent for Application Direct SSMS plug-in, you must first specify general restore options on the Database Restore > General page.

1. Open the Microsoft app agent for Application Direct window to the Database Restore > General page.

   The General page appears as shown in the following figure.

   

   The Microsoft application agent automatically loads the information from the last recovery operation and populates all of the fields under Sources. To clear the cached settings, click Clear Cache.

2. In the PowerProtect DD System field, select the DD server that contains the backup.
   NOTE:When you want to restore a replicated backup from a secondary DD server, select the secondary server. The DD user on the secondary DD server must be in the same group as the primary server.
3. From the SQL Server host list, select the Microsoft SQL Server host that is the source of the backup. Select the Windows cluster name in the case of federated backups.
4. From the SQL Server Instance list, select the Microsoft SQL Server instance that contains the databases that you want to restore.

   The databases located on the Microsoft SQL Server instance appear in the database table below the SQL Server Instance field.

5. From the database table, select either the entire Microsoft SQL Server instance by selecting the check box in the header row or select only the required databases to restore.

   The save sets on the Microsoft SQL Server instance that are available for recovery appear in the save sets table below the Browse time field.

   By default, the restore process selects the most recent backup timestamp for each selected database. If you have selected a single database, you can perform a point-in-time (PIT) restore.

6. (Optional) To perform a point-in-time restore of a single database, perform the following steps:
   1. From the Browse time list, select a date and time, and click Show Versions.

      All of the backups that were performed within the specified timeline appear in the save sets table.

   2. From the save sets table, select the save set with the timestamp that you want to restore.

      Click < < Older or Newer > > to browse additional save sets.

   NOTE:You cannot perform a PIT restore of multiple databases.
7. (Optional) To select the backup timestamp, perform the following steps
   By default, the most recent timestamp is used.
   1. Click Timeline.
      The Backup Timeline dialog box appears, as shown in the following figure.

      

   2. Select the backup timestamp, and then click OK.
8. Choose the location where the backup is restored to:
   • To perform a recovery directly to the database, perform the following steps:
     1. Select Restore to SQL Server.
     2. From the Instance list, select the instance where you want to restore the database.

        You can restore the database to the source instance or an alternate instance.

        If you are restoring the database to an instance on a remote Microsoft SQL Server that is not listed, perform the following steps:

        1. From the Instance list, select Browse for more.

           The Connect to Server window appears.

        2. In the Connect to Server window, beside Server Name, click ... to load the Microsoft SQL Server Instances on the network.
        3. In the Server Name field, type the instance name or select the name from the list.
        4. From the Authentication list, select one of the following authentication modes to connect to the Microsoft SQL Server:
           • Select Windows Authentication when you are restoring to a host in the same domain.
           • Select SQL Server Authentication when you are restoring to a host in a different domain
        5. Type the login credentials in the Login and Password fields.
        6. To access the SQL Agent Service with a proxy user, under Proxy User Of SQL Agent, type the login credentials in the User Name and Password fields. You must type the username in the format of Domain Name\User Name.

           Specify the proxy user credentials if the SQL Agent Service user does not have sufficient permissions to perform a restore operation or if you want to perform restore as a different user.

           If the SQL Agent Service on the target server uses a Windows Domain account and you select Windows Authentication, the proxy user credentials are optional.

        7. Click OK.
     3. From the Database list, select the database where the backup will be recovered to.
   • To perform a flat-file recovery, perform the following steps:
     1. Select Restore backups as files.
     2. In the Folder field, specify the destination for the files. The Folder field is populated with the default destination path.
9. To start the restore operation, click Run.