Step 4 (Guest VM): Restore a database

To verify that you correctly configured application protection, restore a database with Data Protection for Microsoft SQL Server.

Before you begin

Ensure that the required services are running on the guest virtual machine (VM):

At the command prompt, issue the following command:
```
services.msc
```
Locate IBM Storage Protect Recovery Agent Service in the list of services and, if necessary, start the service.
Locate Microsoft iSCSI Initiator Service in the list of services. If necessary, change the startup type to Automatic and start the service.

Complete the following steps on the guest VM:

Start the Data Protection for Microsoft SQL Server Management Console.
Select an SQL Server instance in the tree.
Navigate to the Recover tab, and click Refresh.
Select a database entry that has the VMVSS backup method.
In the Action pane, click Restore to Alternate Location. Specify a new database name and a new location where the database will be restored.
In the Action pane, click Restore.
When the restore operation is complete, review the database and any related tables.

You can now manage backups and recover data if necessary. For more information, see:

If you change the name of the guest VM after you completed the configuration steps for application protection, you must reconfigure the software with the new VM name. For instructions, see Optional: Configuring application protection after a virtual machine name change.