SQL Server Backup failed sometimes

VMware specific discussions

SQL Server Backup failed sometimes

Veeam Logoby Funki » Mon Aug 08, 2016 12:02 pm

Hello,

Cas: ID# 01870435

2 SQL Servers (running on Windows 2008 R2) have sometimes Problems with the Backup, as far as i can see in the Logs most oft the Time because of a timeout and also "Blobcall":

SQL Server1:
Code: Select all
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 truncate SQL server transaction logs for instances: . See guest helper log. . Error code: 0x80004005 Failed to invoke func [TruncateSqlLogs]: Unbekannter Fehler. Failed to process 'TruncateSQLLog' command. Failed to truncate SQL server transaction logs for instances: . See guest helper log. .



SQL Server 2:

Code: Select all
 Unable to truncate Microsoft SQL Server transaction logs. Details: Error code: 0xe06d7363 Failed to invoke func [TruncateSqlLogs]: Unknown error 0xE06D7363. RPC function call failed. Function name: [BlobCall]. Target machine: [10.170.0.51]. RPC error: Code: -529697949 Error code: 0xe06d7363 Failed to invoke func [TruncateSqlLogs]: Unknown error 0xE06D7363. RPC function call failed. Function name: [BlobCall]. Target machine: [10.170.0.51]. RPC error: Code: -529697949 im guest helper log finde ich auch den eintrag fuer den ifa-spsql1 WARN Cannot truncate SQL logs for database: Intranet_Content. Code = 0x80040e31 02.08.2016 19:27:52 18676 WARN Code meaning = IDispatch error #3121 02.08.2016 19:27:52 18676 WARN Source = Microsoft OLE DB Provider for SQL Server 02.08.2016 19:27:52 18676 WARN Description = Timeout abgelaufen 02.08.2016 19:27:52 18676 WARN No OLE DB Error Information found: hr = 0x80004005 02.08.2016 19:27:52 18676 Truncating database logs (SQL instance: )


support offered me 2 different Solutions until now:

https://www.veeam.com/kb1813

Problem here, there ist no sc delete VeeamVssSupport possible because the Service is not installed, also delting the folder is impossible, the Folder doesnt exist.


Second Solution:

Code: Select all
Set this Reg Keys on the SQL:

Name: SqlExecTimeout

Type: DWORD

Value: 600

 
Name: SqlLogBackupTimeout

Type: DWORD

Value: 3600

 Name: SqlConnectionTimeout

Type: DWORD

Value: 300
 

 HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\VeeaM\Veeam Backup and Replication\

but this entry isnt there on both sql servers.

Any Ideas how to fix the Problem?

Thanks.
Funki
Service Provider
 
Posts: 7
Liked: 1 time
Joined: Mon Feb 09, 2015 8:22 am
Full Name: Alex

Re: SQL Server Backup failed sometimes

Veeam Logoby Vitaliy S. » Mon Aug 08, 2016 4:29 pm

Hi Alex, the registry modification has to be done on the backup server itself, not in the backed up SQL Server VMs. Thanks!
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov

Re: SQL Server Backup failed sometimes

Veeam Logoby blithespirit » Mon Aug 08, 2016 9:28 pm

Please follow Vitally's suggestion but in regard to the VeeamVssSupport service, you will only see this when the service is running, the Veeam Installer will automatically install and run the service only for the duration of the job. Once complete it disappears.
blithespirit
Veeam Software
 
Posts: 44
Liked: 7 times
Joined: Tue May 03, 2016 2:06 pm
Full Name: Paul Szelsi

Re: SQL Server Backup failed sometimes

Veeam Logoby fluxblocker » Thu Apr 06, 2017 1:41 pm

In the registry settings; are the entries supposed to be 32-bit DWORD values or 64-bit? Also, are the values supposed to be decimal or hex? Many thanks.
fluxblocker
Novice
 
Posts: 3
Liked: 1 time
Joined: Tue Dec 16, 2014 5:57 pm
Full Name: Samuel L Sanders Jr

Re: SQL Server Backup failed sometimes

Veeam Logoby foggy » Thu Apr 06, 2017 3:42 pm

Hi Samuel, the values need to be placed both under HKLM\SOFTWARE\Veeam\Veeam Backup and Replication and HKLM\SOFTWARE\Wow6432Node\VeeaM\Veeam Backup and Replication and are decimal.
foggy
Veeam Software
 
Posts: 14742
Liked: 1079 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to VMware vSphere



Who is online

Users browsing this forum: Google [Bot], rgreen83 and 12 guests