Restarting a SQL Server service in change pending state - SQL Server 2014

Question

_{Saturday, April 13, 2019 6:25 PM}

Hi,

I need to restart a SQL Server service in change pending state.

How can I accomplish a such task? Thanks

All replies (3)

_{Sunday, April 14, 2019 7:28 AM ✅Answered}

Hi,

I've followed this article and I've solved: Change pending state for SQL Server service

In particular, I've used this statement:

SHUTDOWN WITH NOWAIT

Thanks

---

_{Saturday, April 13, 2019 6:59 PM}

try check with windows team and reboot server.

https://social.technet.microsoft.com/wiki/contents/articles/37872.sql-server-installation-on-centos-linux.aspx

---

_{Saturday, April 13, 2019 9:14 PM}

What do you mean with "change pending state"?

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se