Log History Purge

• 
  There isn't any way to manage the activity history from the GUI.
  
  I've prepared a small utility, that you can use to purge records older than x days. Note that this is NOT a Red Gate product, and comes with absolutely no warranty whatsoever. I would suggest making a backup of the data file, before running this utility for the first time.
  
  You can find the data file in C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Data, assuming your system drive is C:.
  
  Usage is
  
  trimdata <days to retain>
  
  To retain the last 14 days of activity history, use
  
  trimdata 14
  
  You can download the file from http://www.yohz.com/downloads/trimdata.zip

  petey January 05, 2006 12:17

  - 0 +
• 
  Thank you very much!! Is there any way to get this functionality included in the next release that is due out soon?

  appwright January 05, 2006 12:19

  - 0 +
• 
  In version 4, there is no longer a separate activity data file. All activity history will be obtained from the regular msdb tables, with SQL Backup specific data embedded in a couple of columns.
  
  The activity history display will be limited to the first 400 rows each for backup and restore, whether it be for the entire server, or for specific databases.
  
  Deletion wise, there is an option to run the msdb..sp_delete_backuphistory stored procedure after each SQL Backup process, to manage the msdb database size.

  petey January 05, 2006 12:35

  - 0 +
• 
  That's a great way to deal with it. Thanks.

  appwright January 05, 2006 14:22

  - 0 +

Add comment

Please sign in to leave a comment.