• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

Too many backup devices

I'm trying to restore to a backup 2005 database, but keep getting the error:

"Too many backup devices specified for backup or restore; only 64 are allowed."

I don't have more than that--no where close, actually.  What's going on here?
  • 2
1 Solution
What are you restoring on? Another 2005 database? The same database? A 2000 database?

What are you using to restore the backup?
saturationAuthor Commented:
Restoring onto a 2000 database.
Ah, you can not do that. Sorry.

There are many differences between SQL 2005 and SQL 2000 (the system databases are different, for example). There is no downgrade capabilities for SQL 2005 databases. You cannot restore a SQL 2005 backup on a SQL 2000 server. You cannot detach a SQL 2005 database and reattach it to a SQL 2000 server.

The only thing you can do is generate the database structure (using the Generate script tool in SQL Server Management Studio, or by using a script generator). Then using either DTS or SSIS you move the data to populate the database.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now