title

description

author

ms.author

ms.date

ms.service

ms.subservice

ms.topic

helpviewer_keywords

Start Database Mirroring Monitor (SSMS)

Describes how to start the Database Mirroring Monitor within the SQL Server Management Studio (SSMS) GUI.

MikeRayMSFT

mikeray

03/14/2017

sql

database-mirroring

ui-reference

monitoring database mirroring [SQL Server]

Database Mirroring Monitor [SQL Server], starting

database mirroring [SQL Server], monitoring

Start Database Mirroring Monitor (SQL Server Management Studio)

[!INCLUDE SQL Server] The Database Mirroring Monitor is part of the [!INCLUDEssNoVersion] Monitor, which is launched from [!INCLUDEssManStudioFull].

Note

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

After connecting to the principal server instance, in Object Explorer, click the server name to expand the server tree.
Expand Databases, and select the database to be monitored.
Right-click the database, select Tasks, and then click Launch Database Mirroring Monitor.
In the Database Mirroring Monitor dialog box, click Register Mirrored Database to register one or more mirrored database.

[!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.

Provide feedback