|
Home > Archive > MS SQL Server Tools > December 2005 > Maintenace Plan Backup
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Maintenace Plan Backup
|
|
| Eduardo Barcante 2005-12-16, 8:24 pm |
| 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.
| |
| Tom Moreau 2005-12-17, 3:23 am |
| 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@microso
ft.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.
| |
| Eduardo Barcante 2005-12-19, 11:23 am |
| 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@microso
ft.com...
>
>
>
| |
| Tom Moreau 2005-12-25, 11:23 am |
| 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@disc
ussions.microsoft.com> wrote in
message news:1C0F22CD-555D-46AD-94EA- B663A503C0F5@microso
ft.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@microso
ft.com...
>
>
>
|
|
|
|
|