• JoshDBGuy (7/29/2015)


    From books online

    If the database being restored does not exist, the user must have CREATE DATABASE permissions to be able to execute RESTORE. If the database exists, RESTORE permissions default to members of the sysadmin and dbcreator fixed server roles and the owner (dbo) of the database (for the FROM DATABASE_SNAPSHOT option, the database always exists).

    Thanks for the information, but as noted in my original post....

    * The user is a member of the dbcreator role - and the serveradmin and sysadmin roles

    * The user is a member of dbowner on the database I am trying to overwrite with the restore

    * I have given the user the rights CREATE DATABASE and CREATE ANY DATABASE