Alert not raised on database in Recovery mode

administratoradministrator Posts: 11 Bronze 1
in Redgate Monitor
Wouldn't a databse in recovery mode be consided NOT ONLINE and therefore raise the alert for Database unavailable? If this is not the case, what database status' are considered "ONLINE". I'm asking because I had a secondary database in Initializing/Recovery mode so a failover would have failed but we were never alerted that the database was not available. Why?
As soon as I changed the database to RESTORING I got an alert. How is RESTORING "Not Available" but IN RECOVERY is "Available?
Any suggestions?
Tagged:
· Share on Twitter

Answers

  • Ben_PBen_P Posts: 237 Silver 2
    Looking at the configuration for the alert, the settings appear to be setup so that the alert is triggered after a Database has gone into a state other than online for more than 30 seconds. 
     
    From the screenshot that you sent, we can see that the alert triggered on 21 Sept 06:49 and based on the sampling of the DB this is when it was first recorded as going into recovery mode. 
     
    So it seems the alert did trigger from the database going into recovery mode.
    · Share on Twitter
Sign In or Register to comment.