Monday, February 20, 2012

Maintenance Plan: Backup Database Task (Backup Transaction Log opt

Hello.
I have an issue making transaction logs backups with the Backup Database
Task within a Maintenance Plan.
(1) When I check the option to backup trn logs of all users databases, all
databases or any selection, then save the subplan and reopen the task
properties and this selection is lost. That is to say, the option
Databases(to backup) is set again to <Select one or more>
(2)When I execute the plan, it fails with an error saying something like "it
can't make backup of a bd with simple model recovery option" (if there was
one like that in the server).
It's supposed that in the selection of databases in this task I don′t select
any database with that option(in addition, it doesn't let you do that
logically), but I think the reason for the error is that the selection of
databases isn't saved (see 1).
(3) It also fails when the plan is created and executing ok, and I create a
new database. Then the next execution fails until I make a TRN Log backup of
the new database manually. After that, next plan execution runs ok.
The error in this case is: "Failed-1073548784)". I think It could be also
due to (1).
Can anybody help me? Is an error in Maintenanced plans with Sp2?
By the way, Sql version is SP2.
Then plan has been created with "new plan option" -> add "Backup database
task"
(without wizard)
Thanks, JuanSa.
Hi
"JuanSa" wrote:

> Hello.
> I have an issue making transaction logs backups with the Backup Database
> Task within a Maintenance Plan.
> (1) When I check the option to backup trn logs of all users databases, all
> databases or any selection, then save the subplan and reopen the task
> properties and this selection is lost. That is to say, the option
> Databases(to backup) is set again to <Select one or more>
I have run through this and when re-editing the plan it does seem to "loose"
the selected databases, also when you re-select the databases the destination
files are changed back to one per database. You don't need to enter the drop
down list for this to happen, just changing the overwrite/append option seems
to do this. it does not seem to happen with Full backups.

> (2)When I execute the plan, it fails with an error saying something like "it
> can't make backup of a bd with simple model recovery option" (if there was
> one like that in the server).
> It's supposed that in the selection of databases in this task I don′t select
> any database with that option(in addition, it doesn't let you do that
> logically), but I think the reason for the error is that the selection of
> databases isn't saved (see 1).
Simple recovery mode databases are not listed in the selectable database
when you choose transaction logs. They should be ignored for the other
options as well!

> (3) It also fails when the plan is created and executing ok, and I create a
> new database. Then the next execution fails until I make a TRN Log backup of
> the new database manually. After that, next plan execution runs ok.
> The error in this case is: "Failed-1073548784)". I think It could be also
> due to (1).
You would expect an error for a transaction log backup if there was not a
full backup previously. This would occur for the all databases/all user
databases option but not the specifically selected databases unless you add
it to the list.

> Can anybody help me? Is an error in Maintenanced plans with Sp2?
> By the way, Sql version is SP2.
> Then plan has been created with "new plan option" -> add "Backup database
> task"
> (without wizard)
>
I used the add maintenance plan option under maintenance plans, but it
results in the same thing! BI studio also seems to do the same, if you just
go into the plan and choose the View SQL it comes up with no statements.

> Thanks, JuanSa.
>
You could call PSS
https://support.microsoft.com/oas/default.aspx?&c1=508&gprid=2855&
or log a fault at https://connect.microsoft.com/SQLServer/feedback (if you
do this post the number)
Alternatively you could use the view SQL option to save the SQL that will be
run and create a job of your own which will do this.
John
|||The FeedbackID is 262295
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=262295
|||On May 13, 4:22 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
> "JuanSa" wrote:
>
> I have run through this and when re-editing theplanit does seem to "loose"
> the selected databases, also when you re-select the databases the destination
> files are changed back to one per database. You don't need to enter the drop
> down list for this to happen, just changing the overwrite/append option seems
> to do this. it does not seem to happen with Full backups.
>
>
> Simple recovery mode databases are not listed in the selectable database
> when you choose transaction logs. They should be ignored for the other
> options as well!
>
>
> You would expect an error for a transaction log backup if there was not a
> full backup previously. This would occur for the all databases/all user
> databases option but not the specifically selected databases unless you add
> it to the list.
>
> I used the addmaintenanceplanoption undermaintenanceplans, but it
> results in the same thing! BI studio also seems to do the same, if you just
> go into theplanand choose the View SQL it comes up with no statements.
>
> You could call PSShttps://support.microsoft.com/oas/default.aspx?&c1=508&gprid=2855&
> or log a fault athttps://connect.microsoft.com/SQLServer/feedback(if you
> do this post the number)
> Alternatively you could use the view SQL option to save the SQL that willbe
> run and create a job of your own which will do this.
> John

No comments:

Post a Comment