Search
InstantDoc ID
GO

Browse By: Author | Issue

November 26, 2002 07:26 PM

Shutting Down SQL Server

Rating: (0)
Michael Otey
SQL Server Magazine
InstantDoc ID #26937
SQL Server is one of the most reliable database systems available. But no matter how reliable your system is, you occasionally need to shut it down for a variety of reasons, including planned maintenance or relocation. Closing Windows causes SQL Server to shut down, but if that's not an option for you, here are seven other ways that you can shut down SQL Server.

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

Please can you give more details about stopping named instance of a clustered server from command prompt or any batch file.

Anonymous User 8/5/2005 12:00:49 AM

I have found that the SC utility does not stop SQL Server Remotely. Running SC from a windows NT4 Server attempting to stop MS SQL Server 2000 on another NT4 Server does not work when issuing this command...

SC \\\\Servername "mssqlserver"

Anonymous User 12/20/2004 2:53:33 AM

There's yet another way - use the SC command from a command prompt - for example SC stop mssqlserver. You can even do this remotely by including the server name - for example - SC \\\\myserver stop mssqlserver

Bill L'Hotta 12/2/2002 12:16:12 PM

You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.