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.