Symptoms

I am trying to restore the backup of our hosted database to my SQL Server 2000 database to set up our local system.  After I specify the backup device I get the following error:

Error 3205: Too many backup devices specified for backup or restore; only 64 are allowed.  RESTORE FILELIST is terminating abnormally

 

Cause

This is an unfortunately deceiving error message. It occurs when a SQL 2005 backup is used in a restore attempt on a SQL 2000 database. Our hosted servers run SQL 2005.

Resolution

Installing on a SQL 2005 database will eliminate this error.

If you cannot use a database running SQL 2005, VersionOne can create a SQL2000 version of your data for you to install locally using your existing system. Submit a request to VersionOne support using the Ask A Question feature.

Note: This conversion is database-specific, so this offer applies only to customers who need to convert their VersionOne application database.