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 (AT) cips (DOT) ca
www.pinpub.com

"Eduardo Barcante" <Eduardo Barcante (AT) discussions (DOT) microsoft.com> wrote in
message news:8A52B027-7056-4720-A5FC-1EF404C0FBF9 (AT) microsoft (DOT) com...

It means that the All Database option does not work... I will create separate
backups.

Thanks for your help.


"Tom Moreau" wrote:

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 (AT) discussions (DOT) microsoft.com> wrote in
message news:1C0F22CD-555D-46AD-94EA-B663A503C0F5 (AT) microsoft (DOT) com...
It means that the All Database option does not work... I will create
separate
backups.

Thanks for your help.


"Tom Moreau" wrote: