Error received when attempting to restore a database backup, the restore operation may fail.
"Server: Msg 3205, Level 16, State 2, Line 1
Too many backup devices specified for backup or restore; only 64 are allowed.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally."
This is a Microsoft problem, a Hot Fix is available from Microsoft.
Refer to Microsoft Knowledge Base Article ID: 833710 - "FIX: You receive an error message when you try to restore a database backup that spans multiple devices":
http://support.microsoft.com/kb/833710
This problem may occur when all the following conditions are true:
- You want to restore a database backup that spans across multiple backup devices, and you have not specified more than 64 backup devices.
- You created the database backup on a computer that is running SQL Server 2000 Service Pack 3 (SP3) (Build 2000.80.869.0) or a later build of SQL Server 2000 SP3.
- You try to restore the database backup on a computer that is running a build of SQL Server 2000 SP3 that is earlier than 2000.80.869.0.
NOTE: The database backup created in SQL Server 2000 SP3 (Build 2000.80.869.0) or a later build of SQL Server 2000 SP3 is a valid backup. After installing the hotfix that is included in the article on the computer that is running SQL Server 2000 SP3 build that is earlier than 2000.80.869.0, restore the database backup without error.
