Microsoft KB Archive/837938

= You may receive an error message when you try to restore a SQL Server 7.0 database backup on an instance of SQL Server 2000 =

Article ID: 837938

Article Last Modified on 3/19/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



SYMPTOMS
When you try to restore a Microsoft SQL Server 7.0 database backup on an instance of SQL Server 2000, the restoration operation may not be successful. You may receive an error message that is similar to the following:

Processed 160 pages for database ' ', file ' ' on file 1.

Processed 1 pages for database ' ', file ' ' on file 1.

Server: Msg 3624, Level 20, State 1, Line 1

Converting database ' ' from version 515 to the current version 539.

Database ' ' running the upgrade step from version 515 to version 524.

Database ' ' running the upgrade step from version 524 to version 525.

Database ' ' running the upgrade step from version 525 to version 526.

Database ' ' running the upgrade step from version 526 to version 527.

Location: upgraddb.cpp:1430

Expression: PageId_FIRST_SYSOBJECTS_AFTER_527 == newPageId

SPID: 52

Process ID: 1548

Connection Broken

Note This problem occurs when trace flag 1118 is turned on for your instance of SQL Server 2000.



WORKAROUND
To work around this problem, turn off trace flag 1118, and then restore the SQL Server 7.0 database backup. After you successfully restore the SQL Server 7.0 database backup, you can turn on trace flag 1118. To do so, follow these steps:  Start SQL Query Analyzer, and then connect to your instance of SQL Server 2000.  Run the following Transact-SQL statement to turn off trace flag 1118 on your instance of SQL Server 2000: DBCC TRACEOFF (1118)  Restore the SQL Server 7.0 database backup. For more information, visit the following Microsoft Web site:

http://msdn2.microsoft.com/en-us/library/aa196683(SQL.80).aspx

  Run the following Transact-SQL statement to turn on trace flag 1118 on your instance of SQL Server 2000: DBCC TRACEON (1118) 



Steps to reproduce the problem
 Start SQL Query Analyzer, and then connect to your instance of SQL Server 7.0. Take the backup of the Pubs database from your instance of SQL Server 7.0.</li> Close SQL Query Analyzer.</li> Start SQL Query Analyzer, and then connect to your instance of SQL Server 2000.</li>  Turn on trace flag 1118 for your instance of SQL Server 2000. To so do, run the following Transact-SQL statement: DBCC TRACEON (1118) GO </li> Restore the SQL Server 7.0 database backup that is taken in step 2.

You receive the error message that is mentioned in the &quot;Symptoms&quot; section of this article.</li></ol>

<div class="references_section">