Database maintenance plan backup

I've created a database maintenance plan with backup database task which is
set to back up the transaction logs of several specified databases. I open
up the backup database task, then choose <select one or more> from the
Database(s) prompt. When the drop down window opens, I select the radio box
for "these databases", and I check the databases that I want. I save the
database maintenance plan and run it and it works fine. If I open up the
backup database task again, and go to see what databases I have selected,
none are showing as selected. If I save the database maintenance plan and
run it, it fails with the following message, which does not tell me much:
Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5F}
Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
100% complete End Progress DTExec: The package execution returned
DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
1.437 seconds. The package execution failed. The step failed.
This message contrasts with the text file report that shows:
NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
Report was generated on "pdcnt23".
Maintenance Plan: MaintenancePlan
Duration: 00:00:00
Status: Succeeded.
Details:
If I go back into the backup task and reselect the databases and save the
maintenance plan and run it, everything works fine.
This doesn't work as I would expect it to. Is there something I need to do?
Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
Thanks,
PaulPaul,
Losing the database is a known problem. MS is looking into it for a later
build of SQL2005.
Chris
"PT" <PT@.discussions.microsoft.com> wrote in message
news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
> I've created a database maintenance plan with backup database task which
> is
> set to back up the transaction logs of several specified databases. I
> open
> up the backup database task, then choose <select one or more> from the
> Database(s) prompt. When the drop down window opens, I select the radio
> box
> for "these databases", and I check the databases that I want. I save the
> database maintenance plan and run it and it works fine. If I open up the
> backup database task again, and go to see what databases I have selected,
> none are showing as selected. If I save the database maintenance plan and
> run it, it fails with the following message, which does not tell me much:
> Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
> Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
> Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
> 2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5F}
> Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
> 100% complete End Progress DTExec: The package execution returned
> DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
> 1.437 seconds. The package execution failed. The step failed.
> This message contrasts with the text file report that shows:
> NEW COMPONENT OUTPUT
> Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
> Report was generated on "pdcnt23".
> Maintenance Plan: MaintenancePlan
> Duration: 00:00:00
> Status: Succeeded.
> Details:
> If I go back into the backup task and reselect the databases and save the
> maintenance plan and run it, everything works fine.
> This doesn't work as I would expect it to. Is there something I need to
> do?
> Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
> Thanks,
> Paul
>|||Thanks Chris.
I had a look around to try and find information about it. Where would I
find more information about it?
Thanks,
Paul
"Chris Wood" wrote:
> Paul,
> Losing the database is a known problem. MS is looking into it for a later
> build of SQL2005.
> Chris
> "PT" <PT@.discussions.microsoft.com> wrote in message
> news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
> > I've created a database maintenance plan with backup database task which
> > is
> > set to back up the transaction logs of several specified databases. I
> > open
> > up the backup database task, then choose <select one or more> from the
> > Database(s) prompt. When the drop down window opens, I select the radio
> > box
> > for "these databases", and I check the databases that I want. I save the
> > database maintenance plan and run it and it works fine. If I open up the
> > backup database task again, and go to see what databases I have selected,
> > none are showing as selected. If I save the database maintenance plan and
> > run it, it fails with the following message, which does not tell me much:
> >
> > Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server Execute
> > Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft
> > Corp 1984-2005. All rights reserved. Started: 10:58:14 AM Progress:
> > 2007-11-16 10:58:15.67 Source: {0EDA7F25-ED67-4796-9399-668FB2506E5F}
> > Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".:
> > 100% complete End Progress DTExec: The package execution returned
> > DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM Elapsed:
> > 1.437 seconds. The package execution failed. The step failed.
> >
> > This message contrasts with the text file report that shows:
> >
> > NEW COMPONENT OUTPUT
> > Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
> > Report was generated on "pdcnt23".
> > Maintenance Plan: MaintenancePlan
> > Duration: 00:00:00
> > Status: Succeeded.
> > Details:
> >
> > If I go back into the backup task and reselect the databases and save the
> > maintenance plan and run it, everything works fine.
> >
> > This doesn't work as I would expect it to. Is there something I need to
> > do?
> >
> > Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
> >
> > Thanks,
> >
> > Paul
> >
>
>|||Paul,
Signon to Microsoft Connect:- https://connect.microsoft.com/default.aspx and
register for SQL
Chris
"PT" <PT@.discussions.microsoft.com> wrote in message
news:4C86DAAF-11E8-4CA7-B740-A3CF4BF32C69@.microsoft.com...
> Thanks Chris.
> I had a look around to try and find information about it. Where would I
> find more information about it?
> Thanks,
> Paul
> "Chris Wood" wrote:
>> Paul,
>> Losing the database is a known problem. MS is looking into it for a later
>> build of SQL2005.
>> Chris
>> "PT" <PT@.discussions.microsoft.com> wrote in message
>> news:FE4C4861-8C97-46C0-AD6B-754C46BBFEF1@.microsoft.com...
>> > I've created a database maintenance plan with backup database task
>> > which
>> > is
>> > set to back up the transaction logs of several specified databases. I
>> > open
>> > up the backup database task, then choose <select one or more> from the
>> > Database(s) prompt. When the drop down window opens, I select the radio
>> > box
>> > for "these databases", and I check the databases that I want. I save
>> > the
>> > database maintenance plan and run it and it works fine. If I open up
>> > the
>> > backup database task again, and go to see what databases I have
>> > selected,
>> > none are showing as selected. If I save the database maintenance plan
>> > and
>> > run it, it fails with the following message, which does not tell me
>> > much:
>> >
>> > Executed as user: PDCDOMAIN\$SQLAGNTSRV. Microsoft (R) SQL Server
>> > Execute
>> > Package Utility Version 9.00.3042.00 for 32-bit Copyright (C)
>> > Microsoft
>> > Corp 1984-2005. All rights reserved. Started: 10:58:14 AM
>> > Progress:
>> > 2007-11-16 10:58:15.67 Source:
>> > {0EDA7F25-ED67-4796-9399-668FB2506E5F}
>> > Executing query "DECLARE @.Guid UNIQUEIDENTIFIER EXECUTE
>> > msdb..sp".:
>> > 100% complete End Progress DTExec: The package execution returned
>> > DTSER_FAILURE (1). Started: 10:58:14 AM Finished: 10:58:16 AM
>> > Elapsed:
>> > 1.437 seconds. The package execution failed. The step failed.
>> >
>> > This message contrasts with the text file report that shows:
>> >
>> > NEW COMPONENT OUTPUT
>> > Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.3175
>> > Report was generated on "pdcnt23".
>> > Maintenance Plan: MaintenancePlan
>> > Duration: 00:00:00
>> > Status: Succeeded.
>> > Details:
>> >
>> > If I go back into the backup task and reselect the databases and save
>> > the
>> > maintenance plan and run it, everything works fine.
>> >
>> > This doesn't work as I would expect it to. Is there something I need
>> > to
>> > do?
>> >
>> > Currently running SQL Server 2005, SP2 9.00.3054 Standard Edition.
>> >
>> > Thanks,
>> >
>> > Paul
>> >
>>