How do I add a database to an existing Backup Policy on an Azure SQL VM?

Raul Massuet 20 Reputation points
2024-05-31T21:29:52.8933333+00:00

I have a SQL Server on Azure VM. I have made a Backup Policy to protect 5 databases. I want to add a new database recently created to the Policy but I can no longer see the VM in Discovery.

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,164 questions
0 comments No comments
{count} votes

Accepted answer
  1. Sina Salam 5,796 Reputation points
    2024-06-01T08:59:59.2633333+00:00

    Hello Raul Massuet,

    Welcome to the Microsoft Q&A and thank you for posting your questions here.

    Problem

    I understand that you would like to dd a new database recently created to the Policy, but you can no longer see the VM in Discovery and you need help to fix this.

    Solution

    If the VM is no longer visible in the discovery, it might be due to configuration changes or other issues. I will provide you few step-by-step guides to help you add a new database to your backup policy:

    1. Ensure VM is Properly Configured by ensuring the Azure Backup extension is installed on your VM and VM is connected and communicating with the Azure Backup service.
    2. Re-discover Databases. Sometimes, the VM might not appear due to discovery issues. Re-discover the databases on the VM:
      1. From Azure Portal. > Navigate to Recovery Services vaults.
      2. Select your Recovery Services vault.
      3. In the Settings section, select Backup Management Servers.
      4. Select Azure Backup Agent.
      5. Select the Azure VM running your SQL Server.
      6. Choose Discover DBs. This will re-discover the databases on the VM. NOTE: About 'Create or Configure a Recovery Services Vault' If you don't have one, create a Recovery Services vault in the same region as the VM hosting the SQL Server instance.
    3. You can enable auto-protection for the desired SQL Server instance or Always On availability group under Configure Backup for SQL Server in Azure VM. When enabled, all the databases for that SQL Server will automatically be selected.
    4. Add New Database to Backup Policy (As you have done before)
      1. Navigate to Backup Policy by go to Recovery Services vaults. > Select your vault. > Under Settings, select Backup policies.
      2. Then, Modify Policy, by Select the policy you want to modify.> Click on Edit policy.> Go to the Item-level Backup section.> Click Add Items or similar option to add the newly discovered database.
      3. Select Database from the discovered databases, select the new database you want to add. Confirm your selection. and Save Policy by save the changes to the backup policy.

    References

    Source: Azure Backup can automatically protect SQL databases in Azure VM. Accessed, 6/1/2024.

    Source: Backing up SQL Server databases on Azure VMs - Azure Backup. Accessed, 6/1/2024.

    Source: Azure Backup for SQL Server Databases on Azure VM. Accessed, 6/1/2024.

    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

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful