Multiple choice technology web technology

If you want to let a member of your technical support staff back up a database without having to grant any other permission to a database or SQL Server instance, to which role should you add the staff member?

  1. sysadmin

  2. db_owner

  3. db_accessadmin

  4. db_backupoperator
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The db_backupoperator fixed database role is specifically designed to allow backing up databases without granting other permissions. Sysadmin has too many privileges, db_owner allows full control, and db_accessadmin manages access permissions.

Keep practicing — related questions