Differential backup

This may be obvious but i can't find any official word about this so...
Background:
We are using a weekly backup and a couple of differential backup daily on
sqlserver 2000 using BackupExec. According to BOL the backup works as
follows:
"Database – differential
Perform a differential database backup. A differential backup records only
the changes made to the data in the database after the last full database
backup."
Beside these normal backups, we would like to make additional full database
backups to harddrive daily.
Question:
Will the extra backups interfere with the normal backups to tape by
resetting "the last full database backup" iaw will the next differential
backup start from that full backup to the harddrrive then? We would like to
see the normal (tape) backup being undisturbed by the extra full backups.
Can anyone clear this up for me please? When you restore a diff backup, you must first have restored the most recent
database backup prior
to that diff backup. IT doesn't matter whether that database backup was to d
isk and the diff backup
is to tape (or vice versa).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Hans" <Hans@.discussions.microsoft.com> wrote in message
news:BA274B88-5E90-4799-8B9A-8F3979418051@.microsoft.com...
> This may be obvious but i can't find any official word about this so...
> Background:
> We are using a weekly backup and a couple of differential backup daily on
> sqlserver 2000 using BackupExec. According to BOL the backup works as
> follows:
> "Database - differential
> Perform a differential database backup. A differential backup records only
> the changes made to the data in the database after the last full database
> backup."
> Beside these normal backups, we would like to make additional full databas
e
> backups to harddrive daily.
> Question:
> Will the extra backups interfere with the normal backups to tape by
> resetting "the last full database backup" iaw will the next differential
> backup start from that full backup to the harddrrive then? We would like
to
> see the normal (tape) backup being undisturbed by the extra full backups.
>
> Can anyone clear this up for me please? |||Hi Hans,
Full database backup will make differential backups to be daily, which is
not what you want to achieve. Consider daily full database backup and
backups of transaction log hourly.
Regards,
Daniel
"Hans" <Hans@.discussions.microsoft.com> wrote in message
news:BA274B88-5E90-4799-8B9A-8F3979418051@.microsoft.com...
> This may be obvious but i can't find any official word about this so...
> Background:
> We are using a weekly backup and a couple of differential backup daily on
> sqlserver 2000 using BackupExec. According to BOL the backup works as
> follows:
> "Database - differential
> Perform a differential database backup. A differential backup records only
> the changes made to the data in the database after the last full database
> backup."
> Beside these normal backups, we would like to make additional full
database
> backups to harddrive daily.
> Question:
> Will the extra backups interfere with the normal backups to tape by
> resetting "the last full database backup" iaw will the next differential
> backup start from that full backup to the harddrrive then? We would like
to
> see the normal (tape) backup being undisturbed by the extra full backups.
>
> Can anyone clear this up for me please?