I am doing restore testing and keep getting the error message below. I am restoring 12 databases in sequential order and have plenty of available disk space.
If I restart the SQL BACKUP Agent, then it will work for that go around. This is getting frustrating as it could happen between any of the restores and I am potentially looking to break the job up to restore a few databases in parallel due to some time constraints.
So is this a known issue fixed in the next version? And when is the next version supposed to be released anyway?
SQL Backup v5.4.0.55
Restoring BUILD_T1_12650 (database) from:
\\p5stagefile1\backup\databasebackup\p5trialdb1\FULL_mydb_20090611_000000.sqb
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.)
Also check that the database is not currently in use.
SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 18210: BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'SQLBACKUP_E851E6F1-C67E-4A86-84A0-9B0B3EE144A1'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.).
Memory profile
Type Maximum Minimum Average Blk count Total
Commit 795410432 4096 1239661 1588 1968582656
Reserve 15855616 4096 456125 301 137293824
Free 5853184 4096 136650 304 41541632
Private 795410432 4096 1717005 1117 1917894656
Mapped 1060864 4096 318278 166 52834304
Image 24948736 4096 223015 606 135147520
SQL Backup exit code: 1010
SQL error code: 18210
name value
exitcode 1010
sqlerrorcode 18210
filename001 \\p5stagefile1\backup\databasebackup\p5trialdb1\FULL_mydb_20090611_000000.sqb
Hi Jon,
If I restart the SQL BACKUP Agent, then it will work for that go around. This is getting frustrating as it could happen between any of the restores and I am potentially looking to break the job up to restore a few databases in parallel due to some time constraints.
So is this a known issue fixed in the next version? And when is the next version supposed to be released anyway?
SQL Backup v5.4.0.55
Restoring BUILD_T1_12650 (database) from:
\\p5stagefile1\backup\databasebackup\p5trialdb1\FULL_mydb_20090611_000000.sqb
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.)
Also check that the database is not currently in use.
SQL error 3013: RESTORE DATABASE is terminating abnormally.
SQL error 18210: BackupVirtualDeviceSet::Initialize: Request large buffers failure on backup device 'SQLBACKUP_E851E6F1-C67E-4A86-84A0-9B0B3EE144A1'. Operating system error 0x8007000e(Not enough storage is available to complete this operation.).
Memory profile
Type Maximum Minimum Average Blk count Total
Commit 795410432 4096 1239661 1588 1968582656
Reserve 15855616 4096 456125 301 137293824
Free 5853184 4096 136650 304 41541632
Private 795410432 4096 1717005 1117 1917894656
Mapped 1060864 4096 318278 166 52834304
Image 24948736 4096 223015 606 135147520
SQL Backup exit code: 1010
SQL error code: 18210
name value
exitcode 1010
sqlerrorcode 18210
filename001 \\p5stagefile1\backup\databasebackup\p5trialdb1\FULL_mydb_20090611_000000.sqb