Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Posts
    1

    Red face Unanswered: Failed SQL 7.0/SQL200 Database copy

    I recently used the copy data base wizard to copy an existing database from SQL7.0 to SQL2000. The copy was in general a success except for the fact that the copied database gives the error "could not open database "MainDB" version 5.25. Upgrade to the latest version. I performaed a detach on the database and then a reattach to force an upgrade but the reattach process fails with the error

    Error 3624:
    Converting database "MainDB" from version 525 to current version 539.
    Database "mainDB" running the upgrade step from verion 525 to vesrion 526.
    Location:Upgraddb.cpp:2230
    Expression:0
    SPID:53
    ProcessID:1088
    Descriptionatabase upgrade failed due to MovePage


    I earlier successfully moved another database between the same two servers without any problems.


    Any ideas???

    Thanks

    John

  2. #2
    Join Date
    Apr 2002
    Posts
    20
    Try taking a backup on SQL7 and then restore on the SQL2000 server instead of copying.
    --jfp

Posting Permissions

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