Unable to backup new sql server instance databases on azure portal

Question

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 ?

Answer 1

• 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!