Force shutdown of SQL Server Instance

I have a problem with an instance of SQL Server that refuses to
respond to a shutdown request. I've managed to shutdown the SQL
Manager and DTC services but the sqlservr.exe process is permanently
in a "Stopping" state.

I cannot logon to the instance to issue a SHUTDOWN WITH NOWAIT
command. Short of rebooting the entire server, is there a way I can
force the process to end?

TonyHi

You may want to try and stop the service in the services applet or issue
a NET STOP command.

If you do not shut down the server cleanly there may be problems when
you try to restart the service.

John

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||There will never be problems from killing the process, shutting down the
machine, etc. However, the restart may be slower as recovery will be
required before user connections are allowed. Of course, the reason for
the slow shutdown may also be the rollback of a very long running
transaction.

On Fri, 19 Sep 2003 12:32:13 +0000, John Bell wrote:

> Hi
> You may want to try and stop the service in the services applet or issue
> a NET STOP command.
> If you do not shut down the server cleanly there may be problems when
> you try to restart the service.
> John
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Hi Hal

The poster was thinking of a hardware re-boot, which could cause hardware
related problems and other non-sql server problems. Put server instead of
service as the last word of the last sentence.

John

"Hal Berenson" <haroldb@.truemountainconsulting.com> wrote in message
news:pan.2003.09.21.03.51.13.628241@.truemountainco nsulting.com...
> There will never be problems from killing the process, shutting down the
> machine, etc. However, the restart may be slower as recovery will be
> required before user connections are allowed. Of course, the reason for
> the slow shutdown may also be the rollback of a very long running
> transaction.
> On Fri, 19 Sep 2003 12:32:13 +0000, John Bell wrote:
> > Hi
> > You may want to try and stop the service in the services applet or issue
> > a NET STOP command.
> > If you do not shut down the server cleanly there may be problems when
> > you try to restart the service.
> > John
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!