Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2000 Database random index corruption Expand / Collapse
Author
Message
Posted Thursday, August 5, 2010 10:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 20, 2010 2:42 AM
Points: 3, Visits: 30
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.
Post #964481
Posted Thursday, August 5, 2010 10:54 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 3, 2014 4:00 PM
Points: 2,038, Visits: 1,663
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
Post #964495
Posted Monday, August 9, 2010 7:33 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 20, 2010 2:42 AM
Points: 3, Visits: 30
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?
Post #965946
Posted Monday, August 9, 2010 7:59 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 AM
Points: 42,467, Visits: 35,535
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #965965
Posted Tuesday, October 19, 2010 8:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 20, 2010 2:42 AM
Points: 3, Visits: 30
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.
Post #1006991
Posted Tuesday, October 19, 2010 11:52 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:52 AM
Points: 42,467, Visits: 35,535
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 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1007198
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse