restore SQL database error - Too many backup devices specified for backup or restore; only 64 are allowed

Posted on 2007-08-02
Medium Priority
Last Modified: 2009-07-07
We just got a SQL 2005 backup from a customer, and when we try restore it at OUR office, we get the following error:

Too many backup devices specified for backup or restore; only 64 are allowed.
RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3205)

At first - we had SQL 2000 - but upgraded to SQL 2005 - and I get the same error!
Question by:Alon Hirsch

Accepted Solution

yomoconcepts earned 1500 total points
ID: 19615700
You should set the backwards compatibility flag on SQL Server2005. If my memory serves me correctly. We had this issue last year and took ages to figure out.

Expert Comment

ID: 19871628
Are the SQL Server 2005 version on which the back up was taken is the same as the one you are trying to restore?
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Author Comment

by:Alon Hirsch
ID: 19877895
srinvask: Yes, the SQL versions are the same.

Expert Comment

ID: 24084446

This is an unfortunately deceiving error message. It occurs when a SQL 2005 backup is used in a restore attempt on a SQL 2000 database.



Installing on a SQL 2005 or 2008 database will eliminate this error. As of Release 8.3, VersionOne support for SQL 2000 has been deprecated.


Expert Comment

ID: 24793606
If we intall it on SQL 2008 then the same problem will come while installing ir back on SQL 2005. Actually there shoul be some way out to retore it from SQL 2005 to SQL 2005 and back on two different locations.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

840 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