I want to create a user having dbcreate, db restore server roles and will be db owner of that database. But there is only 1 server roles available that is dbcreator, which can create database is also db owner of that. But when I restore another database backup that gets disconnected, i.e. not accessible.
In sql server is there any way that can create and restore db and will be dbowner of that database. I don`t want to grant sysadmin server roles to that user.
Please help me out.