PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

Perform SQL Server disaster recovery

The Microsoft application agent for Application Direct supports disaster recovery.

1. Create a target Windows host with the same name as the source hostname.
2. Install a SQL Server instance with the same name as the source instance name.
3. Install the Microsoft application agent on the target Windows host.
4. Browse the backups of the source instance by selecting the appropriate storage unit.
5. Restore the SQL system databases, such as databases named master, model, msdb, and so on, to the target instance.
6. Restore all the user databases to the target instance.