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
LVL 1
mikeydkAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Johan OhlssonConnect With a Mentor MS 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
 
HuaMinChenSystem managerCommented:
You should use sa account to do backup/restore.
0
 
Carl TawnConnect With a Mentor Systems 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
All Courses

From novice to tech pro — start learning today.