Maintenance Assistant SQL 2005 Error 12291

Hello,
SQL Server 2005 EE Trial Version SP2 Win 2003 SP2
I've tried to backup the AdventureWorks database with the help of
Maintenance Assistant, I've created a fairly simple job, straight forward,
no tricks and radio button clicks!
I've started that job and after a while I got an error id: 12291 Error
Package Maintenace Plan 12291 in the event protocol.
The additional text is reporting that the backup of the database
AdventureWorks was ok!
What in the hell went wrong, A Microsoftware error?
Please help
Lanying & ManfredHi
"Lanying & Manfred Chen-Fischer" wrote:

> Hello,
> SQL Server 2005 EE Trial Version SP2 Win 2003 SP2
> I've tried to backup the AdventureWorks database with the help of
> Maintenance Assistant, I've created a fairly simple job, straight forward,
> no tricks and radio button clicks!
> I've started that job and after a while I got an error id: 12291 Error
> Package Maintenace Plan 12291 in the event protocol.
> The additional text is reporting that the backup of the database
> AdventureWorks was ok!
> What in the hell went wrong, A Microsoftware error?
> Please help
> Lanying & Manfred
>
See reply to you other post
http://www.microsoft.com/technet/co...fe
80c2b
John

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
>