• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 645
  • Last Modified:

How do you set the auto-delete option on SQL2005 sql agent backup jobs?

Im having difficulty knowing where to specify the deletion period for the dump files created in a SQL2005 database backup schedule in SQL Agent. It seems now to create an SSIS sub-package for the task when using the wizard options, and doesnt seem to have the "remove after x days/weeks" option that the old SQL 2000 wizard used to have:
 -UseDefDir  -DelBkUps 1WEEKS -BkExt "BAK"'

On looking at the SQL2005 backup db subtask, it seems to call a cmd exec command;

/SQL "Maintenance Plans\MaintenancePlan - backup databases" /SERVER "$(ESCAPE_NONE(SRVR))" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /SET "\Package\Subplan_1.Disable";false

Any ideas how you do this?
0
Yeatsie
Asked:
Yeatsie
  • 2
1 Solution
 
SQL_SERVER_DBACommented:
is the . included in the .bak, check in your maintenace plan
0
 
SQL_SERVER_DBACommented:
and SP2
0
 
knightforce777Commented:
I found the answer here, provided by Nightman.

http://www.experts-exchange.com/Database/Miscellaneous/Q_22094080.html
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now