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

Activity overview

Latest activity by mrclod

Full Text not observing MOVE on a RESTORE
  1. Community
  2. SQL Backup Previous Versions
Running into an issue when restoring a backup to an alternate server. This server contains multiple restores at any given time. To get around file conflicts, we move files to appropriate places or...
2 followers 3 comments 0 votes
Converted native backup and 3rd party apps
  1. Community
  2. SQL Backup Previous Versions
I recently converted some .sqb files to native backup format. That worked fine, however, I am finding 3rd party applications such as a log reader could not open the files claiming multiple errors....
2 followers 9 comments 0 votes
sqb2mtf errors
  1. Community
  2. SQL Backup Previous Versions
I have copied over several different RedGate backups and have attempted to use sqb2mtf to convert to native format. Version: 6.2.0.134 The examples of errors I get are: Data decompression error: ZL...
2 followers 3 comments 0 votes
Extended SP Documentation
  1. Community
  2. SQL Backup Previous Versions
I can only find stuff on the sqlbackup procedure. I have used sqbstatus, sqbmemory, sqbdir, but what might the rest be used for? Can we have full documentation in the next release perhaps? Thanks,...
2 followers 2 comments 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
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
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
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
Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE
  1. Community
  2. SQL Backup Previous Versions
The backup worked locally, but appears to have failed to move the copy. I have 2TB of free space and the backup is about 40GB compressed. Backup Pro 5.4 running on a cluster. Have included infor...
2 followers 8 comments 0 votes
Total activity
57
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
12