mirroring

• charipg

  SSCrazy Eights

  Points: 9888

  More actions

  July 20, 2009 at 6:31 am

  #136369

  what is the systemtable for storing records of datbase mirror states?

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  July 20, 2009 at 7:52 am

  #1026948

  There is a view that you can query

  select * from sys.database_mirroring

  you can read more about the mirroring catalog views on

  http://msdn.microsoft.com/en-us/library/ms178655(SQL.90).aspx"> http://msdn.microsoft.com/en-us/library/ms178655(SQL.90).aspx