ETM_INC
asked on
Cannot upgrade sql 7.0 database to sql 2000 database
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?
Thanks,
Steve
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?
Thanks,
Steve
ASKER
I have tried this upgrade with sql 7 running both sp3 and sp4. Still no luck.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I'm not exactly sure what you mean by creating a script of the database. I have tried manually detaching and reattaching on the new server, and that hasn't worked either.
Here is the full message I am receiving.
Server: Msg 8939, Level 16, State 6, Line 1
Table error: Object ID 638625318, index ID 0, page (1:352). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 638625318, index ID 0, page (1:352). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8946, Level 16, State 1, Line 1
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.
Server: Msg 8946, Level 16, State 1, Line 1
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.
Server: Msg 1813, Level 16, State 1, Line 1
Could not open new database 'caf'. CREATE DATABASE is aborted.
Converting database 'caf' from version 515 to the current version 539.
Database 'caf' running the upgrade step from version 515 to version 524.
Database 'caf' running the upgrade step from version 524 to version 525.
Database 'caf' running the upgrade step from version 525 to version 526.
Database 'caf' running the upgrade step from version 526 to version 527.
Database 'caf' running the upgrade step from version 527 to version 528.
Database 'caf' running the upgrade step from version 528 to version 529.
Database 'caf' running the upgrade step from version 529 to version 530.
Database 'caf' running the upgrade step from version 530 to version 531.
Database 'caf' running the upgrade step from version 531 to version 532.
Here is the full message I am receiving.
Server: Msg 8939, Level 16, State 6, Line 1
Table error: Object ID 638625318, index ID 0, page (1:352). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID 638625318, index ID 0, page (1:352). Test ((m_type >=DATA_PAGE && m_type <= UNDOFILE_HEADER_PAGE) || (m_type == UNKNOWN_PAGE && level == BASIC_HEADER)) failed. Values are 0 and 101.
Server: Msg 8946, Level 16, State 1, Line 1
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.
Server: Msg 8946, Level 16, State 1, Line 1
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.
Server: Msg 1813, Level 16, State 1, Line 1
Could not open new database 'caf'. CREATE DATABASE is aborted.
Converting database 'caf' from version 515 to the current version 539.
Database 'caf' running the upgrade step from version 515 to version 524.
Database 'caf' running the upgrade step from version 524 to version 525.
Database 'caf' running the upgrade step from version 525 to version 526.
Database 'caf' running the upgrade step from version 526 to version 527.
Database 'caf' running the upgrade step from version 527 to version 528.
Database 'caf' running the upgrade step from version 528 to version 529.
Database 'caf' running the upgrade step from version 529 to version 530.
Database 'caf' running the upgrade step from version 530 to version 531.
Database 'caf' running the upgrade step from version 531 to version 532.
ASKER
Oops, wait, I just figured out what you meant. I'll try that out and get an answer back. Thanks.
Hi ETM_INC,
Post back if you have problems. To confirm your new database is identical to the old (structure and data) try using the tools from http://www.red-gate.com, I have found them to be very reliable. There is a trial period for evaluation so you there is no cost (I would recomend buying them if you do this kind of thing a lot though).
Post back if you have problems. To confirm your new database is identical to the old (structure and data) try using the tools from http://www.red-gate.com, I have found them to be very reliable. There is a trial period for evaluation so you there is no cost (I would recomend buying them if you do this kind of thing a lot though).
ASKER
Using DTS worked. Thanks for the help!
Check this out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q278363
Do you have sp3 applied to SQL7?