curious_sqldba
SSC-Dedicated
Points: 36494
More actions
November 21, 2010 at 4:07 am
#143557
Under which system table can i find mirroring details like does it have a witness server and things like that. I know i could use db monitor but is there a dmv or system table where i can find this info?
Thanks
K9998
SSCommitted
Points: 1817
November 22, 2010 at 6:53 am
#1253715
Try sys.database_mirroring. This table contains a column called mirroring_witness_name.
November 22, 2010 at 12:25 pm
#1253950
this works. Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply