Avamar: Operating system error 0x8007000e(failed to retrieve text for this error. Reason: 15105)

Avsql log

avsql Error <40258>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device '(local)_XXXX-SQL'. Operating system error 0x8007000e(failed to retrieve text for this error. Reason: 15105).

OR

avsql Error <9072>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. -  System.Data.SqlClient.SqlException: Cannot open backup device  (local)_ XXXX-SQL . Operating system error 0x80070002(failed to retrieve text for this error. Reason: 15105).

OR
 

avsql Error <9072>: sqlconnectimpl_smo::execute Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: Write on "(local)_XXXX-SQL-1387332000116#1-3006-SQL" failed: 112 (There is not enough space on the disk.)
avtar Error <5803>: Error writing 32-byte header to cache file C:\Program Files\avs\var\avsql_t0_p_cache.dat. Possibly out of disk space
and the more obviously errors:

avsql Error <6479>: Timed out. Was Microsoft SQLServer running?
avsql Error <6478>: VDS::Getconfig failed with 'The api was waiting and the timeout interval had elapsed'

Windows Application Log
PM MSSQLSERVER Error Server  18210 NT AUTHORITY\SYSTEM XXXXXXX BackupVirtualDeviceSet::SetBufferParms: Request large buffers failure on backup device '(local)_XXXX-SQL'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.).

 
 

SQL server performance is impacted as backup can demand on high memory and CPU  resources.

Sometime this high demand resources caused Avsql process timed out while executing a transaction-sql statement or batch.

Increase avsql time out values.
Use one of the following methods to add flags in the MCGUI Dataset or in avsql.cmd file:

Method #1 - Adding to Dataset
Add the following flags in a Dataset for SQL Plug-in.
Note: Both flags must have leading "[avsql]"
 
[avsql]max-transfer-size   =   65536
[avsql]vditransfertimeoutsecs  =  900
 
Method #2 - Added to the avsql.cmd file
Add the following flags to the C:\Program Files\avs\var\avsql.cmd file
 
--max-transfer-size=65536
--vditransfertimeoutsecs=900