We are having quite a time since moving a large database to a new
server (actually built new server, renamed as old to make seamless for
users, etc.)
Import 104 million row database (5 column) into table (CD_Assets_bad2 )
from existing (CD_Assets):
Account(varchar (8))
TransactionDate (datetime(8)
Flow(varchar(1) )
Category(varcha r(7))
TotalValue(deci mal(8))
Run DBCC CheckTable - no issues.
Create 4 non clustered indexes (3 single column, 1 two-column). All
indexes create fine.
Run DBCC CheckTable again and receive the following:
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'CD_Assets_bad2 ' (ID 244195920). Missing or invalid
key in index 'idx_totalvalue ' (ID 7) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:11154499:98) identified by (RID = (1:11154499:98) ) has
index values (TotalValue = -10).
Server: Msg 8952, Level 16, State 1, Line 1
Table error: Database 'CD', index 'CD_Assets_bad2 .idx_totalvalue ' (ID
244195920) (index ID 7). Extra or invalid key for the keys:
Server: Msg 8956, Level 16, State 1, Line 1
Index row (1:20855652:338 ) with values (TotalValue = -0¤
4) points to the data row identified by (RID = (1:11154499:98) ).
DBCC results for 'CD_Assets_bad2 '.
There are 104397173 rows in 677904 pages for object 'CD_Assets_bad2 '.
CHECKTABLE found 0 allocation errors and 2 consistency errors in table
'CD_Assets_bad2 ' (object ID 244195920).
repair_fast is the minimum repair level for the errors found by DBCC
CHECKTABLE (CD.dbo.CD_Asse ts_bad2 ).
Any ideas? It seems like some sort of corruption, but the index
creates fine. If anyone can help please let me know. If I can provide
any addtional information that might help, please let me know.
Thanks,
David
da************@ schwab.com