Logs on database mirroring

• rgarayia

  Old Hand

  Points: 339

  More actions

  November 21, 2011 at 6:10 pm

  #252321

  Hi,

  We have database mirroring setup for about 50 databases on our 2005 servers. Recently one of our database had a status of suspended. And we didn't know until we looked at the SQL Management Console. My question is if a database gets suspended does this information gets written to any logs so that we can monitor and alert whenever that happens for any databases?

  Your help would greatly appreciated.

• M&M

  SSC-Insane

  Points: 21700

  More actions

  November 21, 2011 at 10:18 pm

  #1411198

  You can check from sys.database_mirroring

  M&M