SQL Server Performance

Database Restoring

Discussion in 'General DBA Questions' started by Satya_17, Dec 4, 2002.

  1. Satya_17 New Member

    We have the file backup of a database from SQL 2000 server, and when i try to restore this on SQL7.0 server it gives me an error as following

    Error: 3624
    SQL (DMO)
    Location: upgraddb, cpp:214
    Expression: table index < ARRAY_LEN (Upgrade MAP)
    SPID:10
    Process ID:624

    Please can any one tell me how to restore the database on SQL 7.0 server.

    Thanx in advance.


    Satya Daragani
    satya_17@yahoo.com
  2. Chappy New Member

    I would not have expected sql2000 backups to be readable by sql7.0, but I dont know for sure. Certainly from your results its looking unlikely.

    For the upgrade from 6.x to 7.0, SQL7.0 couldnt read 6.0's backups, so they werent even backwardly compatible!
  3. bradmcgehee New Member

    You cannot directly restore a SQL Server 2000 backup to SQL Server 7.0, that's way you got the message you did. The way I get around this problem is to use DTS to move all of the objects and data from the SQL Server 2000 database to the SQL Server 7.0 database. If the database is large, this can take a long time.

    Does anyone else have any more efficient ideas than using DTS?


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  4. tkelley New Member

    You are correct, Brad. I've tried several different scenarios and only DTS has worked.

Share This Page