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

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?

FROM  DISK = N'E:\SQLBCKP\FULL-Mar15-Updtd-Scrubbed.bak' 

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

Who is Participating?
gladfellowConnect With a Mentor Commented:
"RESTORE permissions are given to roles in which membership information is always readily available to the server. Because fixed database role membership can be checked only when the database is accessible and undamaged, which is not always the case when RESTORE is executed, members of the db_owner fixed database role do not have RESTORE permissions."

The above explanation has been quoted from the MSDN article available at:

Hope it helps.
- Venkat
mrjoltcolaConnect With a Mentor Commented:
If you are trying to re-create the database (ie. doesn't exist at the time of the restore), check that you have CREATE DATABASE priv (or db_creator I believe)
SQLSergentMikeConnect With a Mentor Commented:
RESTORE permissions default to members of the sysadmin and dbcreator fixed
server roles and the owner (dbo) of the database ... members of the db_owner
fixed database role do not have RESTORE permissions.

Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
You need db_creator permission to do this.
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
db_owner means you have read and write permissions, plus backup rights
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.

All Courses

From novice to tech pro — start learning today.