Error: Failed to read file list from backup file

• 
  What is the result when you run the RESTORE FILELISTONLY command manually on the file you are trying to restore? E.g. from within Query Analyzer or SSMS
  
  master..sqlbackup '-sql "RESTORE FILELISTONLY FROM DISK = [<file name>]" '

  petey November 01, 2006 10:36

  - 0 +
• 
  I can't really do that since the data does not reside on our system yet. We depend on receiving data from our customer as a red gate backup. We then turn around and restore the data to our system. However, this is a new set of data and we cannot restore the redgate backup. When I try to run the restore via command line I receive the following error.
  
  SQL Backup log file
  11/1/2006 9:53:09 AM: Red Gate SQL Backup 4.5.0.704, (c) Red Gate Software Ltd 2004 - 2006
  11/1/2006 9:53:09 AM:
  11/1/2006 9:53:09 AM: Restoring DBNAME (database) from:
  C:\backup\zzz\DBNAME01.sqb
  C:\backup\zzz\DBNAME02.sqb
  C:\backup\zzz\DBNAME03.sqb
  C:\backup\zzz\DBNAME04.sqb
  
  11/1/2006 9:53:09 AM: RESTORE DATABASE [DBNAME] FROM DISK = 'C:\backup\zzz\DBNAME01.sqb', DISK = 'C:\backup\zzz\DBNAME02.sqb', DISK = 'C:\backup\zzz\DBNAME03.sqb', DISK = 'C:\backup\zzz\DBNAME04.sqb' WITH RECOVERY, MOVE 'Software_Data' TO 'C:\13Software\DBNAME.MDF', MOVE 'Software_Log' TO 'C:\Software\DBNAME_log.LDF', REPLACE', PASSWORD = 'XXXXXXXXXX'
  
  
  11/1/2006 9:53:09 AM: Server: Msg 3013
  RESTORE DATABASE is terminating abnormally.
  11/1/2006 9:53:09 AM: Server: Msg 3205
  Too many backup devices specified for backup or restore; only 64 are allowed.

  kermi November 01, 2006 11:15

  - 0 +
• 
  One possible reason for that error is that the backup files were created using SQL Server 2005, and they are now being restored using SQL Server 2000.
  
  Is this the case?

  petey November 01, 2006 20:38

  - 0 +
• 
  Yes that is the case. What's the work around for that???

  kermi November 02, 2006 10:11

  - 0 +
• 
  There is no way to restore a SQL Server 2005 backup onto a SQL Server 2000 instance.
  
  If licensing is an issue, perhaps SQL Server 2005 Express (http://msdn.microsoft.com/vstudio/express/sql/) may be an option, if your database is less than 4 GB?

  petey November 02, 2006 10:57

  - 0 +
• 
  I was afraid you were going to say that. I think we may just have to bite the bullet and upgrade.
  
  Any issues restoring redgate backups from 2000 to 2005?

  kermi November 02, 2006 11:22

  - 0 +
• 

  Any issues restoring redgate backups from 2000 to 2005?

  
  None.

  petey November 02, 2006 11:28

  - 0 +

Add comment

Please sign in to leave a comment.