VDI error 1010: How do I set maxbuffersize

• 
  Use the MAXTRANSFERSIZE option e.g.
  

  EXEC master..sqlbackup '-sql "BACKUP LOG ... WITH MAXTRANSFERSIZE = 524288..." '
  

  
  It's strange that SQL Backup reports that it required 0 bytes of free memory. What version of SQL Backup are you using?
  
  Thanks.

  petey March 29, 2011 21:49

  - 0 +
• 
  6.4.0.56

  randyv March 31, 2011 07:02

  - 0 +
• 
  Not sure what went wrong.
  Ran the suggested code:
  EXEC master..sqlbackup '-sql "BACKUP LOG ... WITH MAXTRANSFERSIZE = 524288..." '
  Got two answer sets back:
  #1
  SQL Backup v6.4.0.56
  Syntax error: 'WITH' after '...'
  
  #2
  name value
  exitcode 850
  sqlerrorcode 0

  randyv March 31, 2011 07:05

  - 0 +
• 
  I apologise for the brevity in my previous example. You need to use whatever parameters you were using previously, and add the MAXTRANSFERSIZE option e.g.
  

  EXEC master..sqlbackup '-sql "BACKUP LOG AdventureWorks TO DISK = [<AUTO>] WITH MAXTRANSFERSIZE = 524288"'
  

  petey March 31, 2011 07:41

  - 0 +
• 
  Seems to work. I've changed the parm in the job. Will see if that eliminates the 'error' messages.

  randyv March 31, 2011 07:57

  - 0 +
• 
  Here is the complete message as I'm receiving it in email from SQL Backup -
  Seems the local backup is completing fine, but the network backup is not.
  Any idea why?
  

  ---

  ERRORS AND WARNINGS

  ---

  
  
  4/1/2011 8:15:05 AM:
  4/1/2011 8:15:05 AM: Verifying files:
  4/1/2011 8:15:05 AM: E:\Davisware\LDF Backup\Service\LOG_(local)_Service_20110401_081501.sqb
  4/1/2011 8:15:05 AM:
  4/1/2011 8:15:05 AM: VDI error 1010: Failed to get the configuration from the server because the timeout interval has elapsed. SQL Backup required 0 bytes of free SQL Server memory, which was not available. VDI error: An abort request is preventing anything except termination actions.
  4/1/2011 8:15:05 AM: SQL error 3013: VERIFY DATABASE is terminating abnormally.
  4/1/2011 8:15:05 AM: SQL error 18210: BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'SQLBACKUP_F9F1FB46-C191-4698-9504-C760D475A239'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.).
  4/1/2011 8:15:05 AM:
  4/1/2011 8:15:05 AM: Memory profile
  4/1/2011 8:15:05 AM: Type Maximum Minimum Average Blk count Total
  4/1/2011 8:15:05 AM:

  ---

  ---

  ---

  ---

  ---

  ---

  4/1/2011 8:15:05 AM: Commit 243068928 4096 56452 22147 1250242560
  4/1/2011 8:15:05 AM: Reserve 284266496 4096 41963 20477 859279360
  4/1/2011 8:15:05 AM: Free 7262208 4096 132504 286 37896192
  4/1/2011 8:15:05 AM: Private 284266496 4096 47296 41896 1981550592
  4/1/2011 8:15:05 AM: Mapped 1060864 4096 128107 76 9736192
  4/1/2011 8:15:05 AM: Image 24948736 4096 181342 652 118235136
  4/1/2011 8:15:05 AM:
  4/1/2011 8:15:05 AM: Validation of all backup files failed.
  
  
  

  ---

  PROCESSES COMPLETED SUCCESSFULLY

  ---

  
  4/1/2011 8:15:00 AM: Backing up Service (transaction log) to:
  4/1/2011 8:15:00 AM: E:\Davisware\LDF Backup\Service\LOG_(local)_Service_20110401_081500.sqb
  
  4/1/2011 8:15:01 AM: Deleting old backup file: E:\Davisware\LDF Backup\Service\LOG_(local)_Service_20110401_064500.sqb
  4/1/2011 8:15:01 AM: Deleting old backup file: \\whaley09\WFR-DailyBackups\Whaley03\LOG_(local)_Service_20110401_070000.sqb
  4/1/2011 8:15:01 AM: BACKUP LOG [Service] TO VIRTUAL_DEVICE = 'SQLBACKUP_CFF69D11-89C3-4F68-AEE0-D5D2F39F204E', VIRTUAL_DEVICE = 'SQLBACKUP_CFF69D11-89C3-4F68-AEE0-D5D2F39F204E01' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 524288, NAME = N'Database (Service), 4/1/2011 8:15:01 AM', DESCRIPTION = N'Backup on 4/1/2011 8:15:01 AM Server: WHALEY03 Database: Service', FORMAT
  
  4/1/2011 8:15:04 AM: Backup data size : 6.438 MB
  4/1/2011 8:15:04 AM: Compressed data size: 678.000 KB
  4/1/2011 8:15:04 AM: Compression rate : 89.71%
  
  4/1/2011 8:15:04 AM: Processed 533 pages for database 'Service', file 'ServiceDev_log' on file 1.
  4/1/2011 8:15:04 AM: BACKUP LOG successfully processed 533 pages in 0.583 seconds (7.478 MB/sec).

  randyv April 01, 2011 08:19

  - 0 +
• 
  As of the current version, the MAXTRANSFERSIZE option isn't used by the verification process, which results in an error in your case as there is a lack of free virtual address space to service the RESTORE VERIFYONLY process. Neither does the RESTORE VERIFYONLY process retry multiple times automatically with smaller MAXTRANSFERSIZE values, unlike the BACKUP command.

  petey April 04, 2011 05:16

  - 0 +
• 
  OK, but do you have some suggestions on what to change to eliminate the error?

  randyv April 04, 2011 07:49

  - 0 +
• 
  Is there any resolution to this? I am not all that interested in going in and modifying each of my scripts manually. I have 28 databases that are configured for log shipping. Unlike many SQL administrators I can't sit and monitor or waste a lot of time with SQL.
  
  I have found through increasing notification that this is the exact scenario that has caused me to lose many of my log shipped databases.
  
  Ignore this.. creating a new thread.

  mcetlinski August 03, 2011 12:48

  - 0 +
• 
  What version of SQL are you using? Have you set the -g startup option to give you enough VAS memory?
  
  Chris

  ChrisAVWood August 04, 2011 10:10

  - 0 +

Add comment

Please sign in to leave a comment.