Failed to read file list from backup file.

Drovers

I am trying to restore a database from a backup and get this error when it brings up step 3. This is a training database that has had the same backup restored many times without problems.
When I run sqlbackup '-sql "RESTORE FILELISTONLY FROM DISK = [<file name>]"' it returns nothing. (I ran this on three different backups on with the same results, I also ran this on a backup for a different database with the same results.
)
When I run '-sql "RESTORE SQBHEADERONLY FROM DISK = [<file name>]"' it returns
SQL Backup v4.6.0.815
Reading SQB file header of "C:\DBbackup\TMW_Training_FULL_20061117 Clean.sqb"
Backup group ID : 116907021
File number : 1 of 1
Backup type : 1 (Database)
Backup size : 21.721 GB
Backup start : Friday, November 17, 2006 4:09:23 PM
Backup end : Friday, November 17, 2006 4:21:44 PM
Server name : TULOKSQL02
Database name : TMW_Training
First LSN : 1417591000000004800001
Last LSN : 1417591000000006200001
Checkpoint LSN : 1417591000000004800008
Differential base LSN : 1417589000000819600014

name value

---

exitcode 0
sqlerrorcode 0
filename01 C:\DBbackup\TMW_Training_FULL_20061117 Clean.sqb

If I continue with the backup the error returned is
Restore TMW_Training

Restoring TMW_Training (database) from:
C:\DBbackup\TMW_Training_FULL_20061117 Clean.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.)
SQL error 3013: RESTORE DATABASE is terminating abnormally.

Memory profile
Type Maximum Minimum Average Blk count Total

---

---

---

---

---

---

Commit 657653760 4096 935649 2016 1886269440
Reserve 67096576 4096 386347 588 227172352
Free 2097152 4096 99345 342 33976320
Private 657653760 4096 1115361 1816 2025496576
Mapped 4128768 4096 172714 84 14508032
Image 9850880 4096 104314 704 73437184

SQL Backup exit code: 1010
SQL error code: 3013

petey

Which version of SQL Server and SQL Backup was used to create the backup, and which version of SQL Server and SQL Backup are you using to restore the file now? Thanks.

Drovers

The SQL server is 2000 and the SQL Backup is v4.6.0.815
This is all being run on the same server and has neither SQL or SQL Backup has been updated.

petey

What happens when you run the RESTORE FILELISTONLY ... command using the command line interface (SQLBackupC.exe) on the backup file e.g.

C:\>sqlbackupc -sql "RESTORE FILELISTONLY FROM DISK = 'C:\DBbackup\TMW_Training_FULL_20061117 Clean.sqb'"

Similarly, what are the results when running the RESTORE HEADERONLY ... on the file?

Thanks.

Drovers

C:\Program Files\Red Gate\SQL Backup\(LOCAL)>dir
Volume in drive C has no label.
Volume Serial Number is BC4C-C861

Directory of C:\Program Files\Red Gate\SQL Backup\(LOCAL)

09/01/2006 01:58 PM <DIR> .
09/01/2006 01:58 PM <DIR> ..
08/15/2006 11:10 AM 1,850,368 SQBCoreService.exe
01/26/2006 07:23 PM 802 SQBShellExt.reg
08/15/2006 11:16 AM 1,852,928 SQLBackupC.exe
09/01/2006 01:58 PM 21,191 unins000.dat
09/01/2006 01:57 PM 957,194 unins000.exe
09/01/2006 01:58 PM <DIR> Win32
07/20/2005 10:48 AM 59,904 zlib1.dll
6 File(s) 4,742,387 bytes
3 Dir(s) 22,017,479,680 bytes free

C:\Program Files\Red Gate\SQL Backup\(LOCAL)>sqlbackupc -sql "RESTORE FILELISTON
LY FROM DISK = 'C:\DBbackup\TMW_Training_FULL_20061117 Clean.sqb'"

Red Gate SQL Backup 4.6.0.815, (c) Red Gate Software Ltd 2004 - 2006
Serial number: XXXXXXXXXXXXXXX

Reading filelist of "C:\DBbackup\TMW_Training_FULL_20061117 Clean.sqb"

VDI error 1010: Failed to get configuration from server. Check that the SQL Ser
ver 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.)
SQL error 3013: RESTORE FILELIST is terminating abnormally.

Memory profile
Type Maximum Minimum Average Blk count Total

---

---

---

---

---

---

Commit 657653760 4096 946017 1992 1884467200
Reserve 67096576 4096 386907 596 230596608
Free 1572864 4096 95159 340 32354304
Private 657653760 4096 1123123 1805 2027237376
Mapped 4128768 4096 182142 79 14389248
Image 9850880 4096 104314 704 73437184

SQL Backup exit code: 1010
Last SQL error code: 3013

#####

C:\Program Files\Red Gate\SQL Backup\(LOCAL)>sqlbackupc -sql "RESTORE headerONLY
FROM DISK = 'C:\DBbackup\TMW_Training_FULL_20061117 Clean.sqb'"

Red Gate SQL Backup 4.6.0.815, (c) Red Gate Software Ltd 2004 - 2006
Serial number: XXXXXXXXXXXXXXXXXXXX

Reading file header of "C:\DBbackup\TMW_Training_FULL_20061117 Clean.sqb"

VDI error 1010: Failed to get configuration from server. Check that the SQL Ser
ver 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.)
SQL error 3013: RESTORE HEADERONLY is terminating abnormally.

Memory profile
Type Maximum Minimum Average Blk count Total

---

---

---

---

---

---

Commit 657653760 4096 947011 1990 1884553216
Reserve 67096576 4096 387347 594 230084608
Free 1572864 4096 97270 337 32780288
Private 657653760 4096 1125985 1800 2026774528
Mapped 4128768 4096 180326 80 14426112
Image 9850880 4096 104314 704 73437184

SQL Backup exit code: 1010
Last SQL error code: 3013

petey

It appears that there isn't a large enough block of contiguous free memory to service the requests. Could you pls try using the MAXTRANSFERSIZE option e.g.

C:\Program Files\Red Gate\SQL Backup\(LOCAL)>sqlbackupc -sql "RESTORE FILELISTONLY FROM DISK = 'C:\DBbackup\TMW_Training_FULL_20061117 Clean.sqb' WITH MAXTRANSFERSIZE = 65536"

Drovers

C:\Program Files\Red Gate\SQL Backup\(LOCAL)>sqlbackupc -sql "RESTORE FILELISTON
LY FROM DISK = 'C:\DBbackup\TMW_Training_FULL_20061117 Clean.sqb' WITH MAXTRANSF
ERSIZE = 65536"

Red Gate SQL Backup 4.6.0.815, (c) Red Gate Software Ltd 2004 - 2006
Serial number: 010-005-047592-7E63

Reading filelist of "C:\DBbackup\TMW_Training_FULL_20061117 Clean.sqb"

Logical name : psmaster52Data
Type : D (Data file)
Physical name : F:\TMW_Data\TMW_Training.mdf
Size : 22.735 GB

Logical name : psmaster52Log
Type : L (Log file)
Physical name : F:\TMW_Data\TMW_Training_log.ldf
Size : 30.000 MB

petey

Your free SQL Server memory has fallen to a level below what is required by SQL Backup for normal operations. It was 32.4 MB during the time of your initial post (Dec 7), and fell to 31.3 MB by 11 Dec. Because of fragmentation, the largest contiguous block of free memory fell from 2 MB to 1.5 MB during that time.

For a normal restore operation, SQL Backup requires approximately 6 MB of contiguous free memory. This can be adjusted by using the MAXTRANSFERSIZE option, by specifying a value between 64 KB and 1 MB. Using 64 KB, SQL Backup requires ~384 KB of contiguous free memory to run.

While SQL Backup automatically retries its backups with successively smaller MAXTRANSFERSIZE values, it does not do the same for restores.

If you want to, you can monitor the SQL Server processs' memory usage pattern using the sqbmemory extended stored procedure.

Drovers

I assume this will clear up if I restart the server, but how do I restore the database in the mean time?

petey

You can 'reset' things by bouncing the SQL Server service.

For now, you can still restore the database by using the MAXTRANSFERSIZE option. Use a value that is smaller than 1.5 MB when multiplied by 6, e.g. 65536, 131072 or 196608. A larger value allows the restore to complete faster, but the difference is not significant.

You might want to run sqbmemory first, to determine the current size of the largest contiguous block of free memory.

Drovers

Do I use the script that SQLBackup creates and add the MAXTRANSFERSIZE to the end?

petey

Yes e.g.

EXEC master..sqlbackup '-sql "RESTORE DATABASE TMW_Training
FROM DISK = [C:\DBbackup\TMW_Training_FULL_20061117 Clean.sqb] WITH MAXTRANSFERSIZE = 65536" '

Drovers

That worked.
Thanks for all the help.