FIX: Second LOAD DB of 4.2x DUMP May Corrupt New System Tables |
Q133406
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.
This problem only occurs if you LOAD DATABASE into the same database and if SQL Server is not restarted between LOAD DATABASE commands.
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.
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
Issue type : kbbug
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600
|
Last Reviewed: March 25, 2000 © 2001 Microsoft Corporation. All rights reserved. Terms of Use. |