Re: Problem with remove files older then in backup

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: ra294 (ra294_at_hotmail.com)
Date: 03/10/04 

Date: Wed, 10 Mar 2004 18:30:59 +0200

Thanks for the quick response.
Where is this script located ? What's the name of the file ?

ra294@hotmail.com

"Jasper Smith" <jasper_smith9@hotmail.com> wrote in message
news:%23c9MECrBEHA.1140@TK2MSFTNGP10.phx.gbl...
> In the end, a maintenance plan just generates a parameter list for
> xp_sqlmaint. You can modify this yourself in the job that is created. For
> details on the options have a look in BOL for "sqlmaint utility" e.g. the
> switch for deleting backups is
> -DelBkUps <time_period> where
> <time_period> ::= number[minutes | hours | days | weeks | months]
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
>
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
>
> "ra294" <ra294@hotmail.com> wrote in message
> news:%23CIRutpBEHA.3524@TK2MSFTNGP10.phx.gbl...
> > I am using MSDE 2000 sp3 on Windows 2003 Server. I am connecting to this
> > MSDE from another computer using Enterprise manager. I have created a
> > maintenance plan that backup the DB once a day. The problem is that in
the
> > option to "remove files older then" - the combo box where the
> day/week/month
> > should be is empty so I can not set this option.
> > How can I fix it ?
> >
> > Thanks for your time
> > ra294@hotmail.com
> >
> >
> >
>
>

Relevant Pages

  • SQL 2000 Cluster Not Failing over
    ... see Help and Support Center at ... SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL 2008 backup maintenance plan requires integration services
    ... Not as comfortable as with a maintenance plan but will do the job as well... ... The SQL Server Execute Package Utility requires Integration Services to be ... To install Integration Services, run SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: SBS 2003 R2 SQL Server 2005 Maintenance Plan Doesnt WORK
    ... Maintenance Plan in SQL Server 2005. ... Microsoft CSS Online Newsgroup Support ... you may want to contact Microsoft CSS directly. ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem with remove files older then in backup
    ... > switch for deleting backups is ... > Jasper Smith (SQL Server MVP) ... > I support PASS - the definitive, ... >> maintenance plan that backup the DB once a day. ...
    (microsoft.public.sqlserver.setup)
  • RE: Maintenance Plan
    ... The best way to get sarted with Maint Wizard (or any of these admin tasks) ... Database Maintenance on SQL Server 7.0/2000 ... Troubleshooting Database Maintenance Plan Failures ...
    (microsoft.public.sqlserver.setup)