Solved

restore and backup SQL database

Posted on 2014-01-20
3
367 Views
Last Modified: 2014-01-20
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
Comment
Question by:mikeydk
3 Comments
 
LVL 10

Expert Comment

by:HuaMinChen
ID: 39793604
You should use sa account to do backup/restore.
0
 
LVL 52

Assisted Solution

by:Carl Tawn
Carl Tawn earned 200 total points
ID: 39793623
>> 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
 
LVL 2

Accepted Solution

by:
Johan Ohlsson earned 300 total points
ID: 39793672
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

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Abstract Express Replacement Software 12 25
SQL Replication question 9 42
SQL Server 2012 - Merge Replication Issue 1 22
performance query 4 22
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question