?
Solved

Cannot upgrade sql 7.0 database to sql 2000 database

Posted on 2006-03-20
8
Medium Priority
?
492 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
0
Comment
Question by:ETM_INC
  • 4
  • 3
7 Comments
 
LVL 15

Expert Comment

by:mcmonap
ID: 16241321
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
 

Author Comment

by:ETM_INC
ID: 16241364
I have tried this upgrade with sql 7 running both sp3 and sp4.  Still no luck.
0
 
LVL 15

Accepted Solution

by:
mcmonap earned 2000 total points
ID: 16241744
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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:ETM_INC
ID: 16241979
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
 

Author Comment

by:ETM_INC
ID: 16242134
Oops, wait, I just figured out what you meant.  I'll try that out and get an answer back.  Thanks.
0
 
LVL 15

Expert Comment

by:mcmonap
ID: 16244838
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
 

Author Comment

by:ETM_INC
ID: 16445261
Using DTS worked.  Thanks for the help!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question