Blog Post

Query to determine mirrored database status

,

I am sharing today a SQL Script to quickly check on an instance which databases are in mirrored and their status.

select 
db.name,
db.state_desc,
dm.mirroring_role_desc,
dm.mirroring_state_desc,
dm.mirroring_safety_level_desc,
dm.mirroring_partner_name,
dm.mirroring_partner_instance
from sys.databases db
inner join sys.database_mirroring dm
on db.database_id = dm.database_id
where dm.mirroring_role_desc is not null
order by db.name
 
 
I hope you find this script useful! 

Rate

Share

Share

Rate