Tuesday, March 27, 2012

Error 8965

I'm getting this error message ONLY SOMETIMES after a DBCC (I'd feel better
if it showed up on a regular basis). I haven't found much dealing with this
. The table is used to store small videos. Any useful suggestions (somethi
ng more than "restore from
a backup" or "call Microsoft") would be greatly appreciated.
I'm on Windows 2000 SP 4 and SQL 2000 SP 3.
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 8965: [Microsoft]&#
91;ODBC SQL Server Driver][SQL Server]Table error: Object ID %. The text
, ntext, or image node at page (1:8544241), slot 0, text ID 17459904512 is r
eferenced by page (1:8544242), slot 0,
but was not seen in the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Obje
ct ID %. The text, ntext, or image node at page (1:8544243), slot 0, text ID
17459904512 is referenced by page (1:8544242), slot 0, but was not seen in
the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Obje
ct ID %. The text, ntext, or image node at page (1:8544244), slot 0, text ID
17459904512 is referenced by page (1:8544242), slot 0, but was not seen in
the scan.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 a
llocation errors and 3 consistency errors in table 'Table_Name' (object ID %
).
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 a
llocation errors and 3 consistency errors in database 'Database_Name'.
[Microsoft][ODBC SQL Server Driver][SQL Server]repair_allow_data
_loss is the minimum repair level for the errors found by DBCC CHECKDB (Data
base_Name ).The error message is indicating a corruption in the table. The root cause
of the corruption is unknown at this stage and will require more
information.
One explanation as to why the error only appears sometimes and not always
is if you run the dbcc checkdb command with any of the repair options then
it's likely that the corruption is repaired and reappears sometime later
again.
HTH
Agnes Panosian
SQL Server Supportsql

No comments:

Post a Comment