20,212 questions
Automate End of Month Redgate SQL Backup Copies in Azure Storage
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 55.00000000000001%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Abimbola Adeniran
86
Reputation points
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.
Windows for business Windows Server User experience Other
SQL Server Other
14,494 questions
{count} votes
-
Olaf Helper 47,436 Reputation points2025-02-03T11:10:07.08+00:00 Redgate SQL Backup
Then contact Redgate support: https://productsupport.red-gate.com/hc/en-us
-
Abimbola Adeniran 86 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 86 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 121.4K Reputation points MVP Volunteer Moderator2025-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?)
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva 5,025 Reputation points Microsoft External Staff Moderator2025-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 5,025 Reputation points Microsoft External Staff Moderator
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 86 Reputation points
2025-02-06T21:18:45.83+00:00 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
Sign in to comment
Sign in to answer