The following table lists required permissions for user accounts to back up and restore Microsoft SQL Server data.
Operation Type | Required Roles and Permissions |
---|---|
Backup | For more information on required permissions, see the Required Permissions section of the Veeam Backup & Replication User Guide. |
Restore | To restore data via Veeam Explorer for Microsoft SQL Server, make sure the user account you are using is a member of the Local Administrator group and has been granted the sysadmin role on a target Microsoft SQL Server. For more information about Microsoft SQL Server roles, see this Microsoft article. |