SQL Server service hung in stopping mode

This week I am going to tell you a story. A story of a friend of mine who always come up with thing or two and help me find a topic for a blog post.  Earlier last week, he had one more issue, while he was performing some changes to his production server. It needs a restart of SQL Server. And, his bad luck strike again. Just like he do every time. He call me. The issue was the SQL Server service hung in stopping mode.

Fixing the issue, SQL Server service hung in stopping mode

Option 1: Do a quick reboot of a server and it will be back to normal

Option 2: Take another approach

My friend was not lucky enough, he doesn’t have luxury to reboot the server. Basically, the server is hosting an IIS as well. So, he was left with only option 2. And, that was killing the service using Windows Command called SC.

Here is how the issue was fixed

  1. Open the command prompt
  2. Run SC QueryEx <SQL Service Name>
  3. Get PID for offending service or instance name
  4. run taskkill /PID <PID#>  /f

This has kill the Process ID/SQL Server process that my friend having an issue with and this is how we have fixed SQL Server service in stopping mode.

2 Responses

Leave a Reply

Your email address will not be published. Required fields are marked *

Hemantgiri Goswami

Hemantgiri Goswami

Throughout my extensive 24-year tenure in the IT industry, I have honed my expertise in SQL Server and cloud technologies. My qualifications include certifications in ITIL, Azure, and Google Cloud, and my professional journey boasts a consistent record of delivering top-notch, dependable, and efficient solutions across diverse clients and domains. In recognition of my dedication and impact, I am honored to have received the Microsoft MVP award for SQL Server on six occasions. Additionally, I actively contribute to various online forums and blogs, acting as a moderator and facilitator of meaningful discussions. My ultimate mission revolves around empowering organizations to enhance the reliability and efficiency of their SQL Server implementations while fostering a culture of continuous learning and growth within the SQL Server community.