Maintenace Plan Backup

17 Dec 2005 1:47 AM

Eduardo Barcante

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.

17 Dec 2005 2:56 AM

Tom Moreau

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 t**@cips.ca
www.pinpub.com

Show quote

"Eduardo Barcante" <Eduardo Barca***@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.

19 Dec 2005 5:16 PM

Eduardo Barcante

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

Thanks for your help.

Show quote

"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 t**@cips.ca
> www.pinpub.com
>
> "Eduardo Barcante" <Eduardo Barca***@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.
>
>
>

25 Dec 2005 4:23 PM

Tom Moreau

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" <EduardoBarca***@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.

Show quote

"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 t**@cips.ca
> www.pinpub.com
>
> "Eduardo Barcante" <Eduardo Barca***@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.
>
>
>