May 13 2020 11:26 PM
Hello Everyone,
I need your support on the below scenario.
MS SQL SERVER instance is running on Windows Server 2012 R2.
Do I need to stop the ”MSSQLSERVER" service before restarting a Windows Server OS on Windows "shutdown /r" command or Windows GUI "Restart" to prevent data corruption?
I think the OS shutdown sequense runs "net stop SQL Server (MSSQLSERVER)" in the background and does a safe restart, is that correct?
Regards,
May 14 2020 06:48 AM
Generally speaking windows will wait 20 - 30 seconds for services to gracefully close. If you think more time is needed you can extend WaitToKillServiceTimeout
(please don't forget to mark helpful replies)