Backup Azure SQL

Question

We have deployed Veeam for Azure to backup out Azure VMs and Azure SQL. We have had no issues backing up our Azure VMs. We cannot get Veeam to backup Azure SQL. I created a login for these backups and given it all the rights Veeam support told me it needs. Now they say that this login needs the sysadmin server role (not db role).

Hello Joshua,

Your dBA should be able to grant the account the sysadmin server role. 

Get started with Database Engine permissions - SQL Server | Microsoft Learn

Azure support should be able to assist as well if needed. 

How do I do this?

Answer 1

Hi @Joshua Goodin, MBA

Thanks for the Question and using Microsoft Q&A

As per my understanding, you want to grant the sysadmin role to a login in your Azure SQL Managed Instance:

Veeam backup for Azure SQL requires sysadmin server role to allow full access to backup and restore operations on the SQL server. The sysadmin role gives the login the ability to perform any task on the server, including backing up and restoring databases, which is essential for Veeam to perform these operations successfully.

Once this role is assigned, the Veeam backup job should be able to perform the necessary backups on your Azure SQL Managed Instance.

Please follow below steps to grant the sysadmin role to a login in your Azure SQL Managed Instance:

1. Open SQL Server Management Studio (SSMS)
2. Connect to the Azure SQL server where your databases reside. You'll need to connect using an account that has sufficient permissions, such as a server admin.

Once you're connected to the server, you can grant the sysadmin role to the login you created for Veeam using the following SQL script:

ALTER SERVER ROLE sysadmin ADD MEMBER [YourLoginName];

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.