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!
Comments
Post a Comment