Logs on database mirroring

  • 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.

  • You can check from sys.database_mirroring

    M&M

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply