backup operator

Question

I have to assign a group db_backupoperater permissions.  Do they need any other role like db_dbwriter or dbreader?  I don't usually assign roles like this.

Thanks

Answer 1

Hello,

This of course will depend upon what permissions you want the group to have.  If you only want the group to be able to issue backup commands against the database in question, then db_backupoperater is all that is needed.

Cheers
Rob