Bruce
asked on
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?
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.