>You can stop SQL Server service before backup and start after
>
>NET STOP MSSQLSERVER
>...
>NET START MSSQLSERVER
>
>
That probably is the most foolproof way to do it.
I'd look at letting SQL Server back up the database(s) using it's BACKUP DATABASE capability though - just point (or copy) the backups out to your external drive. This way the database stays running.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________
