I want to give a non-sysadmin user permission to backup and restore a database. I have tried to make that user dbowner but it did not worked. Can anyone tell me how to do that?
BACKUP DATABASE and BACKUP LOG permissions default to members of the sysadmin fixed server role and the db_owner and db_backupoperator fixed database roles.
Did the user log off and re-connect to the sql server and then try to do the backups?