how to add Sql server user for specific database with backup and restore permission only ??
migrated from stackoverflow.com Apr 4 '10 at 4:45
This question came from our site for professional and enthusiast programmers.
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.