SQL Service hanging with Change Pending Error

06 May,2016 by Jack Vamvas

Here’s a strange error I experienced when attempting to restart a SQL Server Service. The Service wouldn’t restart , the status was hanging on “Change Pending”.  

I’d seen this error before, but during installations. I hadn’t seen it when the service was established. I checked the SQL Server Error logs – which I had to access directly via the file system and read as a palin text file, as I couldn’t access SQL Server . There were no clues in the logs to suggest what may have caused this error.

I also checked the Applications sections of Windows Event Log and there wasn’t anything useful.

I then remembered there had been some changes over the weekend – causing loss of connectivity of the server to the network. So it was possible some issue had arisen , as a consequence.

As the server had not restarted , it suggested there was some residual activity running in the memory. Checked the TASK MANAGER – noticed sqlserver.exe was still running. Killed the process . I was able to start SQL Server OK

Read More on SQL Server Errors

SQL Server DBA: SQL Error Logs

SQL Server – Troubleshoot connectivity issues with Connectivity ...

 


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on SQL Service hanging with Change Pending Error


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer