Thanks for the replies.I've got it clear now. For recovery purposes I need
my last full backup and my last differential. Got my differentials in a
muddle with my incrementals. Painful!
Caroline

> ----------
> From: Thomas Henley[SMTP:[Email Address Removed] Sent: 10 July 2002 11:35
> To: 'Charles Caroline'; '[Email Address Removed] Subject: RE: SS 2K differential backups
>
> 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] Sent: Wednesday, July 10, 2002 7:51 AM
> To: '[Email Address Removed] Subject: 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] http://www.lotuscars.co.uk
> http://www.lotuseng.com
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]
MS Sql Server LazyDBA home page