Video Screencast Help

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:

Comments 3 CommentsJump to latest comment

Marianne's picture

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

Fabrice P.'s picture

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 ;)

SOLUTION
Mark_Solutions's picture

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 "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.