SQL Server Performance

Get basic Database Mirroring information- principal or mirror

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 19, 2007.

  1. Anonymous New Member

    SELECT DB_NAME(database_id) AS 'DatabaseName' , mirroring_role_desc , mirroring_safety_level_desc , mirroring_state_desc , mirroring_safety_sequence , mirroring_role_sequence , mirroring_partner_instance , mirroring_witness_name , mirroring_witness_state_desc , mirroring_failover_lsn FROM sys.database_mirroring WHERE mirroring_guid IS NOT NULL; Also you could take help of another catalog view for the Witness server information by returing relevant descriptive session information about the witness...(<a href="http://sqlserver-qa.net/blogs/tools/archive/2007/08/19/get-basic-database-mirroring-information-principal-or-mirror.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1569" width="1" height="1">

Share This Page