Is there a maximum limit on Differential backups?

[SQL_ME_RICH]

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

[stanori]

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

[SQL_ME_RICH]

That's kinda what I thought, but just wanted to confirm.

Thank you!