Unable to backup new sql server instance databases on azure portal

Nitin Goyal 5 Reputation points
2023-06-27T06:17:22.6033333+00:00

Hi Team,

We have sql server installed on a windows machine, we have already three instances there and we have scheduled the backup on azure portal and was running fine. After adding a new instance on sql server we are unable to schedule its backup on azure portal. How can we fix this ?

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,157 questions
Azure SQL Edge
Azure SQL Edge
An Azure service that provides a small-footprint, edge-optimized data engine with built-in artificial intelligence. Previously known as Azure SQL Database Edge.
45 questions
Azure Policy
Azure Policy
An Azure service that is used to implement corporate governance and standards at scale for Azure resources.
797 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Chathura Munasinghe 170 Reputation points
    2023-06-27T07:53:28.8466667+00:00
    • Make sure that the new SQL Server instance is registered with the Azure Backup service. You can do this by following these steps:
      • In the Azure Portal, go to the Backup Center.
      • Click Backup items.
      • Select SQL in Azure VM.
      • Click Add.
      • Enter the name of the new SQL Server instance and the Azure resource group that it is in.
      • Click Add.
    • Make sure that the new SQL Server instance has the latest version of the Azure Backup agent installed. You can check the version of the agent by running the following command:
    sqlagent\bin\sqlagent.exe /v

    content_copy

    If the agent is not up to date, you can update it by running the following command:

    sqlagent\bin\sqlagent.exe /upg

    content_copy

    • Make sure that the new SQL Server instance has a valid backup policy. You can create a backup policy by following these steps:
      • In the Azure Portal, go to the Backup Center.
      • Click Backup policies.
      • Click Create.
      • Select the type of backup policy that you want to create.
      • Enter the name of the backup policy and the Azure resource group that it will be in.
      • Select the SQL Server instance that you want to back up.
      • Click Create.

    If you have checked all of these things and you are still unable to schedule the backup of the new SQL Server instance, you can contact Azure support for help.

    Here are some other things you can try:

    • Restart the Azure Backup service.
    • Restart the SQL Server instance.
    • Check the event logs for any errors related to the backup.

    I hope this helps!

    0 comments