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|||On May 13, 4:22 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
> "JuanSa" wrote:
> > Hello.
> > I have an issue making transaction logs backups with the Backup Database
> > Task within aMaintenancePlan.
> > (1) When I check the option to backup trn logs of all users databases, =all
> > databases or anyselection, then save the subplan and reopen the task
> > properties and thisselectionis 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 theplanit does seem to "loose"
> the selected databases, also when you re-select the databases the destina=tion
> files are changed back to one per database. You don't need to enter the d=rop
> down list for this to happen, just changing the overwrite/append option s=eems
> to do this. it does not seem to happen with Full backups.
>
> > (2)When I execute theplan, 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 theselectionof databases in this task I don=B4t s=elect
> > 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 theselectionof
> > 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 theplanis created and executing ok, and I create= a
> > new database. Then the next execution fails until I make a TRN Log back=up of
> > the new database manually. After that, nextplanexecution 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 a=dd
> it to the list.
> > Can anybody help me? Is an error in Maintenanced plans with Sp2?
> > By the way, Sql version is SP2.
> > Thenplanhas been created with "newplanoption" -> add "Backup database
> > task"
> > (without wizard)
> I used the addmaintenanceplanoption undermaintenanceplans, but it
> results in the same thing! BI studio also seems to do the same, if you ju=st
> go into theplanand choose the View SQL it comes up with no statements.
> > Thanks, JuanSa.
> You could call PSShttps://support.microsoft.com/oas/default.aspx?&c1=3D50=8&gprid=3D2855&
> 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 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