Article ID: 199104
Article Last Modified on 10/16/2002
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
This article was previously published under Q199104
BUG #: 52634 (SQLBUG_70)
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 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: kbbug kbpending KB199104