Comprehensive data protection for all workloads
frankive
Service Provider
Posts: 1092
Liked: 134 times
Joined: May 14, 2013 8:35 pm
Full Name: Frank Iversen
Location: Norway
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by frankive » 1 person likes this post

We also see thsi on a few VMs in our hosted environment just for a reference.
I will get in contact with support to eventually get a fix.
Thanks.
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by Shestakov »

Tom, Frank,
please post your support case numbers for the tracking purposes. Thanks!
hucmat
Service Provider
Posts: 6
Liked: 1 time
Joined: Apr 27, 2015 11:07 pm
Full Name: Matt Hucker
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by hucmat »

Also having this issue with the : MICROSOFT##WID database. Veeam has only started reporting it since we have updated to Update 3 (8.0.2084). Support Case ID 01090546
hucmat
Service Provider
Posts: 6
Liked: 1 time
Joined: Apr 27, 2015 11:07 pm
Full Name: Matt Hucker
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by hucmat »

Just thought I'd let everyone know that Veeam support provided a hotfix and it looks like it has solved my issue with the Microsoft WID database. If anyone else is having issues, log a support job and you should get the hotfix pretty quickly.
Funki
Novice
Posts: 7
Liked: 1 time
Joined: Feb 09, 2015 8:22 am
Full Name: Alex

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by Funki »

ask veeam support for the patch. i got it last week, from the support you will receive a zip file with some *.dll included. change this *.dll on the backup server and retry the job.
my problem was solved with this change.
cffit
Veteran
Posts: 338
Liked: 35 times
Joined: Jan 20, 2012 2:36 pm
Full Name: Christensen Farms
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by cffit »

The hotfix worked for me as well.
xy16644
Novice
Posts: 7
Liked: never
Joined: Dec 04, 2015 10:37 pm
Full Name: SW

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by xy16644 »

I have installed the trial of Veeam B&R with patch 3 and after setting up a WSUS VM I am not getting the error mentioned in this post:

Failed to finalize guest processing. Details: Failed to process 'TruncateSQLLog' command. Failed to truncate transaction logs for SQL instances: MICROSOFT##WID. Possible reasons: lack of permissions, or transaction log corruption.

I have tried giving my account sysadmin rights in SQL but this hasn't helped.

How can I get the hotfix? I'd like to see if this resolve the issue.

Thanks!
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by foggy »

Please contact technical support to get it. Thanks.
djesko
Novice
Posts: 4
Liked: never
Joined: Jan 14, 2015 9:28 am
Full Name: Niklas Engberg
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by djesko »

Hi

Same problem here after update

case : 01252488

Br Niklas
Ink
Novice
Posts: 3
Liked: 3 times
Joined: Jan 11, 2016 12:43 pm
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by Ink »

Yep, same issue with us. When can we expect update 4? There have been a lot of niggly bugs in Veeam over the past few months and no updates since October 2015.
Far too many resources seem to be going into Veeam 9 while current customers are struggling along having to install hotfixes all over the place.
Issue 54622 springs to mind.
ftbug
Enthusiast
Posts: 59
Liked: 2 times
Joined: Nov 18, 2015 10:12 am
Full Name: Freddie
Contact:

[MERGED] Veeam user permissions

Post by ftbug »

Hi, we are currently using a domain admin account for backup, however, with certain machines we are getting the following errors;

Testing admin share accessibility via VIX Error: cannot upload file to admin share [C:\Windows] cannot create folder in guest C:\

Testing admin share accessibility via VIX Error: Cannot upload file to admin share [C:\Windows]. Cannot create folder in guest: [C:\Windows\VeeamGuestHelpersTest].VIX Error: You do not have access rights to this file Code: 13

along with;

25/08/2016 19:54:26 :: Unable to truncate SQL server transaction logs. Details: Failed to process 'TruncateSQLLog' command.
Failed to truncate transaction logs for SQL instances: SP1. Possible reasons: lack of permissions, or transaction log corruption.

What permissions does the user account actually require in order to pass the permissions test correctly, and to resolve the SQL permissions issues?
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by Shestakov »

Hi, have you tried to contact Veeam support with the issue?
By the way, what product version are you at?
Thanks!
ftbug
Enthusiast
Posts: 59
Liked: 2 times
Joined: Nov 18, 2015 10:12 am
Full Name: Freddie
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by ftbug »

We have not contacted support yet, and are using v8.

I would mainly like to just know what sorts of permissions are required for the user account on SQL databases and on the exchange machine (Testing admin share accessibility via VIX Error: Cannot upload file to admin share [C:\Windows]. Cannot create folder in guest: [C:\Windows\VeeamGuestHelpersTest].VIX Error: You do not have access rights to this file Code: 13)

thanks
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by Shestakov »

And what version of v8? There was a bug fixed in v8u3.
Answering your question, you must specify a user account that will be used to connect to the VM guest OS and deploy the runtime process. By default, Veeam Backup & Replication uses the same credentials for all VMs in the job. If some VM requires a different user account, click Credentials and enter custom credentials for the VM.
Note that credentials for application-aware processing for Microsoft Windows VMs must be specified as: DOMAIN\Username for Active Directory accounts and Username or HOST\Username for local accounts.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by foggy »

Actually, if you're seeing errors just for the VIX part of the permissions check, while the network part passes without issues, you're good to go with the backup itself, since this means you have enough permission to perform backup. There're additional requirements for application-aware backup in networkless mode (over VIX), where UAC should be disabled on the VM or built-in administrator account should be used, you can check UAC settings on the affected VMs to make sure.
Kader
Lurker
Posts: 2
Liked: never
Joined: Mar 02, 2018 2:00 pm
Full Name: Kader benichou
Contact:

[MERGED] Failed to truncate transaction logs for SQL instanc

Post by Kader »

Hello,

I have encountered this warning and wondered if anybody can shed light on it.

Code: Select all

Failed to finalize guest processing. Details: Failed to process 'TruncateSQLLog' command. Failed to truncate transaction logs for SQL instances: ****2018A. Possible reasons: lack of permissions, or transaction log corruption.


It's Veeam Backup & Replication 8.0.2084 running on a Windows 2012 R2 physical server.The job is backing up 1 VM.

Thanks for your help
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by foggy »

Hi Kader, please see above for details.
Kader
Lurker
Posts: 2
Liked: never
Joined: Mar 02, 2018 2:00 pm
Full Name: Kader benichou
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by Kader »

Hi,

have browsed the forum but I have not found an answer to my problem.
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by foggy »

This thread discusses similar issues and mentions the hotfix for this problem was available. Any reason why you do not upgrade to a more recent version? I doubt v8 is still supported, but most likely the issue was fixed in the later ones.
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 260 guests