I'm trying to restore a database from a backup into a different server using an user that is not sysadmin (with dbcreator server role).
According to this: http://technet.microsoft.com/en-us/library/ms190436(v=sql.105).aspx the user that restores the database is the dbOwner.
Using a sysadmin user I can see in the database properties that the user that restored the database is the owner, however after the restore I can't access the database.
I've already tried to add more server roles to the user (in the limit everything except sysadmin) and the result is always the same: I can restore the database but then I can't access it.
Is there any way of doing this without a sysadmin user?