Backup-to-file SQL2k Question/NT Tape Backups

Dear All,
Hello!
Now that I am running a maintenance backup-to-file from
within SQL2K, should I just be backing up these
backup-to-file to an NT backup job? Or should I also be
backing up the live databases & their transact logs?
Thanks!
CarlosNormal practice would be to backup the backup files from SQL to tape. If you
are taking regular SQL backups, there is no need to backup the actual
database files themselves (which would require stopping SQL anyway as they
are always in use)
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Carlos" <anonymous@.discussions.microsoft.com> wrote in message
news:10ef101c3f49b$fb627db0$a001280a@.phx.gbl...
> Dear All,
> Hello!
> Now that I am running a maintenance backup-to-file from
> within SQL2K, should I just be backing up these
> backup-to-file to an NT backup job? Or should I also be
> backing up the live databases & their transact logs?
> Thanks!
> Carlos
>|||You don't have to backup the mdf, ndf and ldf files if you let SQL Server do
database and possibly transaction log backup to disk and then backup those
files to tape.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Carlos" <anonymous@.discussions.microsoft.com> wrote in message
news:10ef101c3f49b$fb627db0$a001280a@.phx.gbl...
> Dear All,
> Hello!
> Now that I am running a maintenance backup-to-file from
> within SQL2K, should I just be backing up these
> backup-to-file to an NT backup job? Or should I also be
> backing up the live databases & their transact logs?
> Thanks!
> Carlos
>