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.
OOps! You are currently offline.