When choosing whether a migration or disaster recovery strategy is best for your environment, consider if you want to permanently move the SQL Diagnostic Manager Repository or Services to another computer.

You can also choose to have the Repository and Console components located on computers that belong to different domains. This deployment option is advantageous during disaster recovery, especially if the only available computer is in another domain. Verify that a two-way trust exists between the target domains to support full communication between the Repository and consoles.

Goal

Action

Replace the SQL Diagnostic Manager Repository or Services computer

Migration

Repair the original Repository or Services computer

Recovery

In both cases, first backup and then restore the Repository database.


SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >