SQL Server Performance Forum – Threads Archive

Integrity checking job fails

Hello
I am getting this error:
******************************************************
[215] Database XXXXX: Check Data Linkage…
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8964: [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 2. The text, ntext, or image node at page (1:2415), slot 5, text ID 13514899456 is not referenced.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in table ‘sysindexes’ (object ID 2).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in database ‘XXXXX’.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (XXXXX noindex). The following errors were found: [Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 2. The text, ntext, or image node at page (1:2415), slot 5, text ID 13514899456 is not referenced.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in table ‘sysindexes’ (object ID 2).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 1 consistency errors in database ‘XXXXX’.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (XXXXX noindex). *****************************************
I plan to :
1.Backup database
2.Disconnect users (if any)
3.Bring database into "Single user mode"
4.Run "DBCC CHECKTABLE (‘sysindexes’,repair_allow_data_loss)"
5.Bring database into "Multi user mode" AM i right planning those actions?This is production server…
Thank you in advance

The error is from 1 PC or all PC’s?. If only 1 PC, I suggest to review (desintall/install) ODBC to. Luis

First of all what is the service pack level on SQL & OS, some for these errors were fixed on latest SP pathces. HTH _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

here is patch :no patch and i cannot apply it:
the last week patch was applayed and they had roll it back;
apps stoped working.
i do not think i will be allowed to install in next few weeks
Microsoft SQL Server 2000 – 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c)
1988-2000 Microsoft Corporation Enterprise Edition on Windows NT 5.0
(Build 2195: Service Pack 1

You should apply the Service pack SP3 to SQL and Windows to avoid this situation, this was corrected in SP1 for SQL 2K as specified in this KBA http://support.microsoft.com/default.aspx?scid=kb;EN-US;281287]. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

thank you very much

Actually I have an other question the optimization job of the same Data Maintanence Plan is failing with this message: [258] Database XXXXXX: Index Rebuild (leaving 10% free space)… [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: ‘QUOTED_IDENTIFIER, ARITHABORT’. I found suggested workaround: SET ARITHABORT ON SET QUOTED_IDENTIFIER ON DBCC CHECKDB(database name) but now i start thingking isn’t it the same problem<img src=’/community/emoticons/emotion-4.gif’ alt=’

‘ />atchless sQL BOX?

True for the suggested workaround, but both the issues are different.
As Error 8964 corrected in service packs, and this error 1934 is self-explanatory. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

1.should i run this just once?
i mean:
SET ARITHABORT ON SET QUOTED_IDENTIFIER ON DBCC CHECKDB(database name)
2.is that a problem if i run it in production environment in day time:
i just tried on test: it fast?

1) Yes
2) Make sure to run DBCC checks during less hour traffic, its always better to overcome some issues. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

[thank you

Hi again!
Again about this optimisation job failure
I run this on friday:
SET ARITHABORT ON SET QUOTED_IDENTIFIER ON DBCC CHECKDB(database name) But today after checking how my maintenance plan is doing found the same error. [258] Database db_name: Index Rebuild (leaving 10% free space)…
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: ‘QUOTED_IDENTIFIER, ARITHABORT’. Did I do something wrong?

I’m sure the table has index on computed column and
Perhaps the table has an index on a computed column or an indexed view. And this requires options to set in order to allow during the DBCC process. YOu could use SP_DBOPTION to set certain ANSI settings as stated in books online.
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>