maintenance plan

What is going on. I setup a maintenance plan for a
database backup. It works fine but the intergrity check
part in the job folder on sql server agent fails. The
backup is fine and the optimizations is fine.
I checked the maintenance plan section of the integrity
part and it shows that I checked the box for doing databse
integrity, include indexes and attempt to repair any minor
problems. The perform these tests before backing up the
database box was not checked.
Interseting when I checked to perform these tests before
backing up and click apply and ok, it clears off again by
itself once I open up the maintenance plan. What is going
on any help will be appreaciated.,
Thanks,
Aboki.Clear the check box for "attempt to repair any minor
problems" under the Integrity tab. Refer to the following
for more info:
BUG: Database Maintenance Plan on System Databases Fails on
Integrity Check if "Attempt to repair minor problems" is
Selected
http://support.microsoft.com/?id=290622
--Sue
On Thu, 7 Aug 2003 09:31:59 -0700, "Aboki"
<waco361@.hotmail.com> wrote:
>What is going on. I setup a maintenance plan for a
>database backup. It works fine but the intergrity check
>part in the job folder on sql server agent fails. The
>backup is fine and the optimizations is fine.
>I checked the maintenance plan section of the integrity
>part and it shows that I checked the box for doing databse
>integrity, include indexes and attempt to repair any minor
>problems. The perform these tests before backing up the
>database box was not checked.
>Interseting when I checked to perform these tests before
>backing up and click apply and ok, it clears off again by
>itself once I open up the maintenance plan. What is going
>on any help will be appreaciated.,
>Thanks,
>Aboki.