Finding when a SQL Failover Cluster Instance failed over....

  • I have a couple SQL 2019 FCI.

    Is there a way to find when a SQL Failover Cluster Instance failed over or if someone moved it from one node to another?

    I'd like to get the date, time and who did the move.

    Or is this kind of info only in the WSFC data?

  • The easy way is to look in the SQL Server error log. It'll tell you. You can also see it in the Windows event log. Pretty sure you automatically get an Extended Event session that shows information on the AG that will also have it, but I'm not 100% on that.

    ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software

  • I use a start up procedure to send me an email whenever the SQL instance starts up.  If someone failed it over, it will start up on another node.  Of course that doesn't address who did it.  Getting that is trickier, I think Grant's advice is best on that part of it.

    SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!

  • Do you have a "dummys" version instructions on how you setup the startup procedure?

    I've been out of SQL mgmt for a while and getting back into it.

    I found this: https://blog.sqlauthority.com/2014/06/13/sql-server-how-to-get-sql-server-restart-notification/?amp

    I'll try it this weekend

    Thanks

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply