0

We have installed sql server on a virtual machine and we have registered the machine so that way SQL Server IaaS Agent Extension (SQLIaaSAgent) gets enable and runs on Azure virtual machines to automate administration tasks for sql server. One of those task is automate the backups as you can see the option in the next image

enter image description here

Now, to perform the automated backups we need an storage account, we have created that storage account and inside the storage account a blob container, but the problem we have right now is that when we are selecting the storage where we want the backups to go we can only select the storage account but not the container, So where are the backups going? we can't find them in the storage account, how can we be sure the backups are being made? and how can we select the blob storage in this feature?. thanks in advance

enter image description here

0

From

An Azure storage account to use for storing Automated Backup files in blob storage. A container is created at this location to store all backup files. The backup file naming convention includes the date, time, and database GUID.

https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/automated-backup

If you turn that feature off in the portal, you can still use the underlying engine feature SQL Server managed backup to Microsoft Azure, which allows you to specify the container.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.