SQL Error Log Informational Messages
crimdon
Posts: 54 Bronze 3
Every time I restart a secondary server, I get a load of the following alerts from SQL Monitor
Error: 35262, Severity: 17, State: 1.
Skipping the default startup of database 'xxx'' because the database belongs to an availability group (Group ID: 65536). The database will be started by the availability group. This is an informational message only. No user action is required.
Is there a way to filter these so they don't raise a load of alerts? The only option I'm currently faced with is turning the alert off completely.
Error: 35262, Severity: 17, State: 1.
Skipping the default startup of database 'xxx'' because the database belongs to an availability group (Group ID: 65536). The database will be started by the availability group. This is an informational message only. No user action is required.
Is there a way to filter these so they don't raise a load of alerts? The only option I'm currently faced with is turning the alert off completely.
Tagged:
Best Answer
-
Alex B Posts: 1,158 Diamond 4Hi @crimdon
Currently the only other option would be to increase the severity that triggers the alert to something that wouldn't trigger for those SQL Error Log entries. To do this go to Configuration > Alert settings > SQL Server error log entry (either for all servers or only those for which this occurs).
There are also some Uservoice entries related to this which you should vote on here and here
Kind regards,
Alex