Comprehensive data protection for all workloads
Post Reply
Strecker25
Enthusiast
Posts: 43
Liked: 3 times
Joined: Jan 17, 2016 6:18 pm
Full Name: Ryan Strecker
Contact:

VSS Timeout - SQL Server

Post by Strecker25 » Mar 04, 2016 2:24 am

case number 01715800

Hi, we're having issues doing application aware processing on some of our SQL servers. Veeam support is saying to contact MS, but we do not have unlimited support and I do not want to open a case for every SQL backup failure. The veeam console has these errors

3/3/2016 9:16:43 PM :: Unable to release guest. Error: VSSControl: Failed to freeze guest, wait timeout

even though our timeout is set on the Veeam server for 1 hour. If I run the diskshadow utility and manually do begin backup, create I have no issues and no errors. The backup process completes sucesfully. When Veeam triggers it, howeever, the VSS writers go into failed state for Timeout and the backup fails. The following logs are written to the application event log.

Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 11.0
Error message: BACKUP DATABASE is terminating abnormally.
SQLSTATE: 42000, Native Error: 3271
Error state: 1, Severity: 16
Source: Microsoft SQL Server Native Client 11.0
Error message: A nonrecoverable I/O error occurred on file "{204B6457-1678-496B-92AA-29B23EE85147}3:" 995(The I/O operation has been aborted because of either a thread exit or an application request.).

Also, this is a brand new server and a fresh install of sql 2014. There is basically no data on the server, and it is not under any load.

alanbolte
Expert
Posts: 635
Liked: 172 times
Joined: Jun 18, 2012 8:58 pm
Full Name: Alan Bolte
Contact:

Re: VSS Timeout - SQL Server

Post by alanbolte » Mar 04, 2016 3:06 am

Please carefully read KB1377, the error message refers to a timeout that is 60 seconds and cannot be configured.

Check your VMware snapshot creation time.

Strecker25
Enthusiast
Posts: 43
Liked: 3 times
Joined: Jan 17, 2016 6:18 pm
Full Name: Ryan Strecker
Contact:

Re: VSS Timeout - SQL Server

Post by Strecker25 » Mar 04, 2016 3:51 am

You're dead on, I moved the vm to another host and a less utilized volume and the application aware processing worked flawlessly. Is that saying the snapshot creation time must be 60s or less?

alanbolte
Expert
Posts: 635
Liked: 172 times
Joined: Jun 18, 2012 8:58 pm
Full Name: Alan Bolte
Contact:

Re: VSS Timeout - SQL Server

Post by alanbolte » Mar 04, 2016 4:45 am

Yes, that's correct.

Post Reply

Who is online

Users browsing this forum: ctalbot, Google [Bot] and 46 guests