Backing up Windows Server with SQL server installed

I'm trying to find a way to shutdown the SQL server service on a Windows
Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5.
I'm currently backuping the SQL server throught the SQL server maintenance
plans and it works fine.
Now when I try to backup the entire server with netbackup the SQL database
files are not getting backed up because they are open. We currently do not
have a SQL client agent license for the netbackup so I want to shut down the
SQL server durning the netbackup process and turn it back on after.
I have tried to use net stop and start but SQL seems to restart on it's own
before the backup process is finished. Does anyone know of another method
to shut down the SQL server gracefully and start it back up again through a
batch file or script ? Any help would be great.
Thank you
Chris IThis is the wrong way to back up SQL Server database files. Either you run
a sp_detach_db statement first, then back up the files, or you use the
standard BACKUP T-SQL commands. Stopping the service and backing up the
files is wrong.
--
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Use MiniSQLBackup Lite, free!
"Chris I" <dmagic@.nycap.rr.com> wrote in message
news:%23$ekzEmpEHA.1952@.TK2MSFTNGP12.phx.gbl...
> I'm trying to find a way to shutdown the SQL server service on a Windows
> Server 2003, SQL server 2000 SP3. Veritas Netbackup 4.5.
> I'm currently backuping the SQL server throught the SQL server maintenance
> plans and it works fine.
> Now when I try to backup the entire server with netbackup the SQL database
> files are not getting backed up because they are open. We currently do
not
> have a SQL client agent license for the netbackup so I want to shut down
the
> SQL server durning the netbackup process and turn it back on after.
> I have tried to use net stop and start but SQL seems to restart on it's
own
> before the backup process is finished. Does anyone know of another method
> to shut down the SQL server gracefully and start it back up again through
a
> batch file or script ? Any help would be great.
> Thank you
> Chris I
>