We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Cannot upgrade sql 7.0 database to sql 2000 database

ETM_INC
ETM_INC asked
on
Medium Priority
505 Views
Last Modified: 2008-02-01
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
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Hi ETM_INC,

Check this out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q278363
Do you have sp3 applied to SQL7?

Author

Commented:
I have tried this upgrade with sql 7 running both sp3 and sp4.  Still no luck.
CERTIFIED EXPERT
Commented:
Hi ETM_INC,

Are you able to create a script of the database, run this on the new server to create the database and then use DTS to copy the data over?

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Author

Commented:
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.

Author

Commented:
Oops, wait, I just figured out what you meant.  I'll try that out and get an answer back.  Thanks.
CERTIFIED EXPERT

Commented:
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).

Author

Commented:
Using DTS worked.  Thanks for the help!
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.