Home > Articles > Data > SQL Server

  • Print
  • + Share This

The BACKUP DATABASE and BACKUP LOG Statement Permissions

The BACKUP DATABASE and BACKUP LOG permissions can also be assigned to individual users, Windows users/groups, and roles. Although backing up the database and transaction logs is usually an automated process carried out by scheduled jobs created by the system administrator, some environments require that individual users be given the ability to perform these backups.

TIP

Again, using the db_backupoperator fixed database role is much better than granting the BACKUP DATABASE and BACKUP LOG statement permissions. You usually need the other rights granted by the role membership anyway, and figuring out who has what rights is easier when you take advantage of SQL Server roles.

  • + Share This
  • 🔖 Save To Your Account

Related Resources

There are currently no related titles. Please check back later.