Configure general restore settings
To configure SQL Server restore with the Microsoft app agent for Application Direct SSMS plug-in, you must first specify general restore options on the Database Restore > General page using the following steps:
- Open the Microsoft app agent for Application Direct window and go to the Database Restore > General page.
- 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.
- In the Data Domain Server field, select the Data Domain server that contains the backup.
- From the SQL Server host list, select the SQL Server host that is the source of the backup. Select the Windows cluster name in the case of federated backups.
- From the SQL Server Instance list, select the SQL Server instance that contains the databases that you want to restore.
- The databases located on the SQL Server instance appear in the database table below the SQL Server Instance field.
- From the database table, select either the entire 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 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.
- (Optional) To perform a point-in-time restore of a single database, perform the following steps:
- 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.
- From the save sets table, select the save set with the timestamp that you want to restore.
- Click < < Older or Newer > > to go to additional save sets.
- (Optional) To select the backup timestamp, perform the following steps:
- By default, the most recent timestamp is used.
- Click Timeline.
- The Backup Timeline dialog box appears.
- Select the backup timestamp, and then click OK.
- Choose the location where the backup is restored to:
- To perform a recovery directly to the database, perform the following steps:
- Select Restore to SQL Server.
- 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 SQL Server that is not listed, perform the following steps:
(1) From the Instance list, select Browse for more.
(2) The Connect to Server window appears.
(3) In the Connect to Server window, beside Server Name, click to load the SQL Server Instances on the network.
(4) In the Server Name field, type the instance name or select the name from the list.
(5) From the Authentication list, select one of the following authentication modes to connect to the SQL Server:
(a) Select Windows Authentication when you are restoring to a host in the same domain.
(b) Select SQL Server Authentication when you are restoring to a host in a different domain.
(c) Type the login credentials in the Login and Password fields.
iv. To access the SQL Server Agent Service with a proxy user, under Proxy User of SQL Server Agent, type the login credentials in the Username and Password fields. You must type the username in the format of Domain Name\Username. Specify the proxy user credentials if the SQL Server Agent service user does not have sufficient permissions to perform a restore operation or if you want to perform restore as a different user.
v. If the SQL Server Agent Service on the target server uses a Windows Domain account and you select Windows Authentication, the proxy user credentials are optional.
vi. Click OK.
b. From the Database list, select the database where the backup is recovered to.
- To perform a flat-file recovery, perform the following steps:
- Select Restore backups as files.
- In the Folder field, specify the destination for the files. The Folder field is populated with the default destination path.
- To start the restore operation, click Run.