title: Restore SQL Server database to different server with non sysadmin user
body: <p>I'm trying to restore a database from a backup into a different server using an user that is not <strong>sysadmin</strong> (with dbcreator server role).</p>
  
  <p>According to this: <a href="http://technet.microsoft.com/en-us/library/ms190436(v=sql.105).aspx" rel="nofollow">http://technet.microsoft.com/en-us/library/ms190436(v=sql.105).aspx</a> the user that restores the database is the dbOwner.</p>
  
  <p>Using a <strong>sysadmin</strong> 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.</p>
  
  <p>I've already tried to add more server roles to the user (in the limit everything except <strong>sysadmin</strong>) and the result is always the same: I can restore the database but then I can't access it.</p>
  
  <p>Is there any way of doing this without a <strong>sysadmin</strong> user?</p>