Solved

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

Posted on 2014-02-01
4
844 Views
Last Modified: 2014-04-04
i get this error

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



when restore back up file
0
Comment
Question by:loveuajay
  • 2
4 Comments
 
LVL 79

Accepted Solution

by:
David Johnson, CD, MVP earned 200 total points
ID: 39826014
Which product did you use for backup?
0
 

Author Comment

by:loveuajay
ID: 39826015
sql server 2005
0
 

Author Comment

by:loveuajay
ID: 39826018
sql server 2005 express edition
0
 
LVL 40

Assisted Solution

by:Jacques Bourgeois (James Burger)
Jacques Bourgeois (James Burger) earned 300 total points
ID: 39826678
This message tends to show up when you are trying to restore a database that was created with a newer version of SQL Server. The format of the files has changed, and the problem is not interpreted correctly, bringing up a message that has nothing to do with the real problem.

Are you sure that your database was backed up from a 2005 edition of SQL Server?
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question