integrity check failed

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tulip - 13 Mar 2008 16:17 GMT

on sql server 2000, try to do integrity check on several database once a week
but failed, what would be main area to look up? thank you

Reply to this Message

Randy Pitkin - 13 Mar 2008 16:48 GMT

Drop and recreate your indexes then update statistics

I have a script somewhere that can automate the process

Do this during low usage times, as it willl greatly affect performance

> on sql server 2000, try to do integrity check on several database once a
> week
> but failed, what would be main area to look up? thank you

Reply to this Message

tulip - 13 Mar 2008 16:54 GMT

no error found on the appliation event viewer and no error found on the sql
server error log. How would i get the script? thank you

> Drop and recreate your indexes then update statistics
>
[quoted text clipped - 5 lines]
> > week
> > but failed, what would be main area to look up? thank you

Reply to this Message

Tibor Karaszi - 13 Mar 2008 17:34 GMT

Read the error messages that the DBCC CHECKDB command produced.

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> on sql server 2000, try to do integrity check on several database once a week
> but failed, what would be main area to look up? thank you

Reply to this Message