Maintenace Plan Backup

I created a Maintenance Plan with All Database option. The job Transaction
Log Backup failed because the Master and msdb database is in SIMPLE model.
How can I create a Maintenance Plan with All Database option and run the the
job Transaction Log Backup without fail message?
Thanks in advance.
You can't. Create a separate backup plan for the system DB's and backup the
DB's and not the logs for them. For your app DB's, you create a plan for
them and backup both DB and log.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada tom@.cips.ca
www.pinpub.com
"Eduardo Barcante" <Eduardo Barcante@.discussions.microsoft.com> wrote in
message news:8A52B027-7056-4720-A5FC-1EF404C0FBF9@.microsoft.com...
>I created a Maintenance Plan with All Database option. The job Transaction
> Log Backup failed because the Master and msdb database is in SIMPLE model.
> How can I create a Maintenance Plan with All Database option and run the
> the
> job Transaction Log Backup without fail message?
> Thanks in advance.
|||It means that the All Database option does not work... I will create separate
backups.
Thanks for your help.
"Tom Moreau" wrote:

> You can't. Create a separate backup plan for the system DB's and backup the
> DB's and not the logs for them. For your app DB's, you create a plan for
> them and backup both DB and log.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada tom@.cips.ca
> www.pinpub.com
> "Eduardo Barcante" <Eduardo Barcante@.discussions.microsoft.com> wrote in
> message news:8A52B027-7056-4720-A5FC-1EF404C0FBF9@.microsoft.com...
>
>
|||The All Databases option does work - but only for full backs, not log
backups.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Eduardo Barcante" <EduardoBarcante@.discussions.microsoft.com> wrote in
message news:1C0F22CD-555D-46AD-94EA-B663A503C0F5@.microsoft.com...
It means that the All Database option does not work... I will create
separate
backups.
Thanks for your help.
"Tom Moreau" wrote:

> You can't. Create a separate backup plan for the system DB's and backup
> the
> DB's and not the logs for them. For your app DB's, you create a plan for
> them and backup both DB and log.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada tom@.cips.ca
> www.pinpub.com
> "Eduardo Barcante" <Eduardo Barcante@.discussions.microsoft.com> wrote in
> message news:8A52B027-7056-4720-A5FC-1EF404C0FBF9@.microsoft.com...
>
>