Deleting old Log Files

• 
  Not yet.

  petey April 30, 2005 12:05

  - 0 +
• 
  Hi Sam,
  
  If you are using a script to do the backups, you could add a bit at the end to call xp_cmdshell to run a batch file to delete these files from your hard disk.

  Brian Donahue May 02, 2005 10:45

  - 0 +
• 
  The SQL Server Database Maintenance Plan is creating schedules to delete the older files (older than a certain amount of days).
  How can I keep the last backup (scheduled to be every day) and the logs (which I want to be backed up every 2 hours) from the moment I backup the full database to the moment the schedule will create another full backup file.
  How can I get rid of those old files?

  mirceamuresan May 19, 2005 18:21

  - 0 +
• 
  Delete full backup files every 1 day, and delete all trx log files everytime a full backup is made?

  petey May 19, 2005 19:29

  - 0 +
• 
  I didn't even realize how many log files had "piled" up on my box. There really needs to be a way to delete old logs. I had over 13000 of them!!

  appwright June 16, 2005 23:15

  - 0 +
• 
  Option to delete log files older than x number of days is planned to be included in a future release.

  petey June 16, 2005 23:49

  - 0 +

Add comment

Please sign in to leave a comment.