Options
What do I need to change in the settings?
randyv
Posts: 166
I think I need to decrement the threads count (currently at 4)?
== attached warning message ==========================
SQL Backup log file 6.4.0.56
-SQL "BACKUP LOG [Service] TO DISK = 'E:\LDF Backup\Service\<AUTO>.sqb' WITH ERASEFILES_ATSTART = 3, MAILTO = 'randy.volters@whaleyfoodservice.com', DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, THREADCOUNT = 4, VERIFY "
ERRORS AND WARNINGS
5/19/2010 2:00:00 PM: Backing up Service (transaction log) to:
5/19/2010 2:00:00 PM: E:\LDF Backup\Service\LOG_(local)_Service_20100519_140000.sqb
5/19/2010 2:00:00 PM: Deleting old backup file: E:\LDF Backup\Service\LOG_(local)_Service_20100516_134500.sqb
5/19/2010 2:00:00 PM: BACKUP LOG [Service] TO VIRTUAL_DEVICE = 'SQLBACKUP_CF06A7C2-CC26-40AE-B9A5-B7F660D0F339', VIRTUAL_DEVICE = 'SQLBACKUP_CF06A7C2-CC26-40AE-B9A5-B7F660D0F33901', VIRTUAL_DEVICE = 'SQLBACKUP_CF06A7C2-CC26-40AE-B9A5-B7F660D0F33902',
VIRTUAL_DEVICE = 'SQLBACKUP_CF06A7C2-CC26-40AE-B9A5-B7F660D0F33903' WITH BUFFERCOUNT = 24, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (Service), 5/19/2010 2:00:00 PM', DESCRIPTION = N'Backup on 5/19/2010 2:00:00 PM Server: WHALEY03
Database: Service', FORMAT
5/19/2010 2:00:01 PM: VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. SQL Backup required 25,165,824 bytes of free SQL Server memory, which was not available. You can reduce the memory
requirements by reducing the number of threads used in the backup. VDI error: An abort request is preventing anything except termination actions.
5/19/2010 2:00:01 PM: SQL error 3013: BACKUP LOG is terminating abnormally.
5/19/2010 2:00:01 PM: SQL error 18210: BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'SQLBACKUP_CF06A7C2-CC26-40AE-B9A5-B7F660D0F339'. Operating system error 0x8007000e(Not enough storage is available to complete this
operation.).
5/19/2010 2:00:01 PM:
5/19/2010 2:00:01 PM: Memory profile
5/19/2010 2:00:01 PM: Type Maximum Minimum Average Blk count Total
5/19/2010 2:00:01 PM:
5/19/2010 2:00:01 PM: Commit 33554432 4096 525889 2754 1448300544
5/19/2010 2:00:01 PM: Reserve 509992960 4096 642746 1018 654315520
5/19/2010 2:00:01 PM: Free 7270400 4096 177083 253 44802048
5/19/2010 2:00:01 PM: Private 509992960 4096 633334 3022 1913937920
5/19/2010 2:00:01 PM: Mapped 14680064 4096 638185 114 72753152
5/19/2010 2:00:01 PM: Image 24555520 4096 182272 636 115924992
5/19/2010 2:00:01 PM:
PROCESSES COMPLETED SUCCESSFULLY
5/19/2010 2:00:01 PM: Warning 300: Backup failed. Retry attempt: 1
5/19/2010 2:00:03 PM: Deleting old backup file: E:\LDF Backup\Service\LOG_(local)_Service_20100516_140001.sqb
5/19/2010 2:00:03 PM: BACKUP LOG [Service] TO VIRTUAL_DEVICE = 'SQLBACKUP_AAC04E89-01A4-4F28-950D-EDF13D75DDE9', VIRTUAL_DEVICE = 'SQLBACKUP_AAC04E89-01A4-4F28-950D-EDF13D75DDE901', VIRTUAL_DEVICE = 'SQLBACKUP_AAC04E89-01A4-4F28-950D-EDF13D75DDE902',
VIRTUAL_DEVICE = 'SQLBACKUP_AAC04E89-01A4-4F28-950D-EDF13D75DDE903' WITH BUFFERCOUNT = 24, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 524288, NAME = N'Database (Service), 5/19/2010 2:00:00 PM', DESCRIPTION = N'Backup on 5/19/2010 2:00:00 PM Server: WHALEY03
Database: Service', FORMAT
5/19/2010 2:00:03 PM: Backup data size : 2.500 MB
5/19/2010 2:00:03 PM: Compressed data size: 20.000 KB
5/19/2010 2:00:03 PM: Compression rate : 99.22%
5/19/2010 2:00:03 PM: Processed 0 pages for database 'Service', file 'ServiceDev_log' on file 1.
5/19/2010 2:00:03 PM: BACKUP LOG successfully processed 0 pages in 0.160 seconds (0.000 MB/sec).
5/19/2010 2:00:03 PM:
5/19/2010 2:00:03 PM: Verifying files:
5/19/2010 2:00:03 PM: E:\LDF Backup\Service\LOG_(local)_Service_20100519_140000.sqb
5/19/2010 2:00:03 PM:
5/19/2010 2:00:03 PM: The backup set on file 1 is valid.
5/19/2010 2:00:04 PM: Mail sent successfully to: randy.volters@whaleyfoodservice.com
== attached warning message ==========================
SQL Backup log file 6.4.0.56
-SQL "BACKUP LOG [Service] TO DISK = 'E:\LDF Backup\Service\<AUTO>.sqb' WITH ERASEFILES_ATSTART = 3, MAILTO = 'randy.volters@whaleyfoodservice.com', DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 4, THREADCOUNT = 4, VERIFY "
ERRORS AND WARNINGS
5/19/2010 2:00:00 PM: Backing up Service (transaction log) to:
5/19/2010 2:00:00 PM: E:\LDF Backup\Service\LOG_(local)_Service_20100519_140000.sqb
5/19/2010 2:00:00 PM: Deleting old backup file: E:\LDF Backup\Service\LOG_(local)_Service_20100516_134500.sqb
5/19/2010 2:00:00 PM: BACKUP LOG [Service] TO VIRTUAL_DEVICE = 'SQLBACKUP_CF06A7C2-CC26-40AE-B9A5-B7F660D0F339', VIRTUAL_DEVICE = 'SQLBACKUP_CF06A7C2-CC26-40AE-B9A5-B7F660D0F33901', VIRTUAL_DEVICE = 'SQLBACKUP_CF06A7C2-CC26-40AE-B9A5-B7F660D0F33902',
VIRTUAL_DEVICE = 'SQLBACKUP_CF06A7C2-CC26-40AE-B9A5-B7F660D0F33903' WITH BUFFERCOUNT = 24, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576, NAME = N'Database (Service), 5/19/2010 2:00:00 PM', DESCRIPTION = N'Backup on 5/19/2010 2:00:00 PM Server: WHALEY03
Database: Service', FORMAT
5/19/2010 2:00:01 PM: VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. SQL Backup required 25,165,824 bytes of free SQL Server memory, which was not available. You can reduce the memory
requirements by reducing the number of threads used in the backup. VDI error: An abort request is preventing anything except termination actions.
5/19/2010 2:00:01 PM: SQL error 3013: BACKUP LOG is terminating abnormally.
5/19/2010 2:00:01 PM: SQL error 18210: BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'SQLBACKUP_CF06A7C2-CC26-40AE-B9A5-B7F660D0F339'. Operating system error 0x8007000e(Not enough storage is available to complete this
operation.).
5/19/2010 2:00:01 PM:
5/19/2010 2:00:01 PM: Memory profile
5/19/2010 2:00:01 PM: Type Maximum Minimum Average Blk count Total
5/19/2010 2:00:01 PM:
5/19/2010 2:00:01 PM: Commit 33554432 4096 525889 2754 1448300544
5/19/2010 2:00:01 PM: Reserve 509992960 4096 642746 1018 654315520
5/19/2010 2:00:01 PM: Free 7270400 4096 177083 253 44802048
5/19/2010 2:00:01 PM: Private 509992960 4096 633334 3022 1913937920
5/19/2010 2:00:01 PM: Mapped 14680064 4096 638185 114 72753152
5/19/2010 2:00:01 PM: Image 24555520 4096 182272 636 115924992
5/19/2010 2:00:01 PM:
PROCESSES COMPLETED SUCCESSFULLY
5/19/2010 2:00:01 PM: Warning 300: Backup failed. Retry attempt: 1
5/19/2010 2:00:03 PM: Deleting old backup file: E:\LDF Backup\Service\LOG_(local)_Service_20100516_140001.sqb
5/19/2010 2:00:03 PM: BACKUP LOG [Service] TO VIRTUAL_DEVICE = 'SQLBACKUP_AAC04E89-01A4-4F28-950D-EDF13D75DDE9', VIRTUAL_DEVICE = 'SQLBACKUP_AAC04E89-01A4-4F28-950D-EDF13D75DDE901', VIRTUAL_DEVICE = 'SQLBACKUP_AAC04E89-01A4-4F28-950D-EDF13D75DDE902',
VIRTUAL_DEVICE = 'SQLBACKUP_AAC04E89-01A4-4F28-950D-EDF13D75DDE903' WITH BUFFERCOUNT = 24, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 524288, NAME = N'Database (Service), 5/19/2010 2:00:00 PM', DESCRIPTION = N'Backup on 5/19/2010 2:00:00 PM Server: WHALEY03
Database: Service', FORMAT
5/19/2010 2:00:03 PM: Backup data size : 2.500 MB
5/19/2010 2:00:03 PM: Compressed data size: 20.000 KB
5/19/2010 2:00:03 PM: Compression rate : 99.22%
5/19/2010 2:00:03 PM: Processed 0 pages for database 'Service', file 'ServiceDev_log' on file 1.
5/19/2010 2:00:03 PM: BACKUP LOG successfully processed 0 pages in 0.160 seconds (0.000 MB/sec).
5/19/2010 2:00:03 PM:
5/19/2010 2:00:03 PM: Verifying files:
5/19/2010 2:00:03 PM: E:\LDF Backup\Service\LOG_(local)_Service_20100519_140000.sqb
5/19/2010 2:00:03 PM:
5/19/2010 2:00:03 PM: The backup set on file 1 is valid.
5/19/2010 2:00:04 PM: Mail sent successfully to: randy.volters@whaleyfoodservice.com
What we do in life echoes in eternity <><
Randy Volters
Randy Volters
Comments
I suppose you have two choices: you can reduce the number of threads or reduce the "Maximum Transfer Size" value to 524288, which is the value used in the successful retry. Personally I would reduce max transfer size as the better option because taking it down to 524288 will not reduce performance as much as taking it down to two or three threads.