Wednesday, March 21, 2012

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
Description:Database upgrade failed due to MovePage

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

Any ideas?

Thanks

JohnTry taking a backup on SQL7 and then restore on the SQL2000 server instead of copying.
--jfp

No comments:

Post a Comment