You could write a powershell script that queries the mounted status of the databases and have it send you an e-mail or a text message if the state goes to dismounted. You can then schedule the powershell script to execute every few minutes or so using scheduled tasks.
The way I approached it in my 2007 environment was to export the results of the powershell command Michael posted to a CSV file one of the Hub Transport servers using a scheduled powershell script. Then on the Hub Transport server I had another powershell script that would import the contents of the CSV file to an array, apply some logic to exempt any recovery databases, and send our Exchange Admin list and our cell phones an e-mail if the state of any of the databases went to dismounted. The solution wasn't perfect, but it worked for our needs up until we moved to 2010, when we also added System Center Operations Manager to the environment. Now it handles all of the alerts for us. --Anthony Anthony Goraczko University Technology Services Division of Information Technology Florida International University ________________________________ From: Paul Cookman [[email protected]] Sent: Friday, December 10, 2010 6:11 AM To: MS-Exchange Admin Issues Subject: mounted/dismounted Any good free ideas for monitoring ex2007 databases being mounted/dismounted? --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected]<mailto:[email protected]> with the body: unsubscribe exchangelist --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe exchangelist
