S3 & Multiple Buckets

nhustak2

SQL Backup Pro can only use a single linked S3 bucket.   This means all backups that are stored must use the same lifecyle settings (at least for BackBlaze)
My client wants a monthly backup that is permanent.   We also do a daily full backup with differentials throughout the day.  We want these to expire after 7 days (so a rolling expiration)

Is there anyway around this?  I thought maybe we could do it per backup job, which would make sense but setting it there sets a global bucket.

Jon_Kirkwood

Hi @nhustak2

Thank you for reaching out on the Redgate forums regarding your SQL Backup question

You're right that SQL Backup Pro only allows you to link a single S3 bucket, which makes it tricky to set different lifecycle policies for different types of backups.

 

One workaround could be to use S3 folder paths or prefixes within the same bucket to differentiate the backups. 

 For instance, you could store the monthly backups in one folder (e.g., <i>s3://bucket-name/monthly-backups/</i>) and the daily backups in another (e.g., <i>s3://bucket-name/daily-backups/</i>).

Then, you could apply different lifecycle policies at the folder/prefix level in your S3 bucket settings:

 

1. Monthly Backups: Apply a lifecycle policy to the monthly-backups/ folder that retains these files permanently (or as long as you need).
2. Daily Backups: Apply a lifecycle policy to the daily-backups/ folder to expire objects after 7 days.

 

While this approach doesn’t solve the issue directly within SQL Backup Pro, it could provide a way to maintain different expiration policies within the same bucket.

nhustak2

BackBlaze has no option to provide lifecyle settings outside of the bucket.    This seems like a serious issue.  I have to tell you - between the issue with requiring a license to restore a backup and now this....It makes no sense to have ALL backups for a server tied to a single bucket.   I feel like I'm constantly running into roadblocks trying to use this.  I really want a refund but that's already been denied - This is the first product from red-gate that has continually disappointed me.     It's simply time to find another solution.