Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Start Database Mirroring Monitor (SQL Server Management Studio)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

Note Note

Database Mirroring Monitor is not available in every edition of Microsoft SQL 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.

    Note 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.

Community Additions

ADD
Show:
© 2015 Microsoft