Skip to content

start-database-mirroring-monitor-sql-server-management-studio.md

Latest commit

 

History

History
49 lines (38 loc) · 2.88 KB

start-database-mirroring-monitor-sql-server-management-studio.md

File metadata and controls

49 lines (38 loc) · 2.88 KB
title Start Database Mirroring Monitor (SQL Server Management Studio) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.prod_service high-availability
ms.component database-mirroring
ms.reviewer
ms.suite sql
ms.technology high-availability
ms.tgt_pltfrm
ms.topic conceptual
helpviewer_keywords
monitoring database mirroring [SQL Server]
Database Mirroring Monitor [SQL Server], starting
database mirroring [SQL Server], monitoring
ms.assetid 53165335-97ca-4f88-8e78-22f1839dee98
caps.latest.revision 20
author MikeRayMSFT
ms.author mikeray
manager craigg

Start Database Mirroring Monitor (SQL Server Management Studio)

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] 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.

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

See Also

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