Purging of encrypted backups

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Purging of encrypted backups

Postby dhechle » Thu May 12, 2011 9:40 am

I am using Redgate SQL Backup 6.4 across all my SQL instances, these are all encrypted using 256 bit and are set to delete all backups older than 5 days.

As a policy in our organisation I have to change the password for the backups on a monthly basis which was done earlier this month. Problem I have is this morning my backup drive was full due to the job not purging any of the backups older than 5 days with the previous password, however any backups older than 5 days with the new password had been deleted.

Is this by design as it places another manual step of deleting backups with the old password when I have to do the password rotation?

regards,

Dave
dhechle
 
Posts: 8
Joined: Wed Nov 10, 2010 11:35 am

Postby petey » Thu May 12, 2011 1:29 pm

This is by design. I'll raise a feature request to allow additional password(s) to be entered for the purpose of deleting old backup files.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm

Postby dhechle » Fri May 25, 2012 10:55 am

Hi Petey,

I was wondering if the feature request you were going to raise below was ever done.

i.e. Does SQL Backup Pro 6.5 or 7.0 purge backups with a previous password?

thanks in advance,

Dave
dhechle
 
Posts: 8
Joined: Wed Nov 10, 2010 11:35 am

Postby petey » Fri May 25, 2012 12:29 pm

The reference number is SB-4653, if you need to reference the feature request in your correspondences with Red Gate. This issue is still under consideration, and has not been implemented yet.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests