CODEWITHSUNDEEP
sql-server-2005t-sqldatabase-mirroring
Manjot
Manjot

Reputation: 11526

TSQL to know if database mirroring is setup for both PRimary and secondary server

I have Database mirroring setup between two SQl 2005 servers (no witness). Using Tsql, I want to find if there is a user database on both primary and mirror server. I can use the following on mirror:

select * from sys.databases where state <>1 and database_id>4

What should i use for Primary server?

Upvotes: 1

Views: 5853

Answers (2)

Dinesh vishe
Dinesh vishe

Reputation: 3608

Kindly find Data using Following Query :-

**SELECT DB_NAME(database_id) AS Database_Name,

mirroring_state_desc,

mirroring_role_desc,

mirroring_safety_level_desc,

mirroring_partner_name,

mirroring_witness_name,

mirroring_witness_state_desc,

mirroring_failover_lsn

FROM sys.database_mirroring

WHERE mirroring_state IS NOT NULL;**

Upvotes: 0

gbn
gbn

Reputation: 432667

Use the dmvs associated with database mirroring

For example, sys.database_mirroring

Upvotes: 3

Related Questions