SQL Server 2005 Maintenance Plan Fails Everytime.

2 Mar 2007 6:06 PM

Warren

Hi,

I've installed SQL Server 2005 Enterprise Edition w/ SP1. I setup a
maintenance plan using the wizard to backup the databases. If I run the plan
manually it runs fine. I scheduled the plan to run each night..

Problem: 1) The jobs fail each night with this error: The command line
parameters are invalid. The step failed. Haven't a clue what it means sense
this was setup using the wizard.

Problem2: Where do I set the job to delete the previous nights backup?

Thanks,

Warren

3 Mar 2007 5:25 AM

Steve

On Mar 2, 10:06 am, Warren <War***@discussions.microsoft.com> wrote:
Show quote

> Hi,
>
> I've installed SQL Server 2005 Enterprise Edition w/ SP1. I setup a
> maintenance plan using the wizard to backup the databases. If I run the plan
> manually it runs fine. I scheduled the plan to run each night..
>
> Problem: 1) The jobs fail each night with this error: The command line
> parameters are invalid. The step failed. Haven't a clue what it means sense
> this was setup using the wizard.
>
> Problem2: Where do I set the job to delete the previous nights backup?
>
> Thanks,
>
> Warren

Install Service Pack 2
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx

12 Mar 2007 5:32 PM

Warren

Dear Steve,

Thanks!

I'm currently running this in a clustered environment and you suggestion is
to install S*@..OK

Thanks,

Warren
Show quote

"Steve" wrote:

> On Mar 2, 10:06 am, Warren <War***@discussions.microsoft.com> wrote:
> > Hi,
> >
> > I've installed SQL Server 2005 Enterprise Edition w/ SP1. I setup a
> > maintenance plan using the wizard to backup the databases. If I run the plan
> > manually it runs fine. I scheduled the plan to run each night..
> >
> > Problem: 1) The jobs fail each night with this error: The command line
> > parameters are invalid. The step failed. Haven't a clue what it means sense
> > this was setup using the wizard.
> >
> > Problem2: Where do I set the job to delete the previous nights backup?
> >
> > Thanks,
> >
> > Warren
>
> Install Service Pack 2
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx
>
>

3 Mar 2007 8:09 PM

Ed Murphy

Warren wrote:

> I've installed SQL Server 2005 Enterprise Edition w/ SP1. I setup a
> maintenance plan using the wizard to backup the databases. If I run the plan
> manually it runs fine. I scheduled the plan to run each night..
>
> Problem: 1) The jobs fail each night with this error: The command line
> parameters are invalid. The step failed. Haven't a clue what it means sense
> this was setup using the wizard.
>
> Problem2: Where do I set the job to delete the previous nights backup?

Under 2K, the plan included an option to delete old backups after a
given number of days. Is this still the case in 2K5?

3 Mar 2007 9:10 PM

Steve

On Mar 3, 12:09 pm, Ed Murphy <emurph***@socal.rr.com> wrote:

> Warren wrote:
> > I've installed SQL Server 2005 Enterprise Edition w/ SP1. I setup a
> > maintenance plan using the wizard to backup the databases. If I run the plan
> > manually it runs fine. I scheduled the plan to run each night..
>
> > Problem: 1) The jobs fail each night with this error: The command line
> > parameters are invalid. The step failed. Haven't a clue what it means sense
> > this was setup using the wizard.
>
> > Problem2: Where do I set the job to delete the previous nights backup?
>
> Under 2K, the plan included an option to delete old backups after a
> given number of days. Is this still the case in 2K5?

The Maintenance Plan Wizard has a Define Maintenance Cleanup Task
page
or
if your not using the wizard select the Maintenance Cleanup Task from
the toolbox.