Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question

migrated from Apr 4 '10 at 4:45

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

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.