Different Purge Dates for Local Drive and Network Shares?

spc_kevin · November 12, 2007 4:42PM

Not sure if this is possible...

If I am backing up to a Local drive and a network share I'd like them to have different purge intervals. make sense? In other words, I'd like to keep my backups on local drives for 14 days but, on network shares for 30 days.

Doable?? :lol:

Thanks,

petey · 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.

Stephen Lyall · November 12, 2007 10:18PM

I think it would be very useful.

Giggles220 · 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.

spc_kevin · 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&#40;"Scripting.FileSystemObject"&#41;
 sDirectoryPath = "F:\Redgate_SQL_Backup"
 set oFolder = oFSO.GetFolder&#40;sDirectoryPath&#41;
 set oFileCollection = oFolder.Files

 For each oFile in oFileCollection
  if Right&#40;oFile.Name,4&#41; =".sqb" Then
         If oFile.DateLastModified &lt; &#40;Date&#40;&#41; - &#40;iDaysOld-1&#41;&#41; Then
          oFile.Delete&#40;True&#41;

         End If
  End if
 Next

 Set oFSO = Nothing
 Set oFolder = Nothing
 Set oFileCollection = Nothing
 Set oFile = Nothing

HJoyce · 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

Different Purge Dates for Local Drive and Network Shares?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk