backup and restore previlages of non sysadmin

  • How can give permissions to a non sysadmin to backup and restore any database on server. I want to do this for a user on Test server.

    I thought of using db_backupoperator but it is a db role but not server role.

  • "nothing is better than giving a trail"

    try this iam also not sure

    give DBCREATOR in serverrole and db_backupoperator in database role

    normaly bulkadmin and public are common to non sysadmin

    check in this

    http://sqlserverpedia.com/wiki/Built-In_Server_Roles_%26_Database_Roles

    and one doubt why are u giving the non sysadmin [is he/she also a DBA ] these backup and restore previllages ??????/?

    Thanks
    Naga.Rohitkumar

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply