selectstarfromyogi

sql server DBA ,sql server 2008 , 2012 , 2014 ,sql

Menu
Search
Skip to content
  • Home
  • About

stopping service

SQL Server service is in stopping mode or in the pending state.

we have seen this issue for the SQL servers running on VM, whenever forced reboot occurred / unexpected shutdown happens.

A reboot can fix this issue but without a reboot, we can fix it.

Fix is :

  1. From the command prompt Run SC QueryEx MSSQLServer
  2. Get PID for the output
  3. run taskkill /PID PID# /f , to kill Hung process.

 

May 1, 2020yogigollapudi hung state, pending state, stopping service Leave a comment

Categories

  • DEVOps (1)
  • Errors (9)
  • FUN (1)
  • Performance Tuning (11)
  • powershell (12)
  • T-SQL (43)
  • Uncategorized (154)

Blog Stats

  • 39,566 hits
Follow selectstarfromyogi on WordPress.com
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • selectstarfromyogi
    • Already have a WordPress.com account? Log in now.
    • selectstarfromyogi
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
Design a site like this with WordPress.com
Get started