Errors during DBCC How do I correct them

I've run a DBCC checkDB against my database and received the following
errors. I'm sure to go about correct them. Can someone give me help. My
errors are below:
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 14191165440 owned by data record
identified by RID = (1:124:6) id = 646293362 and indid = 2.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 14191230976 owned by data record
identified by RID = (1:124:7) id = 646293362 and indid = 3.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 14191296512 owned by data record
identified by RID = (1:124:8) id = 646293362 and indid = 4.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 14191362048 owned by data record
identified by RID = (1:124:9) id = 646293362 and indid = 5.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 14191427584 owned by data record
identified by RID = (1:124:10) id = 646293362 and indid = 6.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 14191493120 owned by data record
identified by RID = (1:124:11) id = 646293362 and indid = 7.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 14433976320 owned by data record
identified by RID = (1:148112:16) id = 1908201848 and indid = 10.
Server: Msg 8961, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page
(1:3703084), slot 3, text ID 14433976320 does not match its reference from
page (1:124), slot 6.
Server: Msg 8974, Level 16, State 1, Line 1
Text node referenced by more than one node. Object ID 2, text, ntext, or
image node page (1:3703084), slot 3, text ID 14433976320 is pointed to by
page (1:124), slot 6 and by page (1:3703084), slot 4.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page
(1:3703084), slot 5, text ID 14191230976 is referenced by page (1:124), slot
7, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page
(1:3703084), slot 6, text ID 14191296512 is referenced by page (1:124), slot
8, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page
(1:3703084), slot 7, text ID 14191362048 is referenced by page (1:124), slot
9, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page
(1:3703084), slot 8, text ID 14191427584 is referenced by page (1:124), slot
10, but was not seen in the scan.
Server: Msg 8965, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page
(1:3703084), slot 9, text ID 14191493120 is referenced by page (1:124), slot
11, but was not seen in the scan.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page
(1:4559824), slot 0, text ID 14190772224 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page
(1:4559826), slot 1, text ID 14191427584 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page
(1:4559829), slot 0, text ID 14191296512 is not referenced.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page
(1:4559829), slot 1, text ID 14191362048 is not referenced.
DBCC results for 'Claims'.
ThanksDear,
Check he tables id and run dbcc showcontig on that paticulat table to
get the full information about the error.
U can repair the database but before u run repair check it witl dbcc
showcontig.
Also run dbcc checktable --checks intregity of a specified constraint.
Run DBCC Checkalloc --checks the consistancy of disk space allocation
structures for particular database.
U can also resolve this problem by reindexing the tables.
or rum DBCC CHECKDB(Repair_fast,repair_rebuild,repair_allow_data_loss)
before u run this command change the database mode to single user.
from
Doller|||Search in Books Online for the error numbers returned. There are specific recommendations in Books
Online for each error. Also see: http://www.karaszi.com/SQLServer/info_corrupt_suspect_db.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Larry Bird" <LarryBird@.discussions.microsoft.com> wrote in message
news:51E5391F-4354-4E01-B77B-3D1AED2CBC7E@.microsoft.com...
> I've run a DBCC checkDB against my database and received the following
> errors. I'm sure to go about correct them. Can someone give me help. My
> errors are below:
> Server: Msg 8929, Level 16, State 1, Line 1
> Object ID 2: Errors found in text ID 14191165440 owned by data record
> identified by RID = (1:124:6) id = 646293362 and indid = 2.
> Server: Msg 8929, Level 16, State 1, Line 1
> Object ID 2: Errors found in text ID 14191230976 owned by data record
> identified by RID = (1:124:7) id = 646293362 and indid = 3.
> Server: Msg 8929, Level 16, State 1, Line 1
> Object ID 2: Errors found in text ID 14191296512 owned by data record
> identified by RID = (1:124:8) id = 646293362 and indid = 4.
> Server: Msg 8929, Level 16, State 1, Line 1
> Object ID 2: Errors found in text ID 14191362048 owned by data record
> identified by RID = (1:124:9) id = 646293362 and indid = 5.
> Server: Msg 8929, Level 16, State 1, Line 1
> Object ID 2: Errors found in text ID 14191427584 owned by data record
> identified by RID = (1:124:10) id = 646293362 and indid = 6.
> Server: Msg 8929, Level 16, State 1, Line 1
> Object ID 2: Errors found in text ID 14191493120 owned by data record
> identified by RID = (1:124:11) id = 646293362 and indid = 7.
> Server: Msg 8929, Level 16, State 1, Line 1
> Object ID 2: Errors found in text ID 14433976320 owned by data record
> identified by RID = (1:148112:16) id = 1908201848 and indid = 10.
> Server: Msg 8961, Level 16, State 1, Line 1
> Table error: Object ID 2. The text, ntext, or image node at page
> (1:3703084), slot 3, text ID 14433976320 does not match its reference from
> page (1:124), slot 6.
> Server: Msg 8974, Level 16, State 1, Line 1
> Text node referenced by more than one node. Object ID 2, text, ntext, or
> image node page (1:3703084), slot 3, text ID 14433976320 is pointed to by
> page (1:124), slot 6 and by page (1:3703084), slot 4.
> Server: Msg 8965, Level 16, State 1, Line 1
> Table error: Object ID 2. The text, ntext, or image node at page
> (1:3703084), slot 5, text ID 14191230976 is referenced by page (1:124), slot
> 7, but was not seen in the scan.
> Server: Msg 8965, Level 16, State 1, Line 1
> Table error: Object ID 2. The text, ntext, or image node at page
> (1:3703084), slot 6, text ID 14191296512 is referenced by page (1:124), slot
> 8, but was not seen in the scan.
> Server: Msg 8965, Level 16, State 1, Line 1
> Table error: Object ID 2. The text, ntext, or image node at page
> (1:3703084), slot 7, text ID 14191362048 is referenced by page (1:124), slot
> 9, but was not seen in the scan.
> Server: Msg 8965, Level 16, State 1, Line 1
> Table error: Object ID 2. The text, ntext, or image node at page
> (1:3703084), slot 8, text ID 14191427584 is referenced by page (1:124), slot
> 10, but was not seen in the scan.
> Server: Msg 8965, Level 16, State 1, Line 1
> Table error: Object ID 2. The text, ntext, or image node at page
> (1:3703084), slot 9, text ID 14191493120 is referenced by page (1:124), slot
> 11, but was not seen in the scan.
> Server: Msg 8964, Level 16, State 1, Line 1
> Table error: Object ID 2. The text, ntext, or image node at page
> (1:4559824), slot 0, text ID 14190772224 is not referenced.
> Server: Msg 8964, Level 16, State 1, Line 1
> Table error: Object ID 2. The text, ntext, or image node at page
> (1:4559826), slot 1, text ID 14191427584 is not referenced.
> Server: Msg 8964, Level 16, State 1, Line 1
> Table error: Object ID 2. The text, ntext, or image node at page
> (1:4559829), slot 0, text ID 14191296512 is not referenced.
> Server: Msg 8964, Level 16, State 1, Line 1
> Table error: Object ID 2. The text, ntext, or image node at page
> (1:4559829), slot 1, text ID 14191362048 is not referenced.
> DBCC results for 'Claims'.
>
> Thanks
>