Find Other Servers In Database Mirroring Configuration

Agent Jobs

By mikesdatawork on 2015-06-26 • ( Leave a comment )

Here’s some quick SQL logic to help you find the other Mirrord Server in the SQL Server Database Mirroring configuration.

use master;
set nocount on
select
'database' = DB_NAME(database_id)
, 'state' = mirroring_state_desc
, 'mirror role' = mirroring_role_desc
, 'partner server' = mirroring_partner_name
from
sys.database_mirroring
where
mirroring_guid is not null

Categories: Agent Jobs, Alerts, Automations, Backup & Restore, Command Prompt, Database Mail, Database Mirroring, ELI5, Error Solutions, Featured, Folder System, Forensics & Auditing, High Availability, Long Scripts, Management Studio, Notification, Powershell, Quick Fix, Scripts, Security, Short Scripts, SQL Stuff, TSQL, Work Arounds