Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

how to add Sql server user for specific database with backup and restore permission only ??

share|improve this question

migrated from stackoverflow.com Apr 4 '10 at 4:45

This question came from our site for professional and enthusiast programmers.

1 Answer 1

BACKUP DATABASE and BACKUP LOG permissions default to members of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles.

So your user must be added to the fixed role db_backupoperator.

You do not want to have an user that has 'restore permission only'. Restores are performed by the database owner only (ie. sysadmin, db_owner or db_creator members). There is no such dedicated role as 'db_restoreoperator' and there cannot be one, because an user that can restore arbitrary content into a database is in effect the owner of the database: it can use backup/restore as a vector to alter the content of the database as he/she likes, so such a role would be a masquerade of security.

share|improve this answer
you mean that i need to make a user as database owner –  MZT Apr 3 '10 at 20:11

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.