I want to create a user having
db_restore server roles and will be
db_owner of that database. But there is only 1 server role available, that is
db_creator, which can create database and is also the
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.