This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Good morning community.
I currently have a VM1 with a soft, and another VM2 with 2 Microsoft SQL server databases.
This VM1 hosts the information in the databases of VM2.
What I need is to make a daily backup of these 2 databases and store it in some blob storage within Azure.
An Azure service that stores unstructured data in the cloud as blobs.
An Azure managed MySQL database service for app development and deployment.
Answer accepted by question author
![](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(256, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
That is what SQL maintenance plans are designed to do as discussed here. There is a section that talks about how to automate your database backups. From there you need only move them to Azure storage which you could do as part of the maintenance plans or via a separate scheduled task, depending upon your needs.
They are my first works with Azure.
What I need is through SSMS to create the backup weekly and monthly to send it to a container in Azure and then have that information to restore it in case of database failure.
What I can't understand is how to host them in those containers, and how to see them in the Azure platform.
When I force the backup through SSMS it gives me error 50, which I understand is that the connection does not arrive. Check Firewall permission and my public IP is added.