Sometimes unplanned failover or restart is happened on SQL services in clustered environment then we need to know when the failover is happened or service is restarted to find this information we can go through the errorlog as stated below.
In the above image of errolog if the host name in both of the messages is the same then the SQL Server Service just restarted on the same host/node. If the host name is different then SQL Server failed over from that node to a new node.
Ref : Jugal Shah,
https://www.mssqltips.com/sqlservertip/2744/steps-to-check-the-host-name-for-a-clustered-sql-server-instance/
In the above image of errolog if the host name in both of the messages is the same then the SQL Server Service just restarted on the same host/node. If the host name is different then SQL Server failed over from that node to a new node.
Ref : Jugal Shah,
https://www.mssqltips.com/sqlservertip/2744/steps-to-check-the-host-name-for-a-clustered-sql-server-instance/
No comments:
Post a Comment