Start Database Mirroring Monitor (SQL Server Management Studio)

Start Database Mirroring Monitor (SQL Server Management Studio)

 

Applies To: SQL Server 2016

The Database Mirroring Monitor is part of the SQL Server Monitor, which is launched from SQL Server Management Studio.

System_CAPS_ICON_note.jpg Note


Database Mirroring Monitor is not available in every edition of MicrosoftSQL Server. For a list of features that are supported by the editions of SQL Server, see Features Supported by the Editions of SQL Server 2016.

To launch the Database Mirroring Monitor

  1. After connecting to the principal server instance, in Object Explorer, click the server name to expand the server tree.

  2. Expand Databases, and select the database to be monitored.

  3. Right-click the database, select Tasks, and then click Launch Database Mirroring Monitor.

  4. In the Database Mirroring Monitor dialog box, click Register Mirrored Database to register one or more mirrored database.

    System_CAPS_ICON_note.jpg Note


    When you register a database at one partner, the database is automatically registered at the other partner. If the monitor already has connection credentials for the other partner instance, those are used to connect. Otherwise the monitor attempts to connect using Windows Authentication. If you want to change the credentials used to connect to either server instance, click Show the Manage Server Connections dialog box when I click OK.

For more information about Database Mirroring Monitor, see Database Mirroring Monitor Overview.

Database Mirroring (SQL Server)
Establish a Database Mirroring Session Using Windows Authentication (SQL Server Management Studio)

Community Additions

ADD
Show:
© 2016 Microsoft