Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    23

    Unanswered: In restorc can U apply logs thru the time of another full backup?

    We run a disk backup (full) early in the evening, and then another bull backup to tape later at night. We also keep independent backups of the logs.

    It seems that any full backup "resets" the ability to apply logs when restoring?

    I want to be able to restore a full backup, and apply logs forward possibly more than 1 day, in case a backup is corrupted and not usable. But it seems I can only apply logs up until the time of the next full backup.

    Is this true, and is there a way around this?

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Full backups only affect differential backups. A Differential backup collects all database pages updated since the last full backup. Logs can be restored regardless of any intervening full or differential backup.

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    If you are using the wizard, then you will not be able to select the appropriate files. Switch to scripts and you should be okay.

    Having said that, I've never tried to do it.

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •