Sql service Error – Change Pending 15

Here, sharing my experience to deal with tricky situations while working with SQL SERVER. We came across very strange situation like when we done some configuration changes on UAT server for the testing of Bulk operations from application after doing the change, restarted SQL services using SQL Server Configuration Manager without disconnecting database sessions with UAT server but obvious not advised and absolutely not a good practice.

SQL Server Services Failed

SQL Server services are failed to restart due to active database session, Always disconnect all database session before restart services.

SQL Service Error – Change Pending

So while restarting the SQL services, it got hung as expected and showing status as “Change Pending”. Ohhho !!! SQL server is down, users will not able to connect, Application testing is on hold. Before it get escalated to Boss, DBA’s responsibility to brought SQL Server Online.

So we tried one more time restarting service but no luck, failed again. Funny SQL server tells you the problem but doesn’t tell you what needs to done to resolve such problem that’s why company hired us DBA to take care this type of issue.  To drill down issue, checked SQL server log why SQL Server is showing Change pending but didn’t find anything. Sometime it becomes very tricky to find the solution for such type of issue.

Suddenly mind strike and checked to find out whether SQL services are still running somewhere in memory, Best way to check running processes using TASK MANGER and found the sqlserver.exe in the list of running process and struck in memory.

So we decided to kill the sqlserver.exe process using task manager.

Good thing is after killing the process, services are started running smoothly.

Solution

Killed old process that was running in memory

 

Conclusion

Always disconnect all database session before restart services or applying any change to SQL Server

15 thoughts on “Sql service Error – Change Pending

  1. Reply Lambie Mar 17, 2013 3:56 am

    Wow! Thank you! I continually wanted to write on my site something like that. Can I take a part of your post to my website?

  2. Reply mieszkania warszawa Mar 18, 2013 8:00 am

    usually posts some very fascinating stuff like this. If you

  3. Reply pióra wieczne Mar 20, 2013 11:05 pm

    whoah this weblog is great i really like reading your posts. Stay up the good work! You recognize, many people are searching round for this information, you can aid them greatly.

  4. Reply Giva Mar 28, 2013 5:22 pm

    Your website is extremely helpful. Thank you for sharing!

  5. Reply Josh Pellicer Book Apr 4, 2013 12:37 am

    How come Sql service Error & made me laught so much? Oh dude I really enjoy this site. It is the first-time My spouse and I came upon it however I Dearly loved it.. Clearly will come back, you actually gotten tons of articles in there 😀 ok back to do the job right away 🙂

  6. Reply Irwin Barefoot Apr 4, 2013 11:35 pm

    I was studying some of your content on this internet site and I think this site is rattling informative ! Keep on putting up.

  7. Reply Sucharski Magarelli Apr 9, 2013 11:19 pm

    Remarkable issues here. I’m very glad to peer your article. Thank you so much

  8. Reply Raymond Dietze Apr 10, 2013 9:16 pm

    I must thank you for the efforts you have put in writing this website. I really hope to see the same high-grade content by you in the future as well. In fact, your creative writing abilities has motivated me to get my own site now 😉

  9. Reply Kia Hauskins Apr 17, 2013 8:03 pm

    Hi there! I could have sworn I’ve been to this site before but after looking at many of the posts I realized it’s new to me. Anyways, I’m certainly delighted I came across it and I’ll be bookmarking it and checking back regularly!

  10. Reply Roxana Mensing Apr 20, 2013 8:09 pm

    I need to to thank you for this fantastic read!! I definitely loved every little bit of it. I’ve got you book-marked to check out new things you post…

  11. Reply Delphia Genova Apr 22, 2013 11:05 pm

    Very nice post. I certainly appreciate this site. Thanks!

  12. Reply Solina noclegi Apr 23, 2013 2:24 pm

    Keep functioning ,remarkable job!

  13. Reply Francina Overbough Apr 26, 2013 6:54 pm

    Saved as a favorite, I like your website!

  14. Reply Rhonda Strawther May 3, 2013 3:15 am

    I drop a comment every single time I like a guide on a web page or if We have something to valuable to contribute on the conversation. It’s a result on the fire communicated in the post I browsed. And after reading this short article I was actually moved enough to drop a comment here

  15. Reply Jennifer V May 8, 2013 12:54 am

    I do agree with all of the ideas you’ve presented on your post. They are really convincing and can definitely work. Still, the posts are very brief for novices. May just you please lengthen them a little from subsequent time? Thanks for the post.

Leave a Reply

  

  

  


6 − = 5