BUG: Exiting the Upgrade Wizard During Validation Causes Errors

• Microsoft SQL Server version 7.0

SYMPTOMS

When upgrading a SQL Server 6.5 database to SQL Server 7.0, if the Validate successful object data transfer option is selected and the Upgrade Wizard is closed during data validation, an informational error file is displayed when the upgrade later resumes.

This error file contains messages such as:

[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'objects'.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tempdb.dbo.objects'.

CAUSE

The Upgrade Wizard stores data validation information in a temporary table in tempdb. When the Upgrade Wizard is closed, SQL Server is stopped. When the upgrade then resumes, SQL Server is restarted and tempdb is re-created; thus resulting in the loss of previously gathered data validation information.

WORKAROUND

To work around this problem, do not stop the Upgrade Wizard during the data verification process. Instead, pause and resume the upgrade without closing the application.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 7.0.

MORE INFORMATION

Although this problem will not prevent the upgrade from completing successfully, the missing tables in tempdb prevent data validation from completing after the upgrade process is resumed.

Additional query words: upgrade wizard verify data validate error err msg message

Keywords : kbbug7.00
Version : winnt:7.0
Platform : winnt
Issue type : kbbug