How do you use cloud databases? Take the survey.
Options
Adding back an instance previously removed from cluster
Emiliano
Posts: 3 New member
Hi everyone,
we recently removed an instance from an always on availability group (removing the server from the cluster nodes).
The instance seemed to be correctly removed from SQL Monitor as it stop showing either in the "Global Dashboard" pane and in the "monitored server" config menu, but when I tried to put it back (this time as a standalone instance) SQL Monitor thrown an "Invaild Class' exception when it tries to detect Sql Server (the query via WMI shows green flag instead).
After that the server (but not the sql instance) is showing as "monitoring connected" in monitored servers config menu, while, for example, the instance is showing as still part of the availability group in the "Alert Inbox" pane (and elsewhere in the appliacation) and cannot be further monitored (old monitoring data still present).
Does anyone hit this scenario before?
Any possible clue as how to fix it?
Thanks
Tagged:
Answers
If removing the cluster from Monitor then re-adding it doesn't work, you can rebuild the cluster namespace in WMI but I'd recommend logging a Support ticket for that.
Yes, we tried to re-add the cluster (keeping the monitoring data!) with no luck, node still showed as part of the cluster in "Analysis" pane (no monitoring data).
It seems like SQL Monitor does not update cluster info correctly....
We also opened a support ticket
Root\MSCluster namespace in WMI correctly shows the remaining 2 nodes and not the evicted one:
Might it be something related to data still not being purged?