This is not a true statement. A differential backup saves everything since
the last full backup. For example I do a full backup at midnight. I do a
differential at 3AM, 6AM, and 9AM. The server crashes. I restore the full
backup, then the 9AM differential and I am back to the 9 AM status of the
db.

What you described below are transaction log backups!

Hope this helps.
Tom

-----Original Message-----
From: Charles Caroline [mailto:[Email Address Removed] Wednesday, July 10, 2002 7:51 AM
To: '[Email Address Removed] SS 2K differential backups


I need to implement a backup routine incorporating full and differential
backups for a SQL 2000 database.

If I do a nightly full backup and an hourly differential during the day
could anyone confirm that I need to APPEND each differential backup to the
backup media until the next full backup, in other words all that days
differentials would need to be applied in the event of recovery?

Thanks, Caroline.


____________________________________________________________________
"This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. This communication may contain material protected by
attorney-client privilege. If you are not the intended recipient or
the person responsible for delivering the email to the intended
recipient, be advised that you have received this email in error and
that any use, dissemination, forwarding, printing, or copying of this
email is strictly prohibited. If you have received this email in error
please notify the IT Call Centre by telephone on 44 (0) 1953 608000."

[Email Address Removed] unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page