This article has been archived. It is offered "as is" and will no longer be updated.
Bug #: 470782 (SQL Server 8.0)
Microsoft SQL Server 2000 fixes are distributed as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included in the previous SQL Server 2000 fix release.
When you try to restore a database backup, the restore operation may fail. You may receive an error message that is similar to the following:
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 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 that you 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 you install the hotfix that is included in this article on the computer that is running SQL Server 2000 SP3 build that is earlier than 2000.80.869.0, you can restore the database backup.
Service pack information
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 How to obtain the latest SQL Server 2000 service pack
The English version of this hotfix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
Microsoft SQL Server 2000 Service Pack 3, Microsoft SQL Server 2000 Service Pack 3, Microsoft SQL Server 2000 Service Pack 3, Microsoft SQL Server 2000 Personal Edition Service Pack 3, Microsoft SQL Server 2000 Service Pack 3, Microsoft SQL Server 2000, Workgroup Edition, Microsoft SQL Server 2000 Developer Edition, Microsoft SQL Server 2000 Enterprise Edition 64-bit