Restore SQL Server 2005 Backup into MSDE

Posted on 2009-04-22
Last Modified: 2013-11-30
I'm trying to restore a 25Mb Backup from SQL Server 2005 into MSDE for one of my applications.  I'm getting the following errors when trying to restore the backup;
   Msg 3205, Level 16, State 2, Server BASCOMPUTER, Line 1
   Too many backup devices specified for backup or restore; only 64 are allowed.
   Msg 3013, Level 16, State 1, Server BASCOMPUTER, Line 1
   RESTORE DATABASE is terminating abnormally.

Thanks for the help,
Question by:M_a_t
    LVL 8

    Accepted Solution

    I assume that your MSDE is SQL 2000.  

    Author Comment

    Thanks for your input.   My MSDE is in fact SQL 2000.  Is there a way to bypass this error without having to install MSDE SQL 2005?
    LVL 4

    Assisted Solution

    You cannot restore SQL 2005 database on SQL 2000.  MSDE was the lightest engine from SQL 2000 family.  SQL Express is the equivalent of MSDE in SQL 2005 family.
    If you have a problem installing SQL express they you can manually transfer the data to MSDE.  This is not stright forward process.  You would need to:
    1.  Create a schema of the database. You can script out all objects of your database in SQL 2005 and then play it in SQL 2000, hopefully the syntax will be compatible.
    2.  You would need to turn off all foreign keys.
    3.  You would need to copy all the data.  This can be done using DTS, link servers, etc.
    4.  Turn on all FKs.
    Hopefully, job is done :-)
    LVL 4

    Expert Comment

    Another option is Replication,  I believe you should be able to subsribe your SQL 2000 to the publication.  Explore this way if you have experience of using Replication.  Otherway go with the first option.
    LVL 30

    Assisted Solution

    Any reason you have to use MSDE as opposed to SQL Express?

    Author Comment

    Finally, I was able to use SQL Express from the distributor of my software and now everything works fine.

    Author Closing Comment

    I was able to use SQL Express with the software after discussing with the distributor of the software that needs SQL.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    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
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    779 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

    15 Experts available now in Live!

    Get 1:1 Help Now