HeavenCore | IT Solutions Built on Open Source Software
View Thread
 Print Thread
SQL Mirroring - List State & Role of each mirrored database
admin
Quick query to list the State & Role of each mirrored database - handy if you want to generate your own alerts / monitoring code:


SELECT  DB_NAME(database_id) AS 'Database' ,
        mirroring_role_desc ,
        mirroring_state_desc
FROM    sys.database_mirroring
WHERE   mirroring_guid IS NOT NULL ;

Jordon Pilling | Heavencore Administrator
 
Jump to Forum