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/info_corrupt_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/info_corrupt_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.
> >
>|||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...
> 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/info_corrupt_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 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...
> > 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/info_corrupt_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.
> >> >
> >>
> >>
>