Which fixed database role has permission to perform database backups?

Options

  • A. db_backupoperator
  • B. db_datareader
  • C. db_ddladmin
  • D. More than one of the above
  • E. None of the above

Correct Answer (Detailed Explanation is Below)

A. db_backupoperator

Detailed Explanation

  • db_backupoperator: Allows members to back up the database.
  • It is intended for users responsible for database backup operations.
  • It does not provide full database ownership permissions.