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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
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