October 3, 2002 at 7:36 am
Whilst planning an upgrade from SQL7 to SQL2000 I have been testing restoration on SQL2000 of backups made on SQL7
I have encountered the following error on one database while restoring:
RESTORE DATABASE is terminating abnormally
Converting database <db_name> from version 515 to the current version 539
Database <db_name> running the upgrade step from version 515 to version 524
Ditto from 524 to 525
Ditto from 525 to 526
I got a similar error when using SQL2000 to attach the SQL7 database files directly
I am using SQL7 + SP3 and SQL2000 +SP2 + hotfix 8.00.0667
Any suggestions much appreciated
StefanB
October 3, 2002 at 12:19 pm
I recently migrated databases in the same fashion and everything went well. 7 sp3 to 2000 sp 2.
If I were in your shoes I would try isolating the problem. Does it happen with every database, user databases, or system databases? Maybe try using a test database like Northwind and see what happens. Are you running replication?
My gut feeling is that there is some object or configuration in that one database that is causing the error.
When I migrated to a 2000 server I scripted all my logins, jobs, permissions, etc. so I wouldn't be restoring the master or msdb databases from a 7.0 version.
"Keep Your Stick On the Ice" ..Red Green
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply