How does a non-sysadmin restore a SQL database
Posted on 2014-10-21
I've granted a non-sysadmin user the following:
View server state
View any definition
View any database
DBO of a destination database
db_owner of destination database
He attempts to restore a database where he's not a DBO, and it appears to have restored, but he's denied viewing it (The database is not accessible).
How can a non-sysadmin restore a database that's not his and see it. This is useful if he wants to restore a prod database to test where the prod db has 'sa' ownership.