SQLTeam.com | Weblogs | Forums

Backup/Restore rights for a SQL user


#1

I have SQL login, i want to give that login, the back/restore rights. What roles we have to give to that login.


#2

add it to the db_backupoperator role.

though best practice would be to have a Windows group for backup operators, add the group to the role and add the login to the group.