Consistency errors - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Consistency errors

Author

Topic

gator8869
Starting Member

37 Posts

Posted - 2007-11-13 : 12:32:43

over the weekend SQL returned errors on all 3 integrity checks which run each night at 8 pm through the normal maintenance plan. Pretty much the same each night. 2 consistency errors on a particular table. Today I ran a manual DBCC Checkdb on the database and it returned 0 consistency errors.

What should I believe. SQL said 0 were repaired during the maintenance plans, which is normal because it is not set to auto repair.

Thanks for any help,
Jeff

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-11-13 : 15:52:00

Start maintenance job manually to see if it still repots error.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-13 : 15:58:57

If a manual run of DBCC CHECKDB returned 0 errors, then you don't have any consistency/integrity problems. Recreate your job. If that doesn't work, I'd suggest using my isp_DBCC_CHECKDB stored procedure instead of the maintenance plan. You can find this in my blog.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

gator8869
Starting Member

37 Posts

Posted - 2007-11-13 : 22:25:55

BTW this is SQL 2000
Well it threw the errors again tonight during the maintenance plan.. Here is the exact error. On a manual dbcc checkdb it doesn't return any errors.

Thanks again for the responses. I may just recreate the maintenance plan.

[Microsoft][ODBC SQL Server Driver][SQL Server]Object ID 250588081, index ID 255: Page (1:663703) could not be processed. See other errors for details.
[Microsoft][ODBC SQL Server Driver][SQL Server]Table error: Object ID 250588081, index ID 255, page (1:663703). Test (IS_ON (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
[Microsoft][ODBC SQL Server Driver][SQL Server]CHECKDB found 0 allocation errors and 2 consistency errors in table 'FD__PS_PHOTO' (object ID 250588081).
[Microsoft]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources