We are trying to do some automated weekly optimization processes on a SQL
2000 Server and have had some errors returned when we do a DBCC CheckDB.
I've posted those below. We then tried DBCC CHECKDB repair_allow_data_loss
which returns a message that says that it found 9 errors and repaired 0.
Can anyone help me determine what kind of errors these are and how they
might be fixed?
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 231654031360 owned by data record
identified by RID = (1:2026:23) id = 194502355 and indid = 3.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 234646667264 owned by data record
identified by RID = (1:2026:24) id = 194502355 and indid = 4.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 246486007808 owned by data record
identified by RID = (1:2028:23) id = 469576711 and indid = 7.
Server: Msg 8929, Level 16, State 1, Line 1
Object ID 2: Errors found in text ID 246504488960 owned by data record
identified by RID = (1:7431:20) id = 805577908 and indid = 30.
Server: Msg 8961, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:14296),
slot 3, text ID 246486007808 does not match its reference from page
(1:8421), slot 2.
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:14296), slot 3, text ID 246486007808 is pointed to by
page (1:2028), slot 23 and by page (1:8421), slot 2.
Server: Msg 8964, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:14378),
slot 1, text ID 234646863872 is not referenced.
Server: Msg 8961, Level 16, State 1, Line 1
Table error: Object ID 2. The text, ntext, or image node at page (1:22060),
slot 4, text ID 246504488960 does not match its reference from page
(1:2531), slot 5.
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:22060), slot 4, text ID 246504488960 is pointed to by
page (1:2531), slot 5 and by page (1:7431), slot 20.
DBCC results for 'sunrise'.
DBCC results for 'sysobjects'.
There are 24482 rows in 435 pages for object 'sysobjects'.
DBCC results for 'sysindexes'.
There are 2652 rows in 155 pages for object 'sysindexes'.
CHECKDB found 0 allocation errors and 9 consistency errors in table
'sysindexes' (object ID 2).At a guess, if sql server is unable to repair the database (even with data
loss,
if that is acceptable to you), you will need to restore from your latest
backup.
Verify this before taking any action though
"Deborah Bohannon" <dbohannon@.nationalDONOTSENDHEREcareanetwork.com> wrote
in message news:eBh7qp9lDHA.2732@.TK2MSFTNGP11.phx.gbl...
> We are trying to do some automated weekly optimization processes on a SQL
> 2000 Server and have had some errors returned when we do a DBCC CheckDB.
> I've posted those below. We then tried DBCC CHECKDB
repair_allow_data_loss
> which returns a message that says that it found 9 errors and repaired 0.
> Can anyone help me determine what kind of errors these are and how they
> might be fixed?
> Server: Msg 8929, Level 16, State 1, Line 1
> Object ID 2: Errors found in text ID 231654031360 owned by data record
> identified by RID = (1:2026:23) id = 194502355 and indid = 3.
> Server: Msg 8929, Level 16, State 1, Line 1
> Object ID 2: Errors found in text ID 234646667264 owned by data record
> identified by RID = (1:2026:24) id = 194502355 and indid = 4.
> Server: Msg 8929, Level 16, State 1, Line 1
> Object ID 2: Errors found in text ID 246486007808 owned by data record
> identified by RID = (1:2028:23) id = 469576711 and indid = 7.
> Server: Msg 8929, Level 16, State 1, Line 1
> Object ID 2: Errors found in text ID 246504488960 owned by data record
> identified by RID = (1:7431:20) id = 805577908 and indid = 30.
> Server: Msg 8961, Level 16, State 1, Line 1
> Table error: Object ID 2. The text, ntext, or image node at page
(1:14296),
> slot 3, text ID 246486007808 does not match its reference from page
> (1:8421), slot 2.
> 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:14296), slot 3, text ID 246486007808 is pointed to by
> page (1:2028), slot 23 and by page (1:8421), slot 2.
> Server: Msg 8964, Level 16, State 1, Line 1
> Table error: Object ID 2. The text, ntext, or image node at page
(1:14378),
> slot 1, text ID 234646863872 is not referenced.
> Server: Msg 8961, Level 16, State 1, Line 1
> Table error: Object ID 2. The text, ntext, or image node at page
(1:22060),
> slot 4, text ID 246504488960 does not match its reference from page
> (1:2531), slot 5.
> 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:22060), slot 4, text ID 246504488960 is pointed to by
> page (1:2531), slot 5 and by page (1:7431), slot 20.
> DBCC results for 'sunrise'.
> DBCC results for 'sysobjects'.
> There are 24482 rows in 435 pages for object 'sysobjects'.
> DBCC results for 'sysindexes'.
> There are 2652 rows in 155 pages for object 'sysindexes'.
> CHECKDB found 0 allocation errors and 9 consistency errors in table
> 'sysindexes' (object ID 2).
>|||The latest backup was made after these messages were created. Wouldn't
these errors still exist after restoring?
"Stressed" <k@.c.co.uk> wrote in message
news:Odykkb%23lDHA.988@.TK2MSFTNGP10.phx.gbl...
> At a guess, if sql server is unable to repair the database (even with data
> loss,
> if that is acceptable to you), you will need to restore from your latest
> backup.
> Verify this before taking any action though
>
> "Deborah Bohannon" <dbohannon@.nationalDONOTSENDHEREcareanetwork.com> wrote
> in message news:eBh7qp9lDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > We are trying to do some automated weekly optimization processes on a
SQL
> > 2000 Server and have had some errors returned when we do a DBCC CheckDB.
> > I've posted those below. We then tried DBCC CHECKDB
> repair_allow_data_loss
> > which returns a message that says that it found 9 errors and repaired 0.
> >
> > Can anyone help me determine what kind of errors these are and how they
> > might be fixed?
> >
> > Server: Msg 8929, Level 16, State 1, Line 1
> >
> > Object ID 2: Errors found in text ID 231654031360 owned by data record
> > identified by RID = (1:2026:23) id = 194502355 and indid = 3.
> >
> > Server: Msg 8929, Level 16, State 1, Line 1
> >
> > Object ID 2: Errors found in text ID 234646667264 owned by data record
> > identified by RID = (1:2026:24) id = 194502355 and indid = 4.
> >
> > Server: Msg 8929, Level 16, State 1, Line 1
> >
> > Object ID 2: Errors found in text ID 246486007808 owned by data record
> > identified by RID = (1:2028:23) id = 469576711 and indid = 7.
> >
> > Server: Msg 8929, Level 16, State 1, Line 1
> >
> > Object ID 2: Errors found in text ID 246504488960 owned by data record
> > identified by RID = (1:7431:20) id = 805577908 and indid = 30.
> >
> > Server: Msg 8961, Level 16, State 1, Line 1
> >
> > Table error: Object ID 2. The text, ntext, or image node at page
> (1:14296),
> > slot 3, text ID 246486007808 does not match its reference from page
> > (1:8421), slot 2.
> >
> > 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:14296), slot 3, text ID 246486007808 is pointed to by
> > page (1:2028), slot 23 and by page (1:8421), slot 2.
> >
> > Server: Msg 8964, Level 16, State 1, Line 1
> >
> > Table error: Object ID 2. The text, ntext, or image node at page
> (1:14378),
> > slot 1, text ID 234646863872 is not referenced.
> >
> > Server: Msg 8961, Level 16, State 1, Line 1
> >
> > Table error: Object ID 2. The text, ntext, or image node at page
> (1:22060),
> > slot 4, text ID 246504488960 does not match its reference from page
> > (1:2531), slot 5.
> >
> > 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:22060), slot 4, text ID 246504488960 is pointed to by
> > page (1:2531), slot 5 and by page (1:7431), slot 20.
> >
> > DBCC results for 'sunrise'.
> >
> > DBCC results for 'sysobjects'.
> >
> > There are 24482 rows in 435 pages for object 'sysobjects'.
> >
> > DBCC results for 'sysindexes'.
> >
> > There are 2652 rows in 155 pages for object 'sysindexes'.
> >
> > CHECKDB found 0 allocation errors and 9 consistency errors in table
> > 'sysindexes' (object ID 2).
> >
> >
>|||This database has over 900 tables. Is there any way to know which table's
indexes are the problem? Or to rebuild all of the indexes in the database?
"harvinder" <hs@.metratech.com> wrote in message
news:0c6301c397eb$fcfeeda0$a501280a@.phx.gbl...
> most of the appear to belong to index...so better way
> will be to recreate the corrupted indexes and run dbcc
> checkdb again
> Thanks
> --Harvinder
> >--Original Message--
> >We are trying to do some automated weekly optimization
> processes on a SQL
> >2000 Server and have had some errors returned when we do
> a DBCC CheckDB.
> >I've posted those below. We then tried DBCC CHECKDB
> repair_allow_data_loss
> >which returns a message that says that it found 9 errors
> and repaired 0.
> >
> >Can anyone help me determine what kind of errors these
> are and how they
> >might be fixed?
> >
> >Server: Msg 8929, Level 16, State 1, Line 1
> >
> >Object ID 2: Errors found in text ID 231654031360 owned
> by data record
> >identified by RID = (1:2026:23) id = 194502355 and indid
> = 3.
> >
> >Server: Msg 8929, Level 16, State 1, Line 1
> >
> >Object ID 2: Errors found in text ID 234646667264 owned
> by data record
> >identified by RID = (1:2026:24) id = 194502355 and indid
> = 4.
> >
> >Server: Msg 8929, Level 16, State 1, Line 1
> >
> >Object ID 2: Errors found in text ID 246486007808 owned
> by data record
> >identified by RID = (1:2028:23) id = 469576711 and indid
> = 7.
> >
> >Server: Msg 8929, Level 16, State 1, Line 1
> >
> >Object ID 2: Errors found in text ID 246504488960 owned
> by data record
> >identified by RID = (1:7431:20) id = 805577908 and indid
> = 30.
> >
> >Server: Msg 8961, Level 16, State 1, Line 1
> >
> >Table error: Object ID 2. The text, ntext, or image node
> at page (1:14296),
> >slot 3, text ID 246486007808 does not match its reference
> from page
> >(1:8421), slot 2.
> >
> >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:14296), slot 3, text ID 246486007808
> is pointed to by
> >page (1:2028), slot 23 and by page (1:8421), slot 2.
> >
> >Server: Msg 8964, Level 16, State 1, Line 1
> >
> >Table error: Object ID 2. The text, ntext, or image node
> at page (1:14378),
> >slot 1, text ID 234646863872 is not referenced.
> >
> >Server: Msg 8961, Level 16, State 1, Line 1
> >
> >Table error: Object ID 2. The text, ntext, or image node
> at page (1:22060),
> >slot 4, text ID 246504488960 does not match its reference
> from page
> >(1:2531), slot 5.
> >
> >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:22060), slot 4, text ID 246504488960
> is pointed to by
> >page (1:2531), slot 5 and by page (1:7431), slot 20.
> >
> >DBCC results for 'sunrise'.
> >
> >DBCC results for 'sysobjects'.
> >
> >There are 24482 rows in 435 pages for object 'sysobjects'.
> >
> >DBCC results for 'sysindexes'.
> >
> >There are 2652 rows in 155 pages for object 'sysindexes'.
> >
> >CHECKDB found 0 allocation errors and 9 consistency
> errors in table
> >'sysindexes' (object ID 2).
> >
> >
> >.
> >|||To find the index name use the following query in you database.
select name from dbo.sysindexes
where id = 194502355 and indid = 3
The example above will find the index in the first error.
HTH
--
Barry McAuslin
Look inside your SQL Server files with SQL File Explorer.
Go to http://www.sqlfe.com for more information.
"Deborah Bohannon" <dbohannon@.nationalDONOTSENDHEREcareanetwork.com> wrote
in message news:uRhM7g$lDHA.2000@.TK2MSFTNGP12.phx.gbl...
> This database has over 900 tables. Is there any way to know which table's
> indexes are the problem? Or to rebuild all of the indexes in the
database?
>
> "harvinder" <hs@.metratech.com> wrote in message
> news:0c6301c397eb$fcfeeda0$a501280a@.phx.gbl...
> > most of the appear to belong to index...so better way
> > will be to recreate the corrupted indexes and run dbcc
> > checkdb again
> >
> > Thanks
> > --Harvinder
> >
> > >--Original Message--
> > >We are trying to do some automated weekly optimization
> > processes on a SQL
> > >2000 Server and have had some errors returned when we do
> > a DBCC CheckDB.
> > >I've posted those below. We then tried DBCC CHECKDB
> > repair_allow_data_loss
> > >which returns a message that says that it found 9 errors
> > and repaired 0.
> > >
> > >Can anyone help me determine what kind of errors these
> > are and how they
> > >might be fixed?
> > >
> > >Server: Msg 8929, Level 16, State 1, Line 1
> > >
> > >Object ID 2: Errors found in text ID 231654031360 owned
> > by data record
> > >identified by RID = (1:2026:23) id = 194502355 and indid
> > = 3.
> > >
> > >Server: Msg 8929, Level 16, State 1, Line 1
> > >
> > >Object ID 2: Errors found in text ID 234646667264 owned
> > by data record
> > >identified by RID = (1:2026:24) id = 194502355 and indid
> > = 4.
> > >
> > >Server: Msg 8929, Level 16, State 1, Line 1
> > >
> > >Object ID 2: Errors found in text ID 246486007808 owned
> > by data record
> > >identified by RID = (1:2028:23) id = 469576711 and indid
> > = 7.
> > >
> > >Server: Msg 8929, Level 16, State 1, Line 1
> > >
> > >Object ID 2: Errors found in text ID 246504488960 owned
> > by data record
> > >identified by RID = (1:7431:20) id = 805577908 and indid
> > = 30.
> > >
> > >Server: Msg 8961, Level 16, State 1, Line 1
> > >
> > >Table error: Object ID 2. The text, ntext, or image node
> > at page (1:14296),
> > >slot 3, text ID 246486007808 does not match its reference
> > from page
> > >(1:8421), slot 2.
> > >
> > >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:14296), slot 3, text ID 246486007808
> > is pointed to by
> > >page (1:2028), slot 23 and by page (1:8421), slot 2.
> > >
> > >Server: Msg 8964, Level 16, State 1, Line 1
> > >
> > >Table error: Object ID 2. The text, ntext, or image node
> > at page (1:14378),
> > >slot 1, text ID 234646863872 is not referenced.
> > >
> > >Server: Msg 8961, Level 16, State 1, Line 1
> > >
> > >Table error: Object ID 2. The text, ntext, or image node
> > at page (1:22060),
> > >slot 4, text ID 246504488960 does not match its reference
> > from page
> > >(1:2531), slot 5.
> > >
> > >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:22060), slot 4, text ID 246504488960
> > is pointed to by
> > >page (1:2531), slot 5 and by page (1:7431), slot 20.
> > >
> > >DBCC results for 'sunrise'.
> > >
> > >DBCC results for 'sysobjects'.
> > >
> > >There are 24482 rows in 435 pages for object 'sysobjects'.
> > >
> > >DBCC results for 'sysindexes'.
> > >
> > >There are 2652 rows in 155 pages for object 'sysindexes'.
> > >
> > >CHECKDB found 0 allocation errors and 9 consistency
> > errors in table
> > >'sysindexes' (object ID 2).
> > >
> > >
> > >.
> > >
>|||Thank you very much. Can you tell me what this means? I have never seen
errors like this on a table.
Table error: Object ID 2. The text, ntext, or image node at page (1:22060),
slot 4, text ID 246504488960 does not match its reference from page
(1:2531), slot 5.
"Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
news:eipens$lDHA.1676@.TK2MSFTNGP09.phx.gbl...
> To find the index name use the following query in you database.
> select name from dbo.sysindexes
> where id = 194502355 and indid = 3
> The example above will find the index in the first error.
> HTH
> --
> Barry McAuslin
> Look inside your SQL Server files with SQL File Explorer.
> Go to http://www.sqlfe.com for more information.
> "Deborah Bohannon" <dbohannon@.nationalDONOTSENDHEREcareanetwork.com> wrote
> in message news:uRhM7g$lDHA.2000@.TK2MSFTNGP12.phx.gbl...
> > This database has over 900 tables. Is there any way to know which
table's
> > indexes are the problem? Or to rebuild all of the indexes in the
> database?
> >
> >
> > "harvinder" <hs@.metratech.com> wrote in message
> > news:0c6301c397eb$fcfeeda0$a501280a@.phx.gbl...
> > > most of the appear to belong to index...so better way
> > > will be to recreate the corrupted indexes and run dbcc
> > > checkdb again
> > >
> > > Thanks
> > > --Harvinder
> > >
> > > >--Original Message--
> > > >We are trying to do some automated weekly optimization
> > > processes on a SQL
> > > >2000 Server and have had some errors returned when we do
> > > a DBCC CheckDB.
> > > >I've posted those below. We then tried DBCC CHECKDB
> > > repair_allow_data_loss
> > > >which returns a message that says that it found 9 errors
> > > and repaired 0.
> > > >
> > > >Can anyone help me determine what kind of errors these
> > > are and how they
> > > >might be fixed?
> > > >
> > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > >
> > > >Object ID 2: Errors found in text ID 231654031360 owned
> > > by data record
> > > >identified by RID = (1:2026:23) id = 194502355 and indid
> > > = 3.
> > > >
> > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > >
> > > >Object ID 2: Errors found in text ID 234646667264 owned
> > > by data record
> > > >identified by RID = (1:2026:24) id = 194502355 and indid
> > > = 4.
> > > >
> > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > >
> > > >Object ID 2: Errors found in text ID 246486007808 owned
> > > by data record
> > > >identified by RID = (1:2028:23) id = 469576711 and indid
> > > = 7.
> > > >
> > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > >
> > > >Object ID 2: Errors found in text ID 246504488960 owned
> > > by data record
> > > >identified by RID = (1:7431:20) id = 805577908 and indid
> > > = 30.
> > > >
> > > >Server: Msg 8961, Level 16, State 1, Line 1
> > > >
> > > >Table error: Object ID 2. The text, ntext, or image node
> > > at page (1:14296),
> > > >slot 3, text ID 246486007808 does not match its reference
> > > from page
> > > >(1:8421), slot 2.
> > > >
> > > >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:14296), slot 3, text ID 246486007808
> > > is pointed to by
> > > >page (1:2028), slot 23 and by page (1:8421), slot 2.
> > > >
> > > >Server: Msg 8964, Level 16, State 1, Line 1
> > > >
> > > >Table error: Object ID 2. The text, ntext, or image node
> > > at page (1:14378),
> > > >slot 1, text ID 234646863872 is not referenced.
> > > >
> > > >Server: Msg 8961, Level 16, State 1, Line 1
> > > >
> > > >Table error: Object ID 2. The text, ntext, or image node
> > > at page (1:22060),
> > > >slot 4, text ID 246504488960 does not match its reference
> > > from page
> > > >(1:2531), slot 5.
> > > >
> > > >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:22060), slot 4, text ID 246504488960
> > > is pointed to by
> > > >page (1:2531), slot 5 and by page (1:7431), slot 20.
> > > >
> > > >DBCC results for 'sunrise'.
> > > >
> > > >DBCC results for 'sysobjects'.
> > > >
> > > >There are 24482 rows in 435 pages for object 'sysobjects'.
> > > >
> > > >DBCC results for 'sysindexes'.
> > > >
> > > >There are 2652 rows in 155 pages for object 'sysindexes'.
> > > >
> > > >CHECKDB found 0 allocation errors and 9 consistency
> > > errors in table
> > > >'sysindexes' (object ID 2).
> > > >
> > > >
> > > >.
> > > >
> >
> >
>|||Basically you have some kind of database corruption.
A table with an image column in it (sysindexes in this case) which has a
reference to an image blob (in this case the column statblob, which is for
index statistics). The location it is pointing to is owned by another
object.
I would first try
DBCC CHECKDB ( 'database_name' REPAIR_ALLOW_DATA_LOSS )
I would not worry about the data loss as all you problems a with the
statblob column in the sysindexs table. This data can be recreated by the
DB maintenance wizard.
Then run the DB maintenance plan for updating your statistics and see what
happens.
If this does not fix the problem then I guess your only solution is to
create a new database, script all objects, and copy all data.
Hope this helps
--
Barry McAuslin
Look inside your SQL Server files with SQL File Explorer.
Go to http://www.sqlfe.com for more information.
"Deborah Bohannon" <dbohannon@.nationalDONOTSENDHEREcareanetwork.com> wrote
in message news:OuDI3WAmDHA.2732@.TK2MSFTNGP11.phx.gbl...
> Thank you very much. Can you tell me what this means? I have never seen
> errors like this on a table.
> Table error: Object ID 2. The text, ntext, or image node at page
(1:22060),
> slot 4, text ID 246504488960 does not match its reference from page
> (1:2531), slot 5.
> "Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
> news:eipens$lDHA.1676@.TK2MSFTNGP09.phx.gbl...
> > To find the index name use the following query in you database.
> >
> > select name from dbo.sysindexes
> > where id = 194502355 and indid = 3
> >
> > The example above will find the index in the first error.
> >
> > HTH
> >
> > --
> >
> > Barry McAuslin
> >
> > Look inside your SQL Server files with SQL File Explorer.
> > Go to http://www.sqlfe.com for more information.
> >
> > "Deborah Bohannon" <dbohannon@.nationalDONOTSENDHEREcareanetwork.com>
wrote
> > in message news:uRhM7g$lDHA.2000@.TK2MSFTNGP12.phx.gbl...
> > > This database has over 900 tables. Is there any way to know which
> table's
> > > indexes are the problem? Or to rebuild all of the indexes in the
> > database?
> > >
> > >
> > > "harvinder" <hs@.metratech.com> wrote in message
> > > news:0c6301c397eb$fcfeeda0$a501280a@.phx.gbl...
> > > > most of the appear to belong to index...so better way
> > > > will be to recreate the corrupted indexes and run dbcc
> > > > checkdb again
> > > >
> > > > Thanks
> > > > --Harvinder
> > > >
> > > > >--Original Message--
> > > > >We are trying to do some automated weekly optimization
> > > > processes on a SQL
> > > > >2000 Server and have had some errors returned when we do
> > > > a DBCC CheckDB.
> > > > >I've posted those below. We then tried DBCC CHECKDB
> > > > repair_allow_data_loss
> > > > >which returns a message that says that it found 9 errors
> > > > and repaired 0.
> > > > >
> > > > >Can anyone help me determine what kind of errors these
> > > > are and how they
> > > > >might be fixed?
> > > > >
> > > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > > >
> > > > >Object ID 2: Errors found in text ID 231654031360 owned
> > > > by data record
> > > > >identified by RID = (1:2026:23) id = 194502355 and indid
> > > > = 3.
> > > > >
> > > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > > >
> > > > >Object ID 2: Errors found in text ID 234646667264 owned
> > > > by data record
> > > > >identified by RID = (1:2026:24) id = 194502355 and indid
> > > > = 4.
> > > > >
> > > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > > >
> > > > >Object ID 2: Errors found in text ID 246486007808 owned
> > > > by data record
> > > > >identified by RID = (1:2028:23) id = 469576711 and indid
> > > > = 7.
> > > > >
> > > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > > >
> > > > >Object ID 2: Errors found in text ID 246504488960 owned
> > > > by data record
> > > > >identified by RID = (1:7431:20) id = 805577908 and indid
> > > > = 30.
> > > > >
> > > > >Server: Msg 8961, Level 16, State 1, Line 1
> > > > >
> > > > >Table error: Object ID 2. The text, ntext, or image node
> > > > at page (1:14296),
> > > > >slot 3, text ID 246486007808 does not match its reference
> > > > from page
> > > > >(1:8421), slot 2.
> > > > >
> > > > >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:14296), slot 3, text ID 246486007808
> > > > is pointed to by
> > > > >page (1:2028), slot 23 and by page (1:8421), slot 2.
> > > > >
> > > > >Server: Msg 8964, Level 16, State 1, Line 1
> > > > >
> > > > >Table error: Object ID 2. The text, ntext, or image node
> > > > at page (1:14378),
> > > > >slot 1, text ID 234646863872 is not referenced.
> > > > >
> > > > >Server: Msg 8961, Level 16, State 1, Line 1
> > > > >
> > > > >Table error: Object ID 2. The text, ntext, or image node
> > > > at page (1:22060),
> > > > >slot 4, text ID 246504488960 does not match its reference
> > > > from page
> > > > >(1:2531), slot 5.
> > > > >
> > > > >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:22060), slot 4, text ID 246504488960
> > > > is pointed to by
> > > > >page (1:2531), slot 5 and by page (1:7431), slot 20.
> > > > >
> > > > >DBCC results for 'sunrise'.
> > > > >
> > > > >DBCC results for 'sysobjects'.
> > > > >
> > > > >There are 24482 rows in 435 pages for object 'sysobjects'.
> > > > >
> > > > >DBCC results for 'sysindexes'.
> > > > >
> > > > >There are 2652 rows in 155 pages for object 'sysindexes'.
> > > > >
> > > > >CHECKDB found 0 allocation errors and 9 consistency
> > > > errors in table
> > > > >'sysindexes' (object ID 2).
> > > > >
> > > > >
> > > > >.
> > > > >
> > >
> > >
> >
> >
>|||Yes.
--
Barry McAuslin
Look inside your SQL Server files with SQL File Explorer.
Go to http://www.sqlfe.com for more information.
"Deborah Bohannon" <dbohannon@.nationalDONOTSENDHEREcareanetwork.com> wrote
in message news:uZHO3k%23lDHA.744@.tk2msftngp13.phx.gbl...
> The latest backup was made after these messages were created. Wouldn't
> these errors still exist after restoring?
>
> "Stressed" <k@.c.co.uk> wrote in message
> news:Odykkb%23lDHA.988@.TK2MSFTNGP10.phx.gbl...
> > At a guess, if sql server is unable to repair the database (even with
data
> > loss,
> > if that is acceptable to you), you will need to restore from your latest
> > backup.
> >
> > Verify this before taking any action though
> >
> >
> > "Deborah Bohannon" <dbohannon@.nationalDONOTSENDHEREcareanetwork.com>
wrote
> > in message news:eBh7qp9lDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > > We are trying to do some automated weekly optimization processes on a
> SQL
> > > 2000 Server and have had some errors returned when we do a DBCC
CheckDB.
> > > I've posted those below. We then tried DBCC CHECKDB
> > repair_allow_data_loss
> > > which returns a message that says that it found 9 errors and repaired
0.
> > >
> > > Can anyone help me determine what kind of errors these are and how
they
> > > might be fixed?
> > >
> > > Server: Msg 8929, Level 16, State 1, Line 1
> > >
> > > Object ID 2: Errors found in text ID 231654031360 owned by data record
> > > identified by RID = (1:2026:23) id = 194502355 and indid = 3.
> > >
> > > Server: Msg 8929, Level 16, State 1, Line 1
> > >
> > > Object ID 2: Errors found in text ID 234646667264 owned by data record
> > > identified by RID = (1:2026:24) id = 194502355 and indid = 4.
> > >
> > > Server: Msg 8929, Level 16, State 1, Line 1
> > >
> > > Object ID 2: Errors found in text ID 246486007808 owned by data record
> > > identified by RID = (1:2028:23) id = 469576711 and indid = 7.
> > >
> > > Server: Msg 8929, Level 16, State 1, Line 1
> > >
> > > Object ID 2: Errors found in text ID 246504488960 owned by data record
> > > identified by RID = (1:7431:20) id = 805577908 and indid = 30.
> > >
> > > Server: Msg 8961, Level 16, State 1, Line 1
> > >
> > > Table error: Object ID 2. The text, ntext, or image node at page
> > (1:14296),
> > > slot 3, text ID 246486007808 does not match its reference from page
> > > (1:8421), slot 2.
> > >
> > > 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:14296), slot 3, text ID 246486007808 is pointed to
by
> > > page (1:2028), slot 23 and by page (1:8421), slot 2.
> > >
> > > Server: Msg 8964, Level 16, State 1, Line 1
> > >
> > > Table error: Object ID 2. The text, ntext, or image node at page
> > (1:14378),
> > > slot 1, text ID 234646863872 is not referenced.
> > >
> > > Server: Msg 8961, Level 16, State 1, Line 1
> > >
> > > Table error: Object ID 2. The text, ntext, or image node at page
> > (1:22060),
> > > slot 4, text ID 246504488960 does not match its reference from page
> > > (1:2531), slot 5.
> > >
> > > 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:22060), slot 4, text ID 246504488960 is pointed to
by
> > > page (1:2531), slot 5 and by page (1:7431), slot 20.
> > >
> > > DBCC results for 'sunrise'.
> > >
> > > DBCC results for 'sysobjects'.
> > >
> > > There are 24482 rows in 435 pages for object 'sysobjects'.
> > >
> > > DBCC results for 'sysindexes'.
> > >
> > > There are 2652 rows in 155 pages for object 'sysindexes'.
> > >
> > > CHECKDB found 0 allocation errors and 9 consistency errors in table
> > > 'sysindexes' (object ID 2).
> > >
> > >
> >
> >
>|||... so that should be restated as "the latest clean backup". However, you can re-apply your
transaction log backups. The corruption will likely not re-appear when you apply a transaction log
backup taken after the corruption occurred in the original db.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
news:uznbxyFmDHA.2772@.TK2MSFTNGP10.phx.gbl...
> Yes.
> --
> Barry McAuslin
> Look inside your SQL Server files with SQL File Explorer.
> Go to http://www.sqlfe.com for more information.
> "Deborah Bohannon" <dbohannon@.nationalDONOTSENDHEREcareanetwork.com> wrote
> in message news:uZHO3k%23lDHA.744@.tk2msftngp13.phx.gbl...
> > The latest backup was made after these messages were created. Wouldn't
> > these errors still exist after restoring?
> >
> >
> > "Stressed" <k@.c.co.uk> wrote in message
> > news:Odykkb%23lDHA.988@.TK2MSFTNGP10.phx.gbl...
> > > At a guess, if sql server is unable to repair the database (even with
> data
> > > loss,
> > > if that is acceptable to you), you will need to restore from your latest
> > > backup.
> > >
> > > Verify this before taking any action though
> > >
> > >
> > > "Deborah Bohannon" <dbohannon@.nationalDONOTSENDHEREcareanetwork.com>
> wrote
> > > in message news:eBh7qp9lDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > > > We are trying to do some automated weekly optimization processes on a
> > SQL
> > > > 2000 Server and have had some errors returned when we do a DBCC
> CheckDB.
> > > > I've posted those below. We then tried DBCC CHECKDB
> > > repair_allow_data_loss
> > > > which returns a message that says that it found 9 errors and repaired
> 0.
> > > >
> > > > Can anyone help me determine what kind of errors these are and how
> they
> > > > might be fixed?
> > > >
> > > > Server: Msg 8929, Level 16, State 1, Line 1
> > > >
> > > > Object ID 2: Errors found in text ID 231654031360 owned by data record
> > > > identified by RID = (1:2026:23) id = 194502355 and indid = 3.
> > > >
> > > > Server: Msg 8929, Level 16, State 1, Line 1
> > > >
> > > > Object ID 2: Errors found in text ID 234646667264 owned by data record
> > > > identified by RID = (1:2026:24) id = 194502355 and indid = 4.
> > > >
> > > > Server: Msg 8929, Level 16, State 1, Line 1
> > > >
> > > > Object ID 2: Errors found in text ID 246486007808 owned by data record
> > > > identified by RID = (1:2028:23) id = 469576711 and indid = 7.
> > > >
> > > > Server: Msg 8929, Level 16, State 1, Line 1
> > > >
> > > > Object ID 2: Errors found in text ID 246504488960 owned by data record
> > > > identified by RID = (1:7431:20) id = 805577908 and indid = 30.
> > > >
> > > > Server: Msg 8961, Level 16, State 1, Line 1
> > > >
> > > > Table error: Object ID 2. The text, ntext, or image node at page
> > > (1:14296),
> > > > slot 3, text ID 246486007808 does not match its reference from page
> > > > (1:8421), slot 2.
> > > >
> > > > 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:14296), slot 3, text ID 246486007808 is pointed to
> by
> > > > page (1:2028), slot 23 and by page (1:8421), slot 2.
> > > >
> > > > Server: Msg 8964, Level 16, State 1, Line 1
> > > >
> > > > Table error: Object ID 2. The text, ntext, or image node at page
> > > (1:14378),
> > > > slot 1, text ID 234646863872 is not referenced.
> > > >
> > > > Server: Msg 8961, Level 16, State 1, Line 1
> > > >
> > > > Table error: Object ID 2. The text, ntext, or image node at page
> > > (1:22060),
> > > > slot 4, text ID 246504488960 does not match its reference from page
> > > > (1:2531), slot 5.
> > > >
> > > > 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:22060), slot 4, text ID 246504488960 is pointed to
> by
> > > > page (1:2531), slot 5 and by page (1:7431), slot 20.
> > > >
> > > > DBCC results for 'sunrise'.
> > > >
> > > > DBCC results for 'sysobjects'.
> > > >
> > > > There are 24482 rows in 435 pages for object 'sysobjects'.
> > > >
> > > > DBCC results for 'sysindexes'.
> > > >
> > > > There are 2652 rows in 155 pages for object 'sysindexes'.
> > > >
> > > > CHECKDB found 0 allocation errors and 9 consistency errors in table
> > > > 'sysindexes' (object ID 2).
> > > >
> > > >
> > >
> > >
> >
> >
>|||Barry,
The OP stated that allow_data_loss was already tried :-(...
Deborah,
I'd go for the restore route. See my other post regarding restoring transaction log backups.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
news:%23JOayyFmDHA.2772@.TK2MSFTNGP10.phx.gbl...
> Basically you have some kind of database corruption.
> A table with an image column in it (sysindexes in this case) which has a
> reference to an image blob (in this case the column statblob, which is for
> index statistics). The location it is pointing to is owned by another
> object.
> I would first try
> DBCC CHECKDB ( 'database_name' REPAIR_ALLOW_DATA_LOSS )
> I would not worry about the data loss as all you problems a with the
> statblob column in the sysindexs table. This data can be recreated by the
> DB maintenance wizard.
> Then run the DB maintenance plan for updating your statistics and see what
> happens.
> If this does not fix the problem then I guess your only solution is to
> create a new database, script all objects, and copy all data.
> Hope this helps
> --
> Barry McAuslin
> Look inside your SQL Server files with SQL File Explorer.
> Go to http://www.sqlfe.com for more information.
> "Deborah Bohannon" <dbohannon@.nationalDONOTSENDHEREcareanetwork.com> wrote
> in message news:OuDI3WAmDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > Thank you very much. Can you tell me what this means? I have never seen
> > errors like this on a table.
> >
> > Table error: Object ID 2. The text, ntext, or image node at page
> (1:22060),
> > slot 4, text ID 246504488960 does not match its reference from page
> > (1:2531), slot 5.
> >
> > "Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
> > news:eipens$lDHA.1676@.TK2MSFTNGP09.phx.gbl...
> > > To find the index name use the following query in you database.
> > >
> > > select name from dbo.sysindexes
> > > where id = 194502355 and indid = 3
> > >
> > > The example above will find the index in the first error.
> > >
> > > HTH
> > >
> > > --
> > >
> > > Barry McAuslin
> > >
> > > Look inside your SQL Server files with SQL File Explorer.
> > > Go to http://www.sqlfe.com for more information.
> > >
> > > "Deborah Bohannon" <dbohannon@.nationalDONOTSENDHEREcareanetwork.com>
> wrote
> > > in message news:uRhM7g$lDHA.2000@.TK2MSFTNGP12.phx.gbl...
> > > > This database has over 900 tables. Is there any way to know which
> > table's
> > > > indexes are the problem? Or to rebuild all of the indexes in the
> > > database?
> > > >
> > > >
> > > > "harvinder" <hs@.metratech.com> wrote in message
> > > > news:0c6301c397eb$fcfeeda0$a501280a@.phx.gbl...
> > > > > most of the appear to belong to index...so better way
> > > > > will be to recreate the corrupted indexes and run dbcc
> > > > > checkdb again
> > > > >
> > > > > Thanks
> > > > > --Harvinder
> > > > >
> > > > > >--Original Message--
> > > > > >We are trying to do some automated weekly optimization
> > > > > processes on a SQL
> > > > > >2000 Server and have had some errors returned when we do
> > > > > a DBCC CheckDB.
> > > > > >I've posted those below. We then tried DBCC CHECKDB
> > > > > repair_allow_data_loss
> > > > > >which returns a message that says that it found 9 errors
> > > > > and repaired 0.
> > > > > >
> > > > > >Can anyone help me determine what kind of errors these
> > > > > are and how they
> > > > > >might be fixed?
> > > > > >
> > > > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > > > >
> > > > > >Object ID 2: Errors found in text ID 231654031360 owned
> > > > > by data record
> > > > > >identified by RID = (1:2026:23) id = 194502355 and indid
> > > > > = 3.
> > > > > >
> > > > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > > > >
> > > > > >Object ID 2: Errors found in text ID 234646667264 owned
> > > > > by data record
> > > > > >identified by RID = (1:2026:24) id = 194502355 and indid
> > > > > = 4.
> > > > > >
> > > > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > > > >
> > > > > >Object ID 2: Errors found in text ID 246486007808 owned
> > > > > by data record
> > > > > >identified by RID = (1:2028:23) id = 469576711 and indid
> > > > > = 7.
> > > > > >
> > > > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > > > >
> > > > > >Object ID 2: Errors found in text ID 246504488960 owned
> > > > > by data record
> > > > > >identified by RID = (1:7431:20) id = 805577908 and indid
> > > > > = 30.
> > > > > >
> > > > > >Server: Msg 8961, Level 16, State 1, Line 1
> > > > > >
> > > > > >Table error: Object ID 2. The text, ntext, or image node
> > > > > at page (1:14296),
> > > > > >slot 3, text ID 246486007808 does not match its reference
> > > > > from page
> > > > > >(1:8421), slot 2.
> > > > > >
> > > > > >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:14296), slot 3, text ID 246486007808
> > > > > is pointed to by
> > > > > >page (1:2028), slot 23 and by page (1:8421), slot 2.
> > > > > >
> > > > > >Server: Msg 8964, Level 16, State 1, Line 1
> > > > > >
> > > > > >Table error: Object ID 2. The text, ntext, or image node
> > > > > at page (1:14378),
> > > > > >slot 1, text ID 234646863872 is not referenced.
> > > > > >
> > > > > >Server: Msg 8961, Level 16, State 1, Line 1
> > > > > >
> > > > > >Table error: Object ID 2. The text, ntext, or image node
> > > > > at page (1:22060),
> > > > > >slot 4, text ID 246504488960 does not match its reference
> > > > > from page
> > > > > >(1:2531), slot 5.
> > > > > >
> > > > > >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:22060), slot 4, text ID 246504488960
> > > > > is pointed to by
> > > > > >page (1:2531), slot 5 and by page (1:7431), slot 20.
> > > > > >
> > > > > >DBCC results for 'sunrise'.
> > > > > >
> > > > > >DBCC results for 'sysobjects'.
> > > > > >
> > > > > >There are 24482 rows in 435 pages for object 'sysobjects'.
> > > > > >
> > > > > >DBCC results for 'sysindexes'.
> > > > > >
> > > > > >There are 2652 rows in 155 pages for object 'sysindexes'.
> > > > > >
> > > > > >CHECKDB found 0 allocation errors and 9 consistency
> > > > > errors in table
> > > > > >'sysindexes' (object ID 2).
> > > > > >
> > > > > >
> > > > > >.
> > > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Thank you Tibor. I appreciate all the responses.
I've been told that a couple of weeks ago, there was some corruption to the
RAID array and a new one was installed. I believe that some of these
problems began then. I also found out that the version of SQL on the box
was the RTM version, no service packs. (This is not one of my servers; I
provide support as needed to their support people.)
I've passed on the advice given here. They've already tried scripting the
objects in the database for possible data export. However, the script
process runs about 20 minutes and then just hangs without finishing. I
believe that they are going to go with restoring the last known clean backup
and then applying all the transaction logs since then. I will post here
with an update on the results.
Thanks again,
Deborah
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:eZksgTGmDHA.372@.TK2MSFTNGP11.phx.gbl...
> Barry,
> The OP stated that allow_data_loss was already tried :-(...
>
> Deborah,
> I'd go for the restore route. See my other post regarding restoring
transaction log backups.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
> news:%23JOayyFmDHA.2772@.TK2MSFTNGP10.phx.gbl...
> > Basically you have some kind of database corruption.
> >
> > A table with an image column in it (sysindexes in this case) which has a
> > reference to an image blob (in this case the column statblob, which is
for
> > index statistics). The location it is pointing to is owned by another
> > object.
> >
> > I would first try
> >
> > DBCC CHECKDB ( 'database_name' REPAIR_ALLOW_DATA_LOSS )
> >
> > I would not worry about the data loss as all you problems a with the
> > statblob column in the sysindexs table. This data can be recreated by
the
> > DB maintenance wizard.
> >
> > Then run the DB maintenance plan for updating your statistics and see
what
> > happens.
> >
> > If this does not fix the problem then I guess your only solution is to
> > create a new database, script all objects, and copy all data.
> >
> > Hope this helps
> >
> > --
> >
> > Barry McAuslin
> >
> > Look inside your SQL Server files with SQL File Explorer.
> > Go to http://www.sqlfe.com for more information.
> >
> > "Deborah Bohannon" <dbohannon@.nationalDONOTSENDHEREcareanetwork.com>
wrote
> > in message news:OuDI3WAmDHA.2732@.TK2MSFTNGP11.phx.gbl...
> > > Thank you very much. Can you tell me what this means? I have never
seen
> > > errors like this on a table.
> > >
> > > Table error: Object ID 2. The text, ntext, or image node at page
> > (1:22060),
> > > slot 4, text ID 246504488960 does not match its reference from page
> > > (1:2531), slot 5.
> > >
> > > "Barry McAuslin" <barry_mcauslin@.yahoo.com.nospam> wrote in message
> > > news:eipens$lDHA.1676@.TK2MSFTNGP09.phx.gbl...
> > > > To find the index name use the following query in you database.
> > > >
> > > > select name from dbo.sysindexes
> > > > where id = 194502355 and indid = 3
> > > >
> > > > The example above will find the index in the first error.
> > > >
> > > > HTH
> > > >
> > > > --
> > > >
> > > > Barry McAuslin
> > > >
> > > > Look inside your SQL Server files with SQL File Explorer.
> > > > Go to http://www.sqlfe.com for more information.
> > > >
> > > > "Deborah Bohannon" <dbohannon@.nationalDONOTSENDHEREcareanetwork.com>
> > wrote
> > > > in message news:uRhM7g$lDHA.2000@.TK2MSFTNGP12.phx.gbl...
> > > > > This database has over 900 tables. Is there any way to know which
> > > table's
> > > > > indexes are the problem? Or to rebuild all of the indexes in the
> > > > database?
> > > > >
> > > > >
> > > > > "harvinder" <hs@.metratech.com> wrote in message
> > > > > news:0c6301c397eb$fcfeeda0$a501280a@.phx.gbl...
> > > > > > most of the appear to belong to index...so better way
> > > > > > will be to recreate the corrupted indexes and run dbcc
> > > > > > checkdb again
> > > > > >
> > > > > > Thanks
> > > > > > --Harvinder
> > > > > >
> > > > > > >--Original Message--
> > > > > > >We are trying to do some automated weekly optimization
> > > > > > processes on a SQL
> > > > > > >2000 Server and have had some errors returned when we do
> > > > > > a DBCC CheckDB.
> > > > > > >I've posted those below. We then tried DBCC CHECKDB
> > > > > > repair_allow_data_loss
> > > > > > >which returns a message that says that it found 9 errors
> > > > > > and repaired 0.
> > > > > > >
> > > > > > >Can anyone help me determine what kind of errors these
> > > > > > are and how they
> > > > > > >might be fixed?
> > > > > > >
> > > > > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > > > > >
> > > > > > >Object ID 2: Errors found in text ID 231654031360 owned
> > > > > > by data record
> > > > > > >identified by RID = (1:2026:23) id = 194502355 and indid
> > > > > > = 3.
> > > > > > >
> > > > > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > > > > >
> > > > > > >Object ID 2: Errors found in text ID 234646667264 owned
> > > > > > by data record
> > > > > > >identified by RID = (1:2026:24) id = 194502355 and indid
> > > > > > = 4.
> > > > > > >
> > > > > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > > > > >
> > > > > > >Object ID 2: Errors found in text ID 246486007808 owned
> > > > > > by data record
> > > > > > >identified by RID = (1:2028:23) id = 469576711 and indid
> > > > > > = 7.
> > > > > > >
> > > > > > >Server: Msg 8929, Level 16, State 1, Line 1
> > > > > > >
> > > > > > >Object ID 2: Errors found in text ID 246504488960 owned
> > > > > > by data record
> > > > > > >identified by RID = (1:7431:20) id = 805577908 and indid
> > > > > > = 30.
> > > > > > >
> > > > > > >Server: Msg 8961, Level 16, State 1, Line 1
> > > > > > >
> > > > > > >Table error: Object ID 2. The text, ntext, or image node
> > > > > > at page (1:14296),
> > > > > > >slot 3, text ID 246486007808 does not match its reference
> > > > > > from page
> > > > > > >(1:8421), slot 2.
> > > > > > >
> > > > > > >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:14296), slot 3, text ID 246486007808
> > > > > > is pointed to by
> > > > > > >page (1:2028), slot 23 and by page (1:8421), slot 2.
> > > > > > >
> > > > > > >Server: Msg 8964, Level 16, State 1, Line 1
> > > > > > >
> > > > > > >Table error: Object ID 2. The text, ntext, or image node
> > > > > > at page (1:14378),
> > > > > > >slot 1, text ID 234646863872 is not referenced.
> > > > > > >
> > > > > > >Server: Msg 8961, Level 16, State 1, Line 1
> > > > > > >
> > > > > > >Table error: Object ID 2. The text, ntext, or image node
> > > > > > at page (1:22060),
> > > > > > >slot 4, text ID 246504488960 does not match its reference
> > > > > > from page
> > > > > > >(1:2531), slot 5.
> > > > > > >
> > > > > > >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:22060), slot 4, text ID 246504488960
> > > > > > is pointed to by
> > > > > > >page (1:2531), slot 5 and by page (1:7431), slot 20.
> > > > > > >
> > > > > > >DBCC results for 'sunrise'.
> > > > > > >
> > > > > > >DBCC results for 'sysobjects'.
> > > > > > >
> > > > > > >There are 24482 rows in 435 pages for object 'sysobjects'.
> > > > > > >
> > > > > > >DBCC results for 'sysindexes'.
> > > > > > >
> > > > > > >There are 2652 rows in 155 pages for object 'sysindexes'.
> > > > > > >
> > > > > > >CHECKDB found 0 allocation errors and 9 consistency
> > > > > > errors in table
> > > > > > >'sysindexes' (object ID 2).
> > > > > > >
> > > > > > >
> > > > > > >.
> > > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
