Comprehensive data protection for all workloads
Post Reply
zoltank
Expert
Posts: 223
Liked: 35 times
Joined: Feb 18, 2011 5:01 pm
Contact:

Warning on SQL backup

Post by zoltank » Oct 26, 2015 4:01 pm

I have application aware image processing turned on and am backing up a SQL server which has two databases on it, one with circular logging turned on and one without. Veeam is set to truncate SQL logs. However, because it can't truncate the logs for the DB with circular logging, it gives me a warning.

Is there anyway to suppress that warning message?

foggy
Veeam Software
Posts: 18138
Liked: 1540 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Warning on SQL backup

Post by foggy » Oct 26, 2015 4:11 pm


zoltank
Expert
Posts: 223
Liked: 35 times
Joined: Feb 18, 2011 5:01 pm
Contact:

Re: Warning on SQL backup

Post by zoltank » Oct 26, 2015 4:13 pm

I'd still like the DB to be VSS processed. I just don't want the warning when Veeam can't truncate the logs.

foggy
Veeam Software
Posts: 18138
Liked: 1540 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Warning on SQL backup

Post by foggy » Oct 26, 2015 4:45 pm

What is the recovery model of the second database? In case it is Simple (actually, no sense in having it Full unless you backup logs for point-in-time recovery), you can set the job to not truncate logs or perform copy-only backup to avoid warnings.

zoltank
Expert
Posts: 223
Liked: 35 times
Joined: Feb 18, 2011 5:01 pm
Contact:

Re: Warning on SQL backup

Post by zoltank » Oct 26, 2015 4:57 pm

The second DB is simple.

So far as I know, log truncation is a per VM setting and the DB with logging enable (full recovery mode) requires its logs to be truncated.

foggy
Veeam Software
Posts: 18138
Liked: 1540 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Warning on SQL backup

Post by foggy » Oct 26, 2015 5:16 pm

Right, log truncation is only needed for databases in Full recovery mode, in Simple mode SQL manages the logs automatically.

zoltank
Expert
Posts: 223
Liked: 35 times
Joined: Feb 18, 2011 5:01 pm
Contact:

Re: Warning on SQL backup

Post by zoltank » Oct 26, 2015 5:20 pm

There are two DBs on the SQL server I'm backing up. One is simple recovery and the other is full recovery. Therefore Veeam's log truncation is required, but it then throws the warning because of the DB set to simple recovery.

foggy
Veeam Software
Posts: 18138
Liked: 1540 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Warning on SQL backup

Post by foggy » Oct 26, 2015 5:23 pm

Ah, got it. But what is the reason of having Full recovery for the other one? Seems you are not backing up logs...

zoltank
Expert
Posts: 223
Liked: 35 times
Joined: Feb 18, 2011 5:01 pm
Contact:

Re: Warning on SQL backup

Post by zoltank » Oct 26, 2015 5:26 pm

Veeam is backing up the logs when it backs up the VM.

foggy
Veeam Software
Posts: 18138
Liked: 1540 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Warning on SQL backup

Post by foggy » Oct 26, 2015 5:43 pm

Ah, so it does backup logs. OP says "Veeam is set to truncate SQL logs", that's why I thought there's no reason in Full recovery model.

As far as I know, there should be a registry value to exclude databases from logs backup as well. Please contact support for details.

zoltank
Expert
Posts: 223
Liked: 35 times
Joined: Feb 18, 2011 5:01 pm
Contact:

Re: Warning on SQL backup

Post by zoltank » Oct 26, 2015 5:54 pm

Veeam does truncate the logs, but after the backup.

foggy
Veeam Software
Posts: 18138
Liked: 1540 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Warning on SQL backup

Post by foggy » Oct 26, 2015 8:34 pm

Right, backup includes subsequent truncation, but still it was not initially clear from the post which option was selected in the job. Nevermind, please let us know whether you manage to address this with the help of support. Thanks.

Post Reply

Who is online

Users browsing this forum: No registered users and 51 guests