June 16, 2022 at 9:20 pm
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?
June 17, 2022 at 1:56 pm
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
June 17, 2022 at 2:04 pm
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!
June 17, 2022 at 11:43 pm
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply