Force shutdown of SQL Server Instance

[Tony Hodgson]

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?

Tony

[John Bell]

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!

[Hal Berenson]

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.

[John Bell]

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" <har...@truemountainconsulting.com> wrote in message
news:pan.2003.09.21....@truemountainconsulting.com...