Shutdown command file for MS SQL 2000

[bigdaver]

Hey guys. I just bought an APC Smart-UPS XL for the 2 servers at my work. The version of software that I got with it wont shut down MS SQL 2000 without a shutdown command file. I know quite a bit about computers but I don't know much about MS SQL. If someone could help me out that would be much appreciated.
Thanx,
Dave

 

[SQLBill]

I believe the command you want to use is:

net stop mssqlserver

Check it out in the BOL, use the Index tab, enter NET STOP.

-SQLBill

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

Posting advice: FAQ481-4875

 

[bigdaver]

thanx. I'll try that out.

 

[mrdenny]

Don't forget to stop the SQL Server Agent before you shut down the SQL Server. The command for that is "net stop SQLSERVERAGENT".

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[SQLBill]

Denny,

Stopping SQL Server service should automatically stop the SQL Server Agent since it is dependent on the SQL Server service.

-SQLBill

 

[mrdenny]

Yeah, it should, but I've sean it complain about it before, so it's good to stop it manually. Besides it's just one more line in a batch file.

Denny

--Anything is possible. All it takes is a little research. (Me)