How can we help you today? How can we help you today?

Alert not raised on database in Recovery mode

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?
administrator
0

Comments

1 comment

Sort by
  • Ben_P
    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.
    Ben_P
    0

Add comment

Please sign in to leave a comment.