Cant find witness server

  • 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

  • Try sys.database_mirroring. This table contains a column called mirroring_witness_name.

  • 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