User profile for geoff.tanner – Support

Activity overview Badges (0) Posts (2) Comments (4)

Comments

Peter, thanks for this post, I applied the MAXTRANSFERSIZE setting to the restore jobs and they are all succeeding now. I appreciated your rapid response and accurate answers. / comments

Peter, thanks for this post, I applied the MAXTRANSFERSIZE setting to the restore jobs and they are all succeeding now. I appreciated your rapid response and accurate answers.

0 votes

here is a sample of the error message I get when the shipping fails: SQL Backup log file 6.4.0.56 -SQL "RESTORE LOG [LMPOS_KitchenWarehouse] FROM DISK = '\\svr-dbase02\LogShipping\LOG_LMPOS_KitchenWarehouse_*.sqb' WITH ERASEFILES = 2, FILEOPTIONS = 1, MAILTO_ONERRORONLY = 'AllDBATeam@vii.com.au', NORECOVERY, MOVETO = 'F:\MSSQL\LogShipping\Processed' " ERRORS AND WARNINGS 9/09/2010 3:02:01 PM: Restoring LMPOS_KitchenWarehouse (transaction logs) from: 9/09/2010 3:02:01 PM: \\svr-dbase02\LogShipping\LOG_LMPOS_KitchenWarehouse_20100909150001.sqb 9/09/2010 3:02:01 PM: RESTORE LOG [LMPOS_KitchenWarehouse] FROM VIRTUAL_DEVICE = 'SQLBACKUP_4FE9B074-E82F-4D93-8A4A-32B506BE39D0', VIRTUAL_DEVICE = 'SQLBACKUP_4FE9B074-E82F-4D93-8A4A-32B506BE39D001' WITH BUFFERCOUNT = 12, BLOCKSIZE = 65536, MAXTRANSFERSIZE = 1048576 , NORECOVERY 9/09/2010 3:02:01 PM: 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. 9/09/2010 3:02:01 PM: Also check that the database is not currently in use. 9/09/2010 3:02:01 PM: SQL error 3013: RESTORE LOG is terminating abnormally. 9/09/2010 3:02:01 PM: SQL error 18210: BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'SQLBACKUP_4FE9B074-E82F-4D93-8A4A-32B506BE39D0'. Operating system error 0x8007000e(error not found). 9/09/2010 3:02:01 PM: 9/09/2010 3:02:01 PM: Memory profile 9/09/2010 3:02:01 PM: Type Maximum Minimum Average Blk count Total 9/09/2010 3:02:01 PM: 9/09/2010 3:02:01 PM: Commit 1073414144 4096 1843283 1668 3074596864 9/09/2010 3:02:01 PM: Reserve 4190208 4096 264796 278 73613312 9/09/2010 3:02:01 PM: Free 37814272 4096 325668 224 72949760 9/09/2010 3:02:01 PM: Private 1073414144 4096 2135568 1372 2929999872 9/09/2010 3:02:01 PM: Mapped 12582912 4096 1093139 133 145387520 9/09/2010 3:02:01 PM: Image 24866816 4096 165131 441 72822784 9/09/2010 3:02:01 PM: 9/09/2010 3:02:01 PM: Mail sent successfully to: AllDBATeam@vii.com.au / comments

here is a sample of the error message I get when the shipping fails: SQL Backup log file 6.4.0.56 -SQL "RESTORE LOG [LMPOS_KitchenWarehouse] FROM DISK = '\\svr-dbase02\LogShipping\LOG_LMPOS_Kitchen...

0 votes

Pete, thanks for the post. CPU gets to about 58% for about 5 seconds during the log restore. The databases are all fairly small - not many transactions - so the entire 23 DBs take about the 5 to 10 seconds to restore. On the job step theme, I could do that. I am a bit disappointed to have to take that step though, as the whole idea for me was to let SQL Backup manage the required jobs and schedules. Do people not usually ship logs for so many databases? / comments

Pete, thanks for the post. CPU gets to about 58% for about 5 seconds during the log restore. The databases are all fairly small - not many transactions - so the entire 23 DBs take about the 5 to 10...

0 votes

Thanks, Peter, I will use that technique in the future / comments

Thanks, Peter, I will use that technique in the future

0 votes

Total activity: 8
Last activity: February 05, 2025 12:36
Member since: February 04, 2025 14:20

Following: 0 users
Followed by: 0 users
Votes: 0
Subscriptions: 2