Backing Up SQL

Please Help.......
New to my place of employment and new to SQL. Due to funding issues, we would like to use NT Backup (2000 Server) and not use a third party software such as Veritas or ArcServe. Will NT Server 2k backup successfully back up SQL? Are there any tricks I sho
uld be aware of?
I am also new to SQL, any info would be greatly appreciated.
Yout best bet is to use native SQL backups to backup your databases to disk
and then simply backup these files using NTBackup. You will not be able to
backup the actual database files themselves when SQL Server is running
because they will be in use. Have a look in Books On Line for BACKUP
DATABASE and BACKUP LOG. The easisest way to create a backup job for your
databases would be to create a Database Maintenance Plan. Again, there are
details of this in BOL
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"davidpkrok" <davidpkrok@.discussions.microsoft.com> wrote in message
news:88EF9E31-76FE-471B-BCA8-BC634054B6FD@.microsoft.com...
> Please Help.......
> New to my place of employment and new to SQL. Due to funding issues, we
would like to use NT Backup (2000 Server) and not use a third party software
such as Veritas or ArcServe. Will NT Server 2k backup successfully back up
SQL? Are there any tricks I should be aware of?
> I am also new to SQL, any info would be greatly appreciated.