We help IT Professionals succeed at work.

If I have "db_owner" rights to my MSSQL database, why can't I restore (with replace)?

2,615 Views
Last Modified: 2012-08-14
I am a contractor for a large financial services company so I am not in control of my virtual SQL server instance.  I have been granted owner rights on the database I've been using.  

Until just recently I have been doing my own backups and restores during my testing of my app.  

Now, even though I have db_owner, the DB server is not allowing me to execute the script I've been running for weeks.

See code... and error...

What rights do I need to have restore to a database?  

And, are there any SQL server "Policies" that could revoke that right?


RESTORE DATABASE [my_db] 
FROM  DISK = N'E:\SQLBCKP\FULL-Mar15-Updtd-Scrubbed.bak' 
WITH  FILE = 1,  NOUNLOAD,  REPLACE,  STATS = 10


Msg 3110, Level 14, State 1, Line 2
User does not have permission to RESTORE database 'my_db'.
Msg 3013, Level 16, State 1, Line 2
RESTORE DATABASE is terminating abnormally.

Open in new window

Comment
Watch Question

Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Alpesh PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.