Maint Plans

Hi
SQL Server 2005 sp2
I have a maint plan that was created via the wizzard using separate schedule
fpr each task
sub_plan1 - history clean up; scheduled onec a day at 03:00AM
sub_plan2 - Full backup for all databases; scheduled onec a day at 03:00AM
sub_plan3 - Log backup for specific databases ; scheduled daily every 10
minutes
sub_plan4 - maintenace cleanup; scheduled onec a day at 03:00AM
I face 2 problems:
1. sub_plan2(Full) works only for those databases that are not part of
sub_plan3(Log)
2. sub_plan4 does not work
I will appreciate any help.
Thanks,
Yaniv
Hi
Have you set up the reporting and logging options for the maintenance plan
(next to manage connections) on tool bar. Knowing what the error messages
are! Make sure that your log backups are not running at the same time as the
full backup.
John
"Yan" <yaniv.etrogi@.gmail.com> wrote in message
news:%23yeqwseVIHA.5596@.TK2MSFTNGP05.phx.gbl...
> Hi
> SQL Server 2005 sp2
> I have a maint plan that was created via the wizzard using separate
> schedule fpr each task
> sub_plan1 - history clean up; scheduled onec a day at 03:00AM
> sub_plan2 - Full backup for all databases; scheduled onec a day at 03:00AM
> sub_plan3 - Log backup for specific databases ; scheduled daily every 10
> minutes
> sub_plan4 - maintenace cleanup; scheduled onec a day at 03:00AM
> I face 2 problems:
> 1. sub_plan2(Full) works only for those databases that are not part of
> sub_plan3(Log)
> 2. sub_plan4 does not work
>
> I will appreciate any help.
> Thanks,
> Yaniv
>