Re: sqlmaint.exe -dekbkups

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 12/13/04 

Date: Mon, 13 Dec 2004 07:31:23 -0600

>From the SQL Server 2000 Books Online:

<Excerpts href="coprompt.chm::/cp_sqlmaint_19ix.htm">

[-DelBkUps <time_period>]

<time_period> ::=
number[minutes | hours | days | weeks | months]

number[minutes | hours | days | weeks | months]

Specifies the time interval used to determine if a report or backup file is
old enough to be deleted. number is an integer. Valid examples are 12weeks,
3months, and 15days. If only number is specified, the default date part is
weeks.

</Excerpts>

So you should specify '-DelBkUps 5days'. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"rob" <anonymous@discussions.microsoft.com> wrote in message 
news:326e01c4e0f8$c8e2e240$a301280a@phx.gbl...
> Hi... How do you specify SQLMAINT.EXE -DELBKUPS to delete
> backup files older than, say 5 days... as opposed to
> specifying the # of weeks. Thanks.

Relevant Pages

  • Re: FTI, Searching and other Filters
    ... No matter what I specify for a search condition, ... "SQL SERVER DBA"') ... Remove the FTI from the table. ... Add an OfficeID column to the table and populate it. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: ORDER BY in VIEW not working
    ... Only the queries issued against a view can ... typing an ORDER BY clause. ... State what version of SQL Server you are using and specify the content ...
    (comp.databases.ms-sqlserver)
  • Re: SQL Server 2005 - CLR Integration problem
    ... CREATE ASSEMBLY does not create the assembly, it adds an existing assembly from a dll (or you can specify the actual bits!). ... You said we need to create assembly i tried it from SQL Server Management ... Server to run CLR sp, fn, trigger, aggregate. ... > already configured SQL Server Surface Area Configuration. ...
    (microsoft.public.cert.mcdba)
  • Re: Inserting into partion view - values were not supplied for all columns
    ... Wayne Snyder, MCDBA, SQL Server MVP ... "Glyn Walters" wrote in message ... > When I try to insert into a partition view with specified ... If I specify all the columns ...
    (microsoft.public.sqlserver.server)
  • Re: using Integrated Security SSPI with User ID
    ... So to specify an alternate, you need to use the RunAs utility to ... > I'm trying to use integrated security with a User Id and password to ... The SQL Server administrators insist that I ... > use the intergrated security option in the connection string, ...
    (microsoft.public.dotnet.framework.adonet)
Loading