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
ETM_INCAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mcmonapCommented:
Hi ETM_INC,

Check this out:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q278363
Do you have sp3 applied to SQL7?
0
ETM_INCAuthor Commented:
I have tried this upgrade with sql 7 running both sp3 and sp4.  Still no luck.
0
mcmonapCommented:
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?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

ETM_INCAuthor 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.
0
ETM_INCAuthor Commented:
Oops, wait, I just figured out what you meant.  I'll try that out and get an answer back.  Thanks.
0
mcmonapCommented:
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).
0
ETM_INCAuthor Commented:
Using DTS worked.  Thanks for the help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.