How can we help you today? How can we help you today?
mrclod
Activity overview Badges (0) Posts (15) Comments (30)

Comments

Sort by recent activity
This is an intermittent issue. Some days no error(s), others 5-8 identical. Most of the time the retry works and gets a copy moved for us, other times, the copy does not happen. This server is the one that is most problematic. I do see this occasionally on other servers. SQL Backup log file 5.4.0.55 -SQL "BACKUP LOG [prod1] TO DISK = 'U:\BACKUPS\<database>\<AUTO>.sqb' WITH ERASEFILES_ATSTART = 7, MAILTO_ONERROR = 'XXXXXXXXXXXX', MAXTRANSFERSIZE = 983040, PASSWORD = 'XXXXXXXXXXXX', COMPRESSION = 3, COPYTO = '\\dbbackup\DatabaseBackups\P5\S3\<database>\', KEYSIZE = 256, THREADCOUNT = 3, VERIFY " ERRORS AND WARNINGS 9/14/2009 4:00:00 PM: Backing up prod1 (transaction log) on DBC instance to: 9/14/2009 4:00:00 PM: U:\BACKUPS\prod1\LOG_prod1_20090914_160000.sqb 9/14/2009 4:00:05 PM: BACKUP LOG [prod1] TO VIRTUAL_DEVICE = 'SQLBACKUP_F27195FA-DE91-490F-96B3-493FF1C6794D', VIRTUAL_DEVICE = 'SQLBACKUP_F27195FA-DE91-490F-96B3-493FF1C6794D01', VIRTUAL_DEVICE = 'SQLBACKUP_F27195FA-DE91-490F-96B3-493FF1C6794D02' WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 983040, NAME = N'Database (prod1), 9/14/2009 4:00:00 PM', DESCRIPTION = N'Backup on 9/14/2009 4:00:00 PM Server: dbp1 Database: prod1', FORMAT 9/14/2009 4:00:05 PM: VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684860: An abort request is preventing anything except termination actions.) 9/14/2009 4:00:06 PM: SQL error 3013: BACKUP LOG is terminating abnormally. 9/14/2009 4:00:06 PM: SQL error 18210: BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'SQLBACKUP_F27195FA-DE91-490F-96B3-493FF1C6794D'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.). 9/14/2009 4:00:06 PM: 9/14/2009 4:00:06 PM: Memory profile 9/14/2009 4:00:06 PM: Type Maximum Minimum Average Blk count Total 9/14/2009 4:00:06 PM: 9/14/2009 4:00:06 PM: Commit 263979008 4096 50353 29114 1465991168 9/14/2009 4:00:06 PM: Reserve 8318976 4096 23136 27367 633167872 9/14/2009 4:00:06 PM: Free 4194304 4096 161401 299 48259072 9/14/2009 4:00:06 PM: Private 263979008 4096 35346 55693 1968533504 9/14/2009 4:00:06 PM: Mapped 1060864 4096 98986 78 7720960 9/14/2009 4:00:06 PM: Image 24948736 4096 173105 710 122904576 9/14/2009 4:00:06 PM: 9/14/2009 4:00:19 PM: 9/14/2009 4:00:19 PM: Verifying files: 9/14/2009 4:00:19 PM: U:\BACKUPS\prod1\LOG_prod1_20090914_160000.sqb 9/14/2009 4:00:19 PM: The backup set on file 1 is valid. 9/14/2009 4:00:35 PM: Copied U:\BACKUPS\prod1\LOG_prod1_20090914_160000.sqb to \\dbbackup\DatabaseBackups\P5\S3\prod1\LOG_prod1_20090914_160000.sqb. PROCESSES COMPLETED SUCCESSFULLY 9/14/2009 4:00:06 PM: Warning 300: Backup failed. Retry attempt: 1 9/14/2009 4:00:08 PM: BACKUP LOG [prod1] TO VIRTUAL_DEVICE = 'SQLBACKUP_B8390B26-75C8-44D9-9778-A7928A987C89', VIRTUAL_DEVICE = 'SQLBACKUP_B8390B26-75C8-44D9-9778-A7928A987C8901', VIRTUAL_DEVICE = 'SQLBACKUP_B8390B26-75C8-44D9-9778-A7928A987C8902' WITH BUFFERCOUNT = 18, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 458752, NAME = N'Database (prod1), 9/14/2009 4:00:00 PM', DESCRIPTION = N'Backup on 9/14/2009 4:00:00 PM Server: dbp1 Database: prod1', FORMAT 9/14/2009 4:00:19 PM: Backup data size : 350.688 MB 9/14/2009 4:00:19 PM: Compressed data size: 98.774 MB 9/14/2009 4:00:19 PM: Compression rate : 71.83% Processed 43877 pages for database 'prod1', file 'cyracle_Log' on file 1. BACKUP LOG successfully processed 43877 pages in 9.602 seconds (37.433 MB/sec). 9/14/2009 4:00:36 PM: Mail sent successfully to: XXXXXXXXXXXX / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE
This is an intermittent issue. Some days no error(s), others 5-8 identical. Most of the time the retry works and gets a copy moved for us, other times, the copy does not happen. This server is t...
0 votes
Would the value of MemToLeave affect this by chance since redgate routines appear to be external stored procedures? / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE
Would the value of MemToLeave affect this by chance since redgate routines appear to be external stored procedures?
0 votes
Looks like our IT department didn't specify a max memory, setting SQL Server to have a max of 29G of the 32G on the system. Not sure if that will do it, but not finding a lot of definitive information on the subject. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE
Looks like our IT department didn't specify a max memory, setting SQL Server to have a max of 29G of the 32G on the system. Not sure if that will do it, but not finding a lot of definitive informat...
0 votes
Set Threads to 3, MAXTRANSFERSIZE to 960 on the LOG backup only. A reply from RedGate would be nice so I could stop taking stabs in the dark at this. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE
Set Threads to 3, MAXTRANSFERSIZE to 960 on the LOG backup only. A reply from RedGate would be nice so I could stop taking stabs in the dark at this.
0 votes
I've tried reducing threads. Still get these errors. A second attempt (as specified for the backup job to do) is successful. Just doing a LOG backup at this point. Threads are down to 2 and MAXTRANSFERSIZE is 1024. Going to attempt to move the MAXTRANSFERSIZE down just a notch to see what happens. Not sure why a chunk of memory cannot be found in 3GB of free memory. Does 6.2 address any of these issues?? 2009-09-10 14:00:01.27 spid291 Error: 18210, Severity: 16, State: 1. 2009-09-10 14:00:01.27 spid291 BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'SQLBACKUP_FCBD0467-A16F-4C07-B32F-B2B1674D3188'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.). 2009-09-10 14:00:01.27 spid291 Error: 18210, Severity: 16, State: 1. 2009-09-10 14:00:01.27 spid291 BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'SQLBACKUP_FCBD0467-A16F-4C07-B32F-B2B1674D3188'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.). / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE
I've tried reducing threads. Still get these errors. A second attempt (as specified for the backup job to do) is successful. Just doing a LOG backup at this point. Threads are down to 2 and MAXT...
0 votes
As per my previous post, it just doesn't like running from the network. If there is some glitch in the software that prevents this, at least update the error message to not be so generic that it provides not clue to the user as to what to attempt to resolve. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Deactivation error
As per my previous post, it just doesn't like running from the network. If there is some glitch in the software that prevents this, at least update the error message to not be so generic that it pr...
0 votes
Apparently the licensing activation/deactivation tools don't like running from a network share. You might want to fix that. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Deactivation error
Apparently the licensing activation/deactivation tools don't like running from a network share. You might want to fix that.
0 votes
I have run command below while this backup does nothing in case you need any information out of the log. EXEC master..sqbutility 9997 I'll try and run a command line version backup since I have seen other issues running things from the GUI here recently. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. backup not processing
I have run command below while this backup does nothing in case you need any information out of the log. EXEC master..sqbutility 9997 I'll try and run a command line version backup since I have see...
0 votes
Looks like a fulltext was in a state that did not like redgate. Rebuilt the index and I'm working now. Be nice if redgate could diagnose stuff like this with the utility. / comments
  1. Community
  2. SQL Backup Previous Versions
  3. backup not processing
Looks like a fulltext was in a state that did not like redgate. Rebuilt the index and I'm working now. Be nice if redgate could diagnose stuff like this with the utility.
0 votes
Ran the following, but still nothing is processed: declare @exitcode int, @sqlerrorcode int EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [stage_s1] TO DISK = ''M:\BACKUPS\STAGE_S1_PRESNAPSHOT.sqb'' WITH COMPRESSION = 3, THREADCOUNT = 2, VERIFY"', @exitcode OUT, @sqlerrorcode OUT print '@exitcode ' + str(@exitcode) print '@sqlerrorcode ' + str(@sqlerrorcode) Fifteen minutes of running and nothing processed: exec sqbstatus Database Login Processed (bytes) Compressed (bytes) stage_s1 me 0 0 (1 row(s) affected) / comments
  1. Community
  2. SQL Backup Previous Versions
  3. backup not processing
Ran the following, but still nothing is processed: declare @exitcode int, @sqlerrorcode int EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASE [stage_s1] TO DISK = ''M:\BACKUPS\STAGE_S1_PRESNAPSHOT....
0 votes
Total activity
57
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
12