![](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(80, 34%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Azure SQL Database
An Azure relational database service.
5,672 questions
![](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(246.4, 4%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Hello Cherise D Woods,
Welcome to the Microsoft Q&A and thank you for posting your questions here.
Problem
I understand that your Azure SQL VM is performing automated backups, but you're not sure about the source of this automation.
Solution
To solve these challenges, let's start from the top:
- Automated Backup allows you to schedule regular backups for all databases on a SQL Server VM. These backups are stored in an Azure storage account. Start from SQL Server 2014 and later. Though, SQL Server 2016 and later allows you to configure manual scheduling and adjust the frequency of full and log backups. The backups are retained for up to 30 days, and it happens that the SQL Server IaaS Agent Extension, automatically installed on SQL Server Windows VM images in Azure, handles the backups.
- Secondly, Azure Backup provides an enterprise-class backup capability for SQL Server on Azure VMs. It allows centralized management of backups for multiple servers and thousands of databases. From SQL Server 2012 and later, and also happens that Azure Backup integrates with your VMs and handles backups centrally.
- Finally, depending on your SQL Server version, you can manually back up and restore SQL Server on Azure VM.
Therefore, to identify which method is being used, check the followings:
- In your Azure Portal, check for the presence of the SQL Server IaaS Agent Extension (for Automated Backup) or the Azure Backup configuration (for Azure Backup).
- Sign in to the Azure portal.
- Navigate to your **SQL Server VM.
- Look for the SQL Server IaaS Agent Extension in the VM settings.
- https://video2.skills-academy.com/en-us/azure/azure-sql/virtual-machines/windows/sql-server-iaas-agent-extension-automate-management?view=azuresql
- In your SQL Server Configuration, review the SQL Server Agent jobs or any custom scripts that might be triggering backups. https://www.databasejournal.com/ms-sql/automated-backups-of-sql-server-databases-in-azure-iaas-vms
- Also, in your Azure Portal, navigate to Azure Backup Center, check if your VM is configured there. The default policy backs up VMs once a day. So, check if Recovery Services vault is created and check the backup policy that was assigned. Using the above links too.
References
The links provided are useful for more reading and step by steps detail instructions, also use the additional resources provided by the right side of this page.
Accept Answer
I hope this is helpful! Do not hesitate to let me know if you have any other questions.
** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful ** so that others in the community facing similar issues can easily find the solution.
Best Regards,
Sina Salam