• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • 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?
0
saturation
Asked:
saturation
  • 2
1 Solution
 
ptjcbCommented:
What are you restoring on? Another 2005 database? The same database? A 2000 database?

What are you using to restore the backup?
0
 
saturationAuthor Commented:
Restoring onto a 2000 database.
0
 
ptjcbCommented:
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.

0

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

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