Integrity Check Failure

DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
Log backup and Optimizations are successful. I can’t determine if it’s
failing to run or if it’s running
and finding a problem. The logs are not indicating any reasons for failure.
Integrity check is successful on other DB’s. Thanks for being there to help.
1. Define a report file for the plan and check that report file for error messages.
2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
3. http://www.karaszi.com/SQLServer/inf...suspect_db.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
> DB Maintenance Plan for Integrity Check is failing. DB Backup, Transaction
> Log backup and Optimizations are successful. I can’t determine if it’s
> failing to run or if it’s running
> and finding a problem. The logs are not indicating any reasons for failure.
> Integrity check is successful on other DB’s. Thanks for being there to help.
>
|||Thanks Tibor. Can you direct me to a location that indicates the procedure for
defining a report?
"Tibor Karaszi" wrote:

> 1. Define a report file for the plan and check that report file for error messages.
> 2. Run DBCC CHECKDB from query analyzer using the NO_INFOMSGS options.
> 3. http://www.karaszi.com/SQLServer/inf...suspect_db.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:6D6C7BC0-F4E3-496E-9BDD-0BBD8B1882A9@.microsoft.com...
>
|||EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
this option. You can also right-click an existing plan and open (something like) history and try to
find the error messages there. I don't use maint plans, so it is a little bit sketchy...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...[vbcol=seagreen]
> Thanks Tibor. Can you direct me to a location that indicates the procedure for
> defining a report?
> "Tibor Karaszi" wrote:
|||Thanks for your help
"Tibor Karaszi" wrote:

> EM, Management, Maintenance Plans, right-click your plan to open it. The right-most ( think) tab has
> this option. You can also right-click an existing plan and open (something like) history and try to
> find the error messages there. I don't use maint plans, so it is a little bit sketchy...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "coenzyme" <coenzyme@.discussions.microsoft.com> wrote in message
> news:C2AD0678-EF85-4F5B-9D99-B5B219EE9540@.microsoft.com...
>