Cannot upgrade sql 7.0 database to sql 2000 database
Posted on 2006-03-20
I have about 12 databases in SQL 7.0 that I have upgraded using the copy database wizard to a new SQL 2000 server. All but one copied over and are now working. The one that is failing is giving me a table error message. Specifically, the error message I am receiving is:
Table error: Allocation page (1:352) has invalid IAM_PAGE page header values. Type is 0. Check type, object ID and page ID on the page.
When I ran the copy database wizard, I received an error message saying it couldn't attach the database.
I also tried using the backup of the database and restoring it on the sql 2000 box, but I received the same error message. This database works fine on sql 7.0.
How can I get this copied over and working on my 2000 box?