Different Purge Dates for Local Drive and Network Shares?

Comments

• petey Redgate › Posts: 2,358 New member

  November 12, 2007 8:31PM

  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.

  Peter Yeoh
  SQL Backup Consultant Developer
  Associate, Yohz Software
  Beyond compression - SQL Backup goodies under the hood, updated for version 8

  0 · Share on Twitter
• Stephen Lyall Posts: 19

  November 12, 2007 10:18PM

  I think it would be very useful.

  0 · Share on Twitter
• Giggles220 Posts: 154

  November 13, 2007 7:55AM

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

  0 · Share on Twitter
• spc_kevin Posts: 3

  November 13, 2007 12:38PM

  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
  

  0 · Share on Twitter
• HJoyce Posts: 186

  April 9, 2008 8:27AM

  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

  Helen Joyce
  SQL Backup Project Manager
  Red Gate Software

  0 · Share on Twitter