Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002

    Unanswered: Restore SQL 2000 database onto a SQL 7 box

    Is it possible to restore a SQL 2000 database backup onto a SQL 7 box?

    I tried and it quite rightly complained about database structure versions are different.

    Is there a way to backup SQL 2000 in such a way that only SQL 7 features are preserved? and thus can be restored on to a SQL 7 box.

    The database it self is really quite simple. Just tables (plus data) and SPs.

  2. #2
    Join Date
    Feb 2002
    Houston, TX
    No you can't restore a 2K database onto a 7 box. You can use DTS to move data OR BCP the data out of the 2K box and into the 7 box.
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

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