what command do you put into a bat file to shut down and
restart the sql server. I have "net stop mssqlserver" to
stop it wrks using the run command but not in my batch
file. What is missing?

Why are you shutting down sql server just to do a backup?

--

Andrew J. Kelly
SQL Server MVP


"Jim" <datatech (AT) bbna (DOT) com> wrote

Jim,
Andrews got a good point why are you shutting down the SQL to do a backup.
You should be backing up the SQl data via the sql backup command. This
ensures that all data is backed up correctly. Doing a system backup doesn't
give you the best options for backing up SQL.

My preference for SQL backups is this
Transaction backups to disk every hour during working hours
Full backup to disk after working hours (10:00pm)
Backup system to tape after SQL full backup (111:00pm)

You should be using a MP to run your backups. Also remember to backup the
system databases at least once a week.


--
I hope this helps
regards
Greg O MCSD
SQL Scribe Documentation Builder
Document any SQL server database in minutes
Programmers love it, DBA dream of it
AGS SQL Scribe download a 30 day trial today
http://www.ag-software.com/ags_scribe_index.asp


"Jim" <datatech (AT) bbna (DOT) com> wrote