Different Purge Dates for Local Drive and Network Shares?

• 
  It is currently not possible to specify location dependent purge dates.
  
  I will log it for the decision makers to decide if it should be included in a future version. If anybody else has ever needed this feature, please do post a comment here, so that we get an idea of how useful this feature would be. Thanks.

  petey November 12, 2007 20:31

  - 0 +
• 
  I think it would be very useful.

  Stephen Lyall November 12, 2007 22:18

  - 0 +
• 
  This would be extemely useful for us as well. Currently I wrote a script to do the second delete for us.

  Giggles220 November 13, 2007 07:55

  - 0 +
• 
  Thanks for the answer. Yes, I think it would be very useful.
  
  In the mean time, I added an ActiveX Script Step to the red gate backup job that checks the local drive for .sqb files older than 14 days. and removes them and set my backup job to retain files up to 30 days. That should work for now.
  

  Option Explicit
  on error resume next
   Dim oFSO
   Dim sDirectoryPath
   Dim oFolder
   Dim oFileCollection
   Dim oFile
   Dim iDaysOld
  
   iDaysOld =14
   Set oFSO = CreateObject("Scripting.FileSystemObject")
   sDirectoryPath = "F:\Redgate_SQL_Backup"
   set oFolder = oFSO.GetFolder(sDirectoryPath)
   set oFileCollection = oFolder.Files
  
   For each oFile in oFileCollection
    if Right(oFile.Name,4) =".sqb" Then
           If oFile.DateLastModified < (Date() - (iDaysOld-1)) Then
            oFile.Delete(True)
  
           End If
    End if
   Next
  
   Set oFSO = Nothing
   Set oFolder = Nothing
   Set oFileCollection = Nothing
   Set oFile = Nothing
  

  spc_kevin November 13, 2007 12:38

  - 0 +
• 
  In 5.3 there is now a new keyword ERASEFILES_REMOTE which allows this functionality.
  
  "Deletes all SQL Backup files for the database that are older than the specified number of days (or hours), and are located on a network share. You use this argument if you want to specify different deletion intervals for local files and files located on network shares. If not specified, SQL Backup uses the ERASEFILES value."
  
  As explained in the help file: http://help.red-gate.com/help/SQLBackup ... ACKUP.html

  HJoyce April 09, 2008 08:27

  - 0 +

Add comment

Please sign in to leave a comment.