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
Sign In or Register to comment.