How to detect that the SQLServer is shutting down i.e Shut down in Progress

• tapas.sharma

  SSC Enthusiast

  Points: 197

  More actions

  December 1, 2014 at 9:01 pm

  #312823

  I have a service that monitors SQL Server's always on Group status. When I bring down my SQL Server setup for planned downtime testing, my application keeps getting errors as follows

  "SHUTDOWN is in progress. (Err:6005, State:2 Severity:14); "

  I do not see this error in my monitoring script, so the monitoring service feels everything is ok.

  Is there a way where I can detect that the Shutdown has started on the server by using TSQL.

• Perry Whittle

  SSC Guru

  Points: 233892

  More actions

  December 3, 2014 at 5:51 am

  #1762324

  if the service is shutting down scripts will not be running.

  What you could do is run a SP at each service start, or capture the service state from the Windows OS, maybe using PowerShell

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉