Too many backup devices

Posted on 2007-10-05
Last Modified: 2010-03-19
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?
Question by:saturation
    LVL 27

    Expert Comment

    What are you restoring on? Another 2005 database? The same database? A 2000 database?

    What are you using to restore the backup?

    Author Comment

    Restoring onto a 2000 database.
    LVL 27

    Accepted Solution

    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.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    759 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

    14 Experts available now in Live!

    Get 1:1 Help Now