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

    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
    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
    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.


    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