Windows Forum

Ask something
Discussion Locked

START & STOP MS SQL SERVER

0 helpful
7 replies

by danlebaron

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am running SQL Server on a windows 98 workstation. I need to have sql server and the sql server agent shutdown and restart at a specific time. What is the best way to do this and how??? Example shutdown at 9 pm and startup at 2 am.

7 replies

by tduval

Just make a .CMD command file, called with AT command, that make a NET STOP , then NTBAKCUP (if this is you problem), NET START

by oridjinn

you can create 2 batchs files to call the net stop in one and net start in the other. Then use "scheduled tasks" under Control panel, schedule one at 9pm to call the "net stop" batch file, and the other at 2am to call the "net start" batch file.

by oridjinn

you can create 2 batchs files to call the net stop in one and net start in the other. Then use "scheduled tasks" under Control panel, schedule one at 9pm to call the "net stop" batch file, and the other at 2am to call the "net start" batch file.

This discussion is closed to new replies.