how to schedule SQL service agent to stop and start? 1

[cooperchien]

My database is fragmented badly so I decide to defrage it daily. However, as long as the sql server is running, disk defrag will not defrag the portion of disk that used by SQL database.
Is there a way that I can schedule to stop and start the sql service?
Thanks for the help.

 

[mrdenny]

You can use the task scheduler to run a net stop then a net start to stop then restart the SQL Server.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

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

http://www.mrdenny.com