August 5, 2010 at 10:44 am
Hi all.
We have a SQL 2000 database that is causing a few headaches. Its up to SP4 and running on an active/passive cluster on Windows 2003. The users access the database via an MS Access 2000 frontend that uses SP's to perform all insert/update/delete actions.
Every few weeks an index will get corrupted. As yet we have no idea why. The server isn't under any particular strain (CPU 40% max, 1.6Gb free RAM). The database is approx 13Gb in size and is replicated to another database on the same server. There are approx 500 concurrent users who only access main database not the replicated one.
Most of the time the corruption occurs on the largest table (2Gb) but has sometimes occured on the replicated copy of that table and not on the main copy.
We set the index rebuild to run each night and since then (3 months) it hasn't happenned since, but I'd like to get an idea on the possible causes.
The event log only shows the below error:
[sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][ODBC SQL Server Driver]Communication link failure
Event id 17052
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
SuperSocket info: (SpnRegister) : Error 8344.
[sqsrvres] OnlineThread: service stopped while waiting for QP.
The users all connect through the same 8mb connection which at times gets maxed out. Could this potentially cause this issue?
I'm looking for ideas/pointers as for where to look or for articles on the web that may help.
August 5, 2010 at 10:54 am
When you have an instance of the corruption, post the output from CHECKDB please so we can see what the corruption is. Could be a number of different things - my guess is that invalid data is being entered into the database (which is possible in 2000, but not in 2005 onwards).
When you get the corruption, do the following:
DBCC TRACEON (2570)
GO
DBCC CHECKTABLE (tablewithbrokenindex) WITH ALL_ERRORMSGS, NO_INFOMSGS
GO
DBCC TRACEOFF (2570)
GO
And post the results.
The traceflag enables some undocumented column data type checks that I put in to 2000.
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
August 9, 2010 at 7:33 am
Next time the corruption happens I'll try to post the results here.
In the mean time, I have been told that the users are maxing out their bandwidth connecting to the server (server network is unaffected) and are receiving "3146 odbc call failed error" and "odbc sql server driver expired while trying to access" error messages during busy network periods. Could one of these dropped connections cause an index to get corrupted?
August 9, 2010 at 7:59 am
david.r.nicholson (8/9/2010)
Could one of these dropped connections cause an index to get corrupted?
Unlikely (unless there's a bug in SQL 2000 that I've forgotten about). Vast majority of the time corruption is an IO subsystem problem.
Depends what corruption you're seeing. If it's torn pages or otherwise corrupt pages, it's likely IO subsystem. If it's invalid data (as Paul suggested), might be a bug in the ODBC driver or in SQL.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 19, 2010 at 8:17 am
I know it been a while, but the corruption has just occured again. Output as requested is below:
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
The result of the initial Checkdb was
DBCC results for 'abcReports'.
DBCC results for 'sysobjects'.
There are 284 rows in 6 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 207 rows in 14 pages for object 'sysindexes'.
DBCC results for 'syscolumns'.
There are 1643 rows in 37 pages for object 'syscolumns'.
DBCC results for 'systypes'.
There are 26 rows in 1 pages for object 'systypes'.
DBCC results for 'syscomments'.
There are 323 rows in 80 pages for object 'syscomments'.
DBCC results for 'sysfiles1'.
There are 2 rows in 1 pages for object 'sysfiles1'.
DBCC results for 'syspermissions'.
There are 136 rows in 1 pages for object 'syspermissions'.
DBCC results for 'sysusers'.
There are 20 rows in 1 pages for object 'sysusers'.
DBCC results for 'sysproperties'.
There are 0 rows in 0 pages for object 'sysproperties'.
DBCC results for 'sysdepends'.
There are 1227 rows in 10 pages for object 'sysdepends'.
DBCC results for 'sysreferences'.
There are 0 rows in 0 pages for object 'sysreferences'.
DBCC results for 'sysfulltextcatalogs'.
There are 0 rows in 0 pages for object 'sysfulltextcatalogs'.
DBCC results for 'sysfulltextnotify'.
There are 0 rows in 0 pages for object 'sysfulltextnotify'.
DBCC results for 'sysfilegroups'.
There are 1 rows in 1 pages for object 'sysfilegroups'.
DBCC results for 'tbl1'.
There are 21 rows in 1 pages for object 'tbl1'.
DBCC results for 'tbl2'.
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:8) identified by (RID = (1:576689:8) 3ID = 3100942) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Dec 2 2007 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:9) identified by (RID = (1:576689:9) 3ID = 3100943) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Dec 9 2007 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:10) identified by (RID = (1:576689:10) 3ID = 3100944) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Dec 16 2007 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:11) identified by (RID = (1:576689:11) 3ID = 3100945) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Dec 23 2007 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:12) identified by (RID = (1:576689:12) 3ID = 3100946) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Dec 30 2007 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:13) identified by (RID = (1:576689:13) 3ID = 3100947) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Jan 6 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:14) identified by (RID = (1:576689:14) 3ID = 3100948) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Jan 13 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:15) identified by (RID = (1:576689:15) 3ID = 3100949) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Jan 20 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:16) identified by (RID = (1:576689:16) 3ID = 3100950) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Jan 27 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:17) identified by (RID = (1:576689:17) 3ID = 3100951) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Feb 3 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:18) identified by (RID = (1:576689:18) 3ID = 3100952) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Feb 10 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:19) identified by (RID = (1:576689:19) 3ID = 3100953) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Feb 17 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:20) identified by (RID = (1:576689:20) 3ID = 3100954) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Feb 24 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:21) identified by (RID = (1:576689:21) 3ID = 3100955) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Mar 2 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:22) identified by (RID = (1:576689:22) 3ID = 3100956) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Mar 9 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:23) identified by (RID = (1:576689:23) 3ID = 3100957) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Mar 16 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:24) identified by (RID = (1:576689:24) 3ID = 3100958) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Mar 23 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:25) identified by (RID = (1:576689:25) 3ID = 3100959) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Mar 30 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:26) identified by (RID = (1:576689:26) 3ID = 3100960) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Apr 6 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:27) identified by (RID = (1:576689:27) 3ID = 3100961) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Apr 13 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:28) identified by (RID = (1:576689:28) 3ID = 3100962) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Apr 20 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:29) identified by (RID = (1:576689:29) 3ID = 3100963) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Apr 27 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:30) identified by (RID = (1:576689:30) 3ID = 3100964) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = May 4 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:31) identified by (RID = (1:576689:31) 3ID = 3100965) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = May 11 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:32) identified by (RID = (1:576689:32) 3ID = 3100966) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = May 18 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:33) identified by (RID = (1:576689:33) 3ID = 3100967) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = May 25 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:34) identified by (RID = (1:576689:34) 3ID = 3100968) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Jun 1 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:35) identified by (RID = (1:576689:35) 3ID = 3100969) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Jun 8 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:36) identified by (RID = (1:576689:36) 3ID = 3100970) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Jun 15 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:37) identified by (RID = (1:576689:37) 3ID = 3100971) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Jun 22 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:38) identified by (RID = (1:576689:38) 3ID = 3100972) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Jun 29 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:39) identified by (RID = (1:576689:39) 3ID = 3100973) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Jul 6 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:40) identified by (RID = (1:576689:40) 3ID = 3100974) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Jul 13 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
There are 13 rows in 1 pages for object 'tbl2'.
DBCC results for 'tblNewText'.
There are 18 rows in 1 pages for object 'tblNewText'.
DBCC results for 'tblOldText'.
There are 4 rows in 1 pages for object 'tblOldText'.
DBCC results for 'tbl4'.
There are 10 rows in 1 pages for object 'tbl4'.
DBCC results for 'tblStudent'.
There are 185040 rows in 9904 pages for object 'tblStudent'.
DBCC results for 'tbl5'.
There are 16 rows in 1 pages for object 'tbl5'.
DBCC results for 'tbl6'.
There are 10 rows in 1 pages for object 'tbl6'.
DBCC results for 'tblBusinessNOTE'.
There are 116977 rows in 946 pages for object 'tblBusinessNOTE'.
DBCC results for 'tblBusinessk'.
There are 373243 rows in 3165 pages for object 'tblBusinessk'.
DBCC results for 'tblDoodle'.
There are 371247 rows in 5574 pages for object 'tblDoodle'.
DBCC results for 'tbl5INPROGRESS'.
There are 301070 rows in 2614 pages for object 'tbl5INPROGRESS'.
DBCC results for 'tblmoreinfo'.
There are 1943526 rows in 25097 pages for object 'tblmoreinfo'.
DBCC results for 'tbl3'.
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:41) identified by (RID = (1:576689:41) 3ID = 3100975) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Jul 20 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:42) identified by (RID = (1:576689:42) 3ID = 3100976) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Jul 27 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:43) identified by (RID = (1:576689:43) 3ID = 3100977) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Aug 3 2008 12:00AM and Value = 94.07 ...
Server: Msg 8951, Level 16, State 1, Line 1
Table error: Table 'tbl3' (ID 875150163). Missing or invalid key in index 'idx_tbl3_NRB' (ID 5) for the row:
Server: Msg 8955, Level 16, State 1, Line 1
Data row (1:576689:44) identified by (RID = (1:576689:44) 3ID = 3100978) has index values (BusinessID = 30964 and StudentID = 47176 and Abbrevcode = 'FMA' and EndDate = Aug 10 2008 12:00AM and Value = 94.07 ...
There are 11771969 rows in 258268 pages for object 'tbl3'.
CHECKDB found 0 allocation errors and 37 consistency errors in table 'tbl3' (object ID 875150163).
DBCC results for 'tblStudentAddress'.
There are 24901 rows in 72 pages for object 'tblStudentAddress'.
DBCC results for 'tbl7'.
There are 39 rows in 1 pages for object 'tbl7'.
DBCC results for 'tbl8'.
There are 17862 rows in 218 pages for object 'tbl8'.
DBCC results for 'tblBusiness'.
There are 117023 rows in 4304 pages for object 'tblBusiness'.
DBCC results for 'tbl9'.
There are 1685930 rows in 33546 pages for object 'tbl9'.
DBCC results for 'tbla'.
There are 3372456 rows in 56527 pages for object 'tbla'.
DBCC results for 'tblb'.
There are 2131845 rows in 93898 pages for object 'tblb'.
DBCC results for 'tblc'.
There are 11 rows in 1 pages for object 'tblc'.
DBCC results for 'tbld'.
There are 3357 rows in 60 pages for object 'tbld.
DBCC results for 'tble'.
There are 3 rows in 1 pages for object 'tble'.
DBCC results for 'tblf'.
There are 22 rows in 1 pages for object 'tblf'.
DBCC results for 'tblg'.
There are 238 rows in 3 pages for object 'tblg'.
DBCC results for 'tblh'.
There are 280 rows in 2 pages for object 'tblh'.
DBCC results for 'tbli'.
There are 4 rows in 1 pages for object 'tbli'.
DBCC results for 'tblj'.
There are 12 rows in 1 pages for object 'tblj'.
DBCC results for 'tblk'.
There are 4 rows in 1 pages for object 'tblk'.
DBCC results for 'tblBusinessCLOSEDREASON'.
There are 13 rows in 1 pages for object 'tblBusinessCLOSEDREASON'.
DBCC results for 'MSreplication_subscriptions'.
There are 1 rows in 1 pages for object 'MSreplication_subscriptions'.
DBCC results for 'tbll'.
There are 0 rows in 0 pages for object 'tbll'.
DBCC results for 'MSsubscription_agents'.
There are 1 rows in 1 pages for object 'MSsubscription_agents'.
DBCC results for 'tblm'.
There are 7 rows in 1 pages for object 'tblm'.
DBCC results for 'n'.
There are 2 rows in 1 pages for object 'n'.
DBCC results for 'o'.
There are 10 rows in 1 pages for object 'o'.
DBCC results for 'p'.
There are 5 rows in 1 pages for object 'p'.
DBCC results for 'q'.
There are 8 rows in 1 pages for object 'q'.
DBCC results for 'r'.
There are 3610 rows in 33 pages for object 'r'.
DBCC results for 'dtproperties'.
There are 0 rows in 0 pages for object 'dtproperties'.
CHECKDB found 0 allocation errors and 37 consistency errors in database 'abcReports'.
repair_fast is the minimum repair level for the errors found by DBCC CHECKDB (abcReports ).
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
October 19, 2010 at 11:52 am
That looks like the results of running a checkDB with repair allow data loss. Has anything like that been run? Check error logs maybe.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply