What are the challenges you face when working across database platforms? Take the survey
Options

Failed to read file list from backup file.

DroversDrovers Posts: 8
edited December 15, 2006 11:12AM in SQL Backup Previous Versions
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

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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.
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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
  • Options
    peteypetey Posts: 2,358 New member
    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"
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    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
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    I assume this will clear up if I restart the server, but how do I restore the database in the mean time?
  • Options
    peteypetey Posts: 2,358 New member
    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    Do I use the script that SQLBackup creates and add the MAXTRANSFERSIZE to the end?
  • Options
    peteypetey Posts: 2,358 New member
    Yes e.g.

    EXEC master..sqlbackup '-sql "RESTORE DATABASE TMW_Training
    FROM DISK = [C:\DBbackup\TMW_Training_FULL_20061117 Clean.sqb] WITH MAXTRANSFERSIZE = 65536" '
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
  • Options
    That worked.
    Thanks for all the help.
Sign In or Register to comment.