Comprehensive data protection for all workloads
Post Reply
abachiman
Novice
Posts: 4
Liked: never
Joined: May 12, 2011 6:50 am
Full Name: Andreas
Contact:

Unable to truncate Microsoft SQL Server transaction logs - l

Post by abachiman »

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
foggy
Veeam Software
Posts: 21070
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Unable to truncate Microsoft SQL Server transaction logs

Post by foggy »

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?
abachiman
Novice
Posts: 4
Liked: never
Joined: May 12, 2011 6:50 am
Full Name: Andreas
Contact:

Re: Unable to truncate Microsoft SQL Server transaction logs

Post by abachiman »

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
foggy
Veeam Software
Posts: 21070
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Unable to truncate Microsoft SQL Server transaction logs

Post by foggy »

Any chance you could use a dedicated account with this right enabled just for guest processing?
Post Reply

Who is online

Users browsing this forum: david.domask, edv-compas, mbrzezinski and 134 guests