I need to give a user server-level permissions, once and for all time, to back-up any existing or future database on the server instance, without making the user sysadmin. How can I do that?
I've tried giving users: dbcreator, serveradmin, setupadmin, but the user still can't backup a database unless she is a db_owner.
My team does a lot of testing setup and synchronization of environments. Team members need to be able to create new databases at will and backup and restore at will. Currently, we have to keep giving people db_owner rights on newly created databases. Any way to avoid this?