Post reply

Restore Permission to Non-Sysadmin user in SQL Server 2005

  • November 14, 2008 at 12:33 pm

    #193798

    Hi,

    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?

  • November 15, 2008 at 10:38 am

    #898996

    Can you be specific about what didn't work? Did you make the user a member of the db_owner role in the database?

    Greg

  • November 15, 2008 at 11:22 am

    #898998

    Well i try to backup and restore but it did not work. I tried by making it dbowner, putting it in db_owner role also. It worked only if we make it sysadmin. It is not working for Non sysadmin user.

  • November 15, 2008 at 11:36 am

    #899001

    Hi,

    Only sysadmins and dbcreator roles plus the owner of the database (dbo, not only in the db_owner role) can RESTORE if the database already exists. If the database doesn't already exist, you need to have CREATE DATABASE permissions.

    For BACKUP, it is enough to be in either db_backupoperator or db_owner database roles.

    HTH

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

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

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