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.