SQL Server backup permissions determine who can back up and restore databases on a server instance. By default, members of the sysadmin fixed server role can back up and restore all databases on the server instance. However, you can configure the server instance to allow other users to back up and restore specific databases.
You can use the GRANT BACKUP DATABASE permission to allow specific users to back up a database. The following syntax is used to grant the permission:…
