automatically stop/restart sql service - pete008

I would like to be able to automatically stop a sql service running on sql
2005 express, use a script to transfer files over to another server and
restart the service automatically.

Any ideas of how I can do this?

You can use a batch file that does a net stop, copy and net start. - Jason Massie

You can use a batch file that does a net stop, copy and net start. Schedule
it with task scheduler.


--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio

When it does a copy and it's only copying one file, not the entire directory. - pete008

When it does a copy and it is only copying one file, not the entire directory.
The directory has 4 folders and 1 readme file and it is copying the readme
file.

Any ideas?

xcopy /SDocumentation for the other switches is available by running xcopy /? - Jason Massie

xcopy /S

Documentation for the other switches is available by running xcopy /?

--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio