Automate End of Month Redgate SQL Backup Copies in Azure Storage

Abimbola Adeniran 66

The requirement is to automate the copying of End of Month backups for select critical databases from their main Azure storage container to a separate audit container within the same storage account.

Currently, each server writes full, differential, and log backups daily to a dedicated storage account with a general retention policy of 70 days. The auditors have requested that these specific critical backups be retained for a longer duration, prompting the creation of an additional container for audit purposes.

The goal is to establish an automated process that minimizes effort and is scalable, alongside implementing a longer retention policy (with archive) for the audit storage container.

Olaf Helper 45,811 Reputation points

2025-02-03T11:10:07.08+00:00

Redgate SQL Backup

Then contact Redgate support: https://productsupport.red-gate.com/hc/en-us
Abimbola Adeniran 66 Reputation points

2025-02-03T12:05:50.3433333+00:00

There's only the toption to copy Redgate backups to one hosted storage which is the main storage container.

I want to be able to copy the backups in the Redgate SQL backup container to another container
Abimbola Adeniran 66 Reputation points

2025-02-03T12:06:03.37+00:00

There's only the toption to copy Redgate backups to one hosted storage which is the main storage container.

I want to be able to copy the backups in the Redgate SQL backup container to another container
Erland Sommarskog 116.5K Reputation points MVP

2025-02-03T22:18:25.5333333+00:00

But what is your question? If the question is how to do this with Redgate's product, I think Olaf's suggestion is the way to go.

Or do you want to solve in another way? (But if so, why did you mention Red Gate in the title?)
Mahesh Kurva 2,670 Reputation points Microsoft Vendor

2025-02-05T10:55:11.7766667+00:00

Hi @Abimbola Adeniran,

We haven’t heard back from you regarding the last response, and I just wanted to check in to see if you’ve found a resolution yet. If you have resolved the issue, please share your solution with the community, as it could be helpful to others. Otherwise, feel free to provide more details, and we’ll do our best to assist you.
Mahesh Kurva 2,670 Reputation points Microsoft Vendor

2025-02-06T11:01:49.6233333+00:00

Hi @Abimbola Adeniran,

We haven’t heard back from you regarding your last response, @Erland Sommarskog, and I just wanted to check in to see if you’ve found a resolution yet. If so, please share your solution with the community, as it could be helpful to others. If the issue is still unresolved, feel free to provide more details, and we’ll do our best to assist you.
Abimbola Adeniran 66 Reputation points

2025-02-06T21:18:45.83+00:00

Hi @Mahesh Kurva

Thanks for your message. I havent found a resolution yet. Just to respond to @Erland Sommarskog has said, I mentioned Redgate because its easier to move things around via vanilla SQL backups instead of Redgate that provides a capabilities to backup to a single hosted storage.

I dont want to have to take the backup twice so I'm thinking of some automation using azcopy to copy the first full backups at start of the month from one storage container into another. The only thing missing now is where to host the automation (i.e. powershell file and related orchestion) since its all gonna be storage account level backup copy.

I'm also to checking with Redgate support to see if I can copy backups to multiple hosted storage locations @Olaf Helper

Share via

Automate End of Month Redgate SQL Backup Copies in Azure Storage

Your answer