Comprehensive data protection for all workloads
frankive
Service Provider
Posts: 884
Liked: 104 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 » Oct 16, 2015 6:38 am 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
Veeam Software
Posts: 6916
Liked: 700 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 » Oct 16, 2015 9:55 am

Tom, Frank,
please post your support case numbers for the tracking purposes. Thanks!

hucmat
Novice
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 » Oct 22, 2015 11:26 pm

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
Novice
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 » Oct 25, 2015 10:35 pm

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 » Oct 26, 2015 7:45 am

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
Expert
Posts: 338
Liked: 34 times
Joined: Jan 20, 2012 2:36 pm
Full Name: Christensen Farms
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by cffit » Oct 30, 2015 7:51 pm

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 » Dec 04, 2015 10:43 pm

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: 18158
Liked: 1542 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by foggy » Dec 05, 2015 10:27 pm

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 » Dec 30, 2015 12:39 am

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 » Jan 11, 2016 12:47 pm

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 » Aug 26, 2016 11:11 am

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
Veeam Software
Posts: 6916
Liked: 700 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 » Aug 26, 2016 11:26 am

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 » Aug 26, 2016 11:44 am

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
Veeam Software
Posts: 6916
Liked: 700 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 » Aug 26, 2016 1:39 pm

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: 18158
Liked: 1542 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by foggy » Aug 26, 2016 2:57 pm

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 » Mar 02, 2018 2:11 pm

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: 18158
Liked: 1542 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by foggy » Mar 02, 2018 2:48 pm

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 » Mar 02, 2018 3:35 pm

Hi,

have browsed the forum but I have not found an answer to my problem.

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

Re: Truncating SQL transaction logs - SUDDENLY trouble

Post by foggy » Mar 02, 2018 4:11 pm

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: Bing [Bot] and 15 guests