FIX: Second LOAD DB of 4.2x DUMP May Corrupt New System Tables

ID: Q133406

The information in this article applies to:

Microsoft SQL Server version 6.0

BUG# NT: 10969 (6.00)

SYMPTOMS

If you load a Microsoft SQL Server version 4.2x DUMP into the same SQL Server version 6.0 database twice, the second load results in 1902 errors on the sysreferences and sysconstraints system tables.

CAUSE

This problem only occurs if you LOAD DATABASE into the same database and if SQL Server is not restarted between LOAD DATABASE commands.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.0. This problem was corrected in Service Pack 1 for SQL Server version 6.0. For more information, contact your primary support provider.

MORE INFORMATION

These errors are only visible to the user if you manually issue the LOAD DATABASE command. The database is not marked suspect, and the upgrade appears fine otherwise. The database, however, is corrupt, and the test is to run sp_help on either of these two tables. If a 602 error occurs, then this bug is the problem.

Additional query words: sql6 Windows NT upgrade


Keywords          : kbusage kbbug6.00 kbfix6.00.sp1 SSrvWinNT 
Version           : 6.0
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 21, 1999