Is there a maximum limit on Differential backups?

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Is there a maximum limit on Differential backups?

Postby SQL_ME_RICH » Mon Jul 02, 2012 7:44 pm

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
SQL_ME_RICH
 
Posts: 64
Joined: Tue May 08, 2012 10:41 pm

Postby stanori » Tue Jul 03, 2012 9:05 pm

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
stanori
 
Posts: 84
Joined: Mon Apr 23, 2012 1:13 pm

Postby SQL_ME_RICH » Tue Jul 03, 2012 9:19 pm

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

Thank you!
SQL_ME_RICH
 
Posts: 64
Joined: Tue May 08, 2012 10:41 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests