SQL 2005 Incremental Backup

  • I have a concern. I take a backup at 8pm and differential backups at 10pm and 12am. I then plan to restore the full backup to another server followed by the differentials once they complete. When I restore the differential backup, do I have restore the full back plus the differential at 10pm and then the full backup and the differential at 12am? Or, since I restored the full backup at 8pm, just apply the differentials at 10 and 12?

    Thank you

  • You restore the full backup from 8am and the differential from 12. They're differential backups, not incremental.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • You need to restore FULL backup and latest DIFFERENTIAL backup. DIFFERENTIAL backup is cosolidated backup and capture all the pages changed since FULL backup.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply