patternsqlMinor
History of cluster failover
Viewed 0 times
clusterfailoverhistory
Problem
Is it possible to get a history of when a cluster failed over and which node became the active node?
Solution
Is it possible to get a history of when a cluster failed over and which node became the active node?
That depends on how your define "history". There will be, in the cluster log, system log, and potentially sprinkled in other logs depending on a few things, the events that show a failover has occurred. For example, in the event logs you might search for event 1069 which would tell you that a resource failed in the cluster.
However, logs don't go back until the beginning of time. So if it's extremely recent history you're after then you might be ok. If you're looking at since inception, the answer is, nope you can't if you weren't already capturing this data.
Extended note: It also depends on how you define failover, as per manual or automatic. Additionally if you have the SQL Server engine errorlog, you can parse it to find when the node name is not the same after startup (FCI failover) or the line items for role synchronization changes (AG).
That depends on how your define "history". There will be, in the cluster log, system log, and potentially sprinkled in other logs depending on a few things, the events that show a failover has occurred. For example, in the event logs you might search for event 1069 which would tell you that a resource failed in the cluster.
However, logs don't go back until the beginning of time. So if it's extremely recent history you're after then you might be ok. If you're looking at since inception, the answer is, nope you can't if you weren't already capturing this data.
Extended note: It also depends on how you define failover, as per manual or automatic. Additionally if you have the SQL Server engine errorlog, you can parse it to find when the node name is not the same after startup (FCI failover) or the line items for role synchronization changes (AG).
Context
StackExchange Database Administrators Q#244849, answer score: 7
Revisions (0)
No revisions yet.