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

Posted on 2007-08-02
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:AlonHirsch

    Accepted Solution

    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


    Expert Comment

    Are the SQL Server 2005 version on which the back up was taken is the same as the one you are trying to restore?
    LVL 4

    Author Comment

    srinvask: Yes, the SQL versions are the same.
    LVL 2

    Expert Comment


    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

    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

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

    734 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now