What are the challenges you face when working across database platforms? Take the survey
Options

Is there a maximum limit on Differential backups?

SQL_ME_RICHSQL_ME_RICH Posts: 112
edited July 3, 2012 4:19PM in SQL Backup Previous Versions
Sorry for such a neophyte question, but I am wanting to know (aside from best practices - which I would never want to exceed nor challenge) if there is a default, maximum amount of Differential backups that can be run against a last good, known full? The reason I am asking is due to a migration that we are starting which is going to move one instance of databases to another server's instance, but the proof of concept that is wanted is to see if I was to take just one full - how many diffs can I run until another full is needed.

Thank you in advance, and again - just if there is an actual limit to how many diffs I can have before another full is needed is what I am needing to know.

SQL_ME_RICH

Comments

  • Options
    Hi SQL_ME_RICH,

    There is no hard limit on the actual number of differentials you can have before a full backup is needed. With that said, however, it is good practice to periodically perform a full backup for performance and consistency reasons.

    Best Regards,
    _________________
    Steve Tanori
    Product Support
    Red Gate Software Ltd.
    866-997-0378
  • Options
    That's kinda what I thought, but just wanted to confirm.

    Thank you!
Sign In or Register to comment.