Please let me how can i know whether mirroring was used on a server

• smilewithrams-907484

  Valued Member

  Points: 63

  More actions

  June 5, 2009 at 12:47 pm

  #222245

  Hi all,

  Iam Ram i juzz want to find out is there any option that we can use to find whether mirroring was implemented on that server. and on the server it need to find out what are all databses that are misssing DB mirroring on those servers. i need to list out the servers and need to configure mirroring on them.

• DNA_DBA

  SSCrazy Eights

  Points: 9107

  More actions

  June 8, 2009 at 2:14 am

  #1005945

  you can see what databases are mirrored by looking in sys.database_mirroring.