Red Gate forums :: View topic - Is there a maximum limit on Differential backups?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Is there a maximum limit on Differential backups?

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
SQL_ME_RICH



Joined: 08 May 2012
Posts: 60

PostPosted: Mon Jul 02, 2012 7:44 pm    Post subject: Is there a maximum limit on Differential backups? Reply with quote

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
Back to top
View user's profile Send private message
stanori



Joined: 23 Apr 2012
Posts: 72

PostPosted: Tue Jul 03, 2012 9:05 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
SQL_ME_RICH



Joined: 08 May 2012
Posts: 60

PostPosted: Tue Jul 03, 2012 9:19 pm    Post subject: Reply with quote

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

Thank you!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group