Unable to truncate Microsoft SQL Server transaction logs - l

Availability for the Always-On Enterprise

Unable to truncate Microsoft SQL Server transaction logs - l

Veeam Logoby abachiman » Mon Dec 19, 2016 1:21 pm

Hello,

we have disabled the right to logon locally for service accounts because of our policies
with this service account I am able to backup the database - but not to truncate the logs :-(

Unable to truncate Microsoft SQL Server transaction logs. Details: Error code: 0x80004005 Failed to invoke func [TruncateSqlLogs]: Unbekannter Fehler. Failed to process 'TruncateSQLLog' command. Failed to logon user [xxxxxxxx\veeam-backup] Win32 error:Anmeldung fehlgeschlagen: Der Benutzer besitzt nicht den ben?tigten Anmeldetyp auf diesem Computer. Code: 1385 Error code: 0x80004005 Failed to invoke func [TruncateSqlLogs]: Unbekannter Fehler. Failed to process 'TruncateSQLLog' command. Failed to log


if we enable "logon locally" by GP the backup works without any warnings

any idea how to truncate the logs with "allow logon locally" disabled ?
any other idea how to backup the sql-databases and prevent someone to logon with the service account ?

This problem is also under investigation by the support-team #01995871

regards
Andreas
abachiman
Novice
 
Posts: 4
Liked: never
Joined: Thu May 12, 2011 6:50 am
Full Name: Andreas

Re: Unable to truncate Microsoft SQL Server transaction logs

Veeam Logoby foggy » Mon Dec 19, 2016 3:22 pm

Hi Andreas, for guest processing, account with local administrator privileges on the VM guest OS should be used. Are you specifying the Veeam Backup Service account at the Guest Processing step of the wizard?
foggy
Veeam Software
 
Posts: 14742
Liked: 1081 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Unable to truncate Microsoft SQL Server transaction logs

Veeam Logoby abachiman » Mon Dec 19, 2016 3:39 pm

Hi foggy,

the AD-based service-account is member of the local admin-group on each server.
each server is member of an AD-group on which the GP is deployed

the service-account was defined within the AD and was selected in the job-wizzard to be used for guest processing.
(which all works as long as the service-account is granted to "logon locally" - which we don't want to ...)

Andreas
abachiman
Novice
 
Posts: 4
Liked: never
Joined: Thu May 12, 2011 6:50 am
Full Name: Andreas

Re: Unable to truncate Microsoft SQL Server transaction logs

Veeam Logoby foggy » Wed Dec 21, 2016 11:20 am

Any chance you could use a dedicated account with this right enabled just for guest processing?
foggy
Veeam Software
 
Posts: 14742
Liked: 1081 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot], ChrisSnell, Google [Bot] and 78 guests