Backing up/restoring using hard disk or tape

Here is my situation:
I have a 2 node SQL 2000 enterprise cluster for which i need to backup
3 databases. Here is my plan. I've changed the recovery mode to Full
on all 3 databases and have performed complete backups. I've
scheduled a complete backup at midnight and differentials every hour
and t-logs every 15 minutes. As an alternate backup, I am backing up
to tape using Arcserve's SQL agent. The schedule for this is a
complete backup nightly, and differential every 4 hours. What I'm
unclear on is the truncation of t-logs. Do they auto truncate every
time a differential or complete backup is run? I'm worried that the
tape backup (when it runs) may contain some transactions that the SQL
backup to disk does not have and vice versa...is this true? I know
it simple recovery mode, the databases will auto truncate the t-log
after a backup but not sure what will happen or where to find the
setting for full recovery mode. I would assume that SQL would allow me
to create multiple backups of the same databases but I just cant find
out how/where...any help is greatly appreciated as we are deploying a
production server on Aug 31. TIA...
TonyA full/differential backup doesn't truncate the tran log.
Linchi
>--Original Message--
>Here is my situation:
>I have a 2 node SQL 2000 enterprise cluster for which i
need to backup
>3 databases. Here is my plan. I've changed the recovery
mode to Full
>on all 3 databases and have performed complete backups.
I've
>scheduled a complete backup at midnight and differentials
every hour
>and t-logs every 15 minutes. As an alternate backup, I
am backing up
>to tape using Arcserve's SQL agent. The schedule for
this is a
>complete backup nightly, and differential every 4 hours.
What I'm
>unclear on is the truncation of t-logs. Do they auto
truncate every
>time a differential or complete backup is run? I'm
worried that the
>tape backup (when it runs) may contain some transactions
that the SQL
>backup to disk does not have and vice versa...is this
true? I know
>it simple recovery mode, the databases will auto truncate
the t-log
>after a backup but not sure what will happen or where to
find the
>setting for full recovery mode. I would assume that SQL
would allow me
>to create multiple backups of the same databases but I
just cant find
>out how/where...any help is greatly appreciated as we
are deploying a
>production server on Aug 31. TIA...
>Tony
>.
>