SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL 2000 Database random index corruption


SQL 2000 Database random index corruption

Author
Message
david.r.nicholson
david.r.nicholson
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 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.
Paul Randal
Paul Randal
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3767 Visits: 1717
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
david.r.nicholson
david.r.nicholson
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 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?
GilaMonster
GilaMonster
SSC Guru
SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)

Group: General Forum Members
Points: 90569 Visits: 45284
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

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


david.r.nicholson
david.r.nicholson
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 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.
GilaMonster
GilaMonster
SSC Guru
SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)SSC Guru (90K reputation)

Group: General Forum Members
Points: 90569 Visits: 45284
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

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


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search