Is there a way to set a program to stop/start sql services

[jdavis37]

I'm using a Web Inspector program which needs SQL to run. I'm using SQL ver 6.5. I need to start running a backup on this server. I was wondering if there's a way to run a batch file or something to stop/start the services at a certain time.

I'm in a novell environment.

 

[MDXer]

you can run the following 2 commands to start and stop. These can be ran from the command propmpt or a batch file.

net stop mssqlserver

net start mssqlserver

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[jdavis37]

This will stop all sql services..Can I use the AT command to do this? Thanks

 

[JayKusch]

Yes you can use AT commands. Here is a brief link on the subject.

http://vyaskn.tripod.com/restart_sql_server_service.htm

Thanks

J. Kusch

 

[jdavis37]

thanks

 

[jdavis37]

Thanks for the information. Although, I setup a *.bat file and setup it up to run everyday with the AT command wizard. The services didn't stop completely. The screen was open to a dos prompt with a y/n question asking if I'm sure I want to stop this service. Can you tell me what parameter I should include in the *.bat file?

 

[JayKusch]

i believe it is /y

Thanks

J. Kusch

 

[JayKusch]

May be an upper case Y as in ... /Y

Thanks

J. Kusch

 

[jdavis37]

Where should I place the Y?

 

[JayKusch]

net stop mssqlserver /Y

do not need on for the start net of course.

Thanks

J. Kusch

 

[jdavis37]

thanks,

I'll try this.

 

[TheBugSlayer]

It is /YES.

 

[jdavis37]

Yes,,,,Thanks! It worked.