Full and Incremental SQL backups
Created: 25 Feb 2013 | Updated: 04 Apr 2013 | 3 comments
This issue has been solved. See solution.
Is there any way of performing Daily Incremental and then Weekly Full backups within the same SQL backups policy.
From past experience I would say no, but am being challenged and starting to doubt myself :-)
So would be good to get some re-assurance.
Hope you can help
Cheers
Nick
Operating Systems:
Discussion Filed Under:
Comments 3 Comments • Jump to latest comment
I have done exactly that for a customer a couple of months ago.
Because of size of database, daily full backups cannot be done.
We configured weekly fully, daily incrementals, hourly log backups.
All worked fine. There was a bit of an issue with restore due to a 7.5.0.4 bug, but got fixed with EEB (now fixed in 7.5.0.5).
Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links
Hello,
Unfortunately, you cannot mix SQL differential, transaction logs and full backups within the same policy for a simple reason: each of those method will need a specific .bch script as the backup target. Thus, you need at least 3 policies.
Also, please note that the SQL master database do not support the differential method (you need to explicitly exclude it on the .bch script).
SQL differential are working great, I'm using them every days, but it will require SQL 2005 or later.
Authorised Symantec Customer ;)
As well as a policy for each bch file remember to alow have Weekly, Monthly and Annual policies as the backups take their retention period from the default application schedule and not your automatic schedule
So I am afraid that for SQL you need many policies
Authorised Symantec Consultant
Don't forget to give a "Thumbs Up" or mark as "Solution" if someones advice has helped you.
Would you like to reply?
Login or Register to post your comment.