SQL7 Upgrade Errorgreenspun.com : LUSENET : SQL Server Database Administration : One Thread |
Dear Eric, For several days, I have been attempting to upgrade my databases from 6.5 to 7.0. I have several errors that have been generated that I have been able to fix. The one below however, is driving me crazy as I don't understand what the problem is. It states that a table SEEMS inconsistent. My DB designer and I have checked it out and everything looks fine to us. Any idea from the error messages below what is going on??##### Thursday, June 15, 2000 - 07:20:49 #####
Export Exit Code: -2147467259 - export.exe -CodePage 850 -DeviceType Pipe -AllTables yes -MasterPath D:\MSSQL\DATA\MASTER.DAT -DatabaseName explorer -DevicePath \\.\pipe\~cnvpipe0
An error occured while importing table. Please check the error file.
Time : 06-15-2000 07:22:23
An Error occured while exporting table cabins
Time : 06-15-2000 07:22:23
An Error occured while exporting database explorer
Time : 06-15-2000 07:22:23
An error occured while importing table. Please check the error file.
Time : 06-15-2000 07:22:23
pSql65Server->DumpAllTables () failed. hr=-2147467259
Import Exit Code: -1 - ~cnvpipe0
Msg 4854, Level 21, State 1, Server AKISQL, Procedure , Line 1
[Microsoft][ODBC SQL Server Driver][SQL Server]
Table [explorer].[dbo].[tbl_customer_info] seems inconsistent. DataPageNo=2212 TextPageNo=262 ColOffset=-14 RowOffset=32 state=4
-- Anonymous, June 15, 2000
Nathan,The error messages refer you to the error file.
The SQL Server Books Online article, "Completing the SQL Server Upgrade Wizard" offers this help in finding the error file:
For more information about specific errors, see the \Mssql\Upgrade\
_ _