Post reply

Backup Operator

  • May 9, 2011 at 12:59 am

    #239774

    Hi,

    Is there any option or way to give permission at server level to user to take only backup of the all the database on the server ?

    if so can you share with me ?

    Thanks in Advance.

  • May 9, 2011 at 2:03 am

    #1321574

    In this situaltion you can use database role "db_backupoperator".

    Create user and assign role of db_backupoperator in each database. Also you can create user and assign database role in model database.

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • May 9, 2011 at 2:55 am

    #1321590

    free_mascot (5/9/2011)

    In this situaltion you can use database role "db_backupoperator".

    Create user and assign role of db_backupoperator in each database. Also you can create user and assign database role in model database.

    HTH

    Thanks for your reply. you are right, we can use both way but i looking the serverrole level .

  • May 9, 2011 at 4:45 am

    #1321625

    I doubt the possibility of doing it from server role.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

Viewing 4 posts - 1 through 3 (of 3 total)

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