Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2007
    Posts
    54

    Unanswered: How can I restore a SQL 2005 database on my SQL 2000?

    My customer has SQL Server 2005. I have SQL Server 2000 on my laptop (on XP Pro). I believe I have an empty database the same as theirs, but I need to restore their data. They sent me a normal SQL Backup, but my laptop threw a fit and cannot work with it.

    They are now trying to export the database to Microsoft Access and send me that, but I won't get that until next week now. However is there a better and easier solution for those of us with insufficient experience of this, please?

    Many thanks,
    Caspar

  2. #2
    Join Date
    May 2007
    Posts
    49
    There is no way to restore SQL 2005 backup on SQL 2000.

    Easiest way in this case is - install Express Edition of SQL 2005, restore your backup there and then import it to SQL 2000.
    Mihir Mehendale
    DB Team @ Clarion
    Clarion Technologies
    (SEI CMMI Level 3)
    Pune, India
    www.clariontechnologies.co.in
    www.vEmployee.com

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Or you might consider skipping the import to SQL 2000, and just work on it using SQL 2005 Express on your laptop.

    -PatP

  4. #4
    Join Date
    Jul 2007
    Posts
    54
    Thank you so much for this advice. I am in the process of trying it, having found downloads at: http://msdn.microsoft.com/vstudio/express/sql/download/ where I am offered 2 choices - I have chosen the left-hand pair of files for a simpler setup.

    If I am successful in restoring the database to this then if I do decided I want to import it into SQL 2000 then how to I go about that, please?

    Many thanks,
    Caspar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •