Azure SQL VM Backup Automation Change

Cherise D Woods 1 Reputation point
2024-06-27T19:42:19.0566667+00:00

I have an Azure SQL VM and it is running automated backup of user databases every 5 minutes. I can't seem to identify where the automation is running from only see Managed Backup and it runs and saves to Azure storage account. No disaster recovery is setup for this test server. Any suggestions on what process could be doing this maintenance and how to update it? It just started May of this year.

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Sina Salam 6,966 Reputation points
    2024-06-27T22:11:45.9333333+00:00

    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:

    1. 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.
    2. 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.
    3. 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:

    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

    0 comments No comments