• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 408
  • Last Modified:

restore and backup SQL database

Hey

I would like to give one of my users rights to restore and backup a specific database.

Using the SQL Management Console

MS SQL2010

How to?

Thx

Mike
0
mikeydk
Asked:
mikeydk
2 Solutions
 
HuaMinChenBusiness AnalystCommented:
You should use sa account to do backup/restore.
0
 
Carl TawnSystems and Integration DeveloperCommented:
>> You should use sa account to do backup/restore
No you shouldn't.

The minimum permissions your user needs for BACKUP/RESTORE is to be a member of the db_backupoperator fixed server role.
0
 
Johan OhlssonMS Production Server Engineer Commented:
The user needs to be the dbo (not to confuse with the db_owner database role) in order to restore into an existing database. Dbo can be changed by sp_changedbowner

See link for : How to restore

http://technet.microsoft.com/en-us/library/ms177429.aspx

You can use the script to create a user for restore,Create Minimum permission backup restore role User / Operator DB for SQL 2008. In the attach file
db-backup-operator.sql
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now