Too many devices are specified for backup or restore operations; only 64 devices are allowed. The RESTORE database operation terminated abnormally.
When you restore a database, there are too many devices specified for the backup or restore operation, and only 64 devices are allowed. The RESTORE database operation terminated abnormally. "This error indicates that you are restoring the backed-up data from the SQLServer2005 to the SQLServer2000 database. This error occurs: 1 does not indicate that your computer system is faulty (without reloading the system). 2. Your SQLServer2005 or SQLServer2000 database installation is problematic (without reloading the database). 3. Do not abuse Microsoft garbage.
Very simple, as long as you connect to the SQLServer2005 SQLExpress instance. Restore on the SQLServer2005 library. Download the SQL Server Management Studio Express software, which is a tool for connecting to management SQLServer2005. can help you restore the database, and emphasize that, although using the SQL Server Management Studio Express Tool, SQLEXPRESS This instance is the 2005 database (./sqlexpress) you want to connect to. instead of (.) or (local) if it is (.) or (local) stating that you are not connected to the SQLSERVER2005 database and will also make an error, you must be sure that you are actually connected to the SQLSERVER2005 database.
Finally summed up: SQLServer2005 and SQLServer2000 Backup is not universal, therefore, when restoring the database can not be confused, especially, when downloading some source code from the Internet, some database backup, no note is 2005 or 2000, when the above error, It means that you are restoring the data that you backed up from SQLServer2005 to the SQLServer2000 database. Need to pay attention.
This article from Csdn Blog, reproduced please indicate the source: http://blog.csdn.net/tlnyhl/archive/2009/02/11/3878432.aspx