Host-based backup of VMware vSphere VMs.
Post Reply
millardjk
Expert
Posts: 114
Liked: 25 times
Joined: Dec 09, 2012 3:50 am
Full Name: Jim Millard
Contact:

Time to truncate?

Post by millardjk »

Simple question: should I be investigating further if the (nightly incremental) backup of a SQL server (with 15min log backups) takes 1:30 and Veeam spends 1:18 of it at the "Truncating transaction logs" stage?
PTide
Product Manager
Posts: 6408
Liked: 724 times
Joined: May 19, 2015 1:46 pm
Contact:

Re: Time to truncate?

Post by PTide »

Hi,

I suggest you to open a case with our support team because it's hard to tell what's happening without logs investigation. The thing is that no SQL log truncation should occur during incremental run - all log operations have to be handled by a separate sub-job that runs (according to your settings) every 15 minutes.

Please don't forget to post your case ID in this topic.

Thank you.
millardjk
Expert
Posts: 114
Liked: 25 times
Joined: Dec 09, 2012 3:50 am
Full Name: Jim Millard
Contact:

Re: Time to truncate?

Post by millardjk »

Support case: 01423731

Logs, events, etc are in the analyst's hands.
millardjk
Expert
Posts: 114
Liked: 25 times
Joined: Dec 09, 2012 3:50 am
Full Name: Jim Millard
Contact:

Re: Time to truncate?

Post by millardjk » 1 person likes this post

Appears that "competition" between native backup/maintenance jobs and Veeam were the root cause. Removing the Veeam SQL truncation task (the DBA was pretty adamant about keeping the native tasks) cleaned up the issue.
millardjk
Expert
Posts: 114
Liked: 25 times
Joined: Dec 09, 2012 3:50 am
Full Name: Jim Millard
Contact:

Re: Time to truncate?

Post by millardjk »

And even after explicitly disabling log truncation in the guest interaction portion of the backup config, I'm still getting a) RPC timeout errors, b) long "log truncation" events, etc. This is driving me nuts.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Time to truncate?

Post by foggy »

Jim, I can see your case is already closed, haven't you thought of re-opening it for further deeper investigation?
Post Reply

Who is online

Users browsing this forum: No registered users and 70 guests