| title | Start Database Mirroring Monitor (SQL Server Management Studio) | Microsoft Docs | |||
|---|---|---|---|---|
| ms.custom | ||||
| ms.date | 03/14/2017 | |||
| ms.prod | sql-server-2016 | |||
| ms.reviewer | ||||
| ms.suite | ||||
| ms.technology |
|
|||
| ms.tgt_pltfrm | ||||
| ms.topic | article | |||
| helpviewer_keywords |
|
|||
| ms.assetid | 53165335-97ca-4f88-8e78-22f1839dee98 | |||
| caps.latest.revision | 20 | |||
| ms.author | mikeray | |||
| manager | jhubbard |
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.
Database Mirroring (SQL Server)
Establish a Database Mirroring Session Using Windows Authentication (SQL Server Management Studio)