Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Restore database RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Team,

    Can you please tell me without sysadmin role a how user restore database in sql 2008r2.

    i have try to restore server"dbcreator" and user mapping" db_owner" but don't get luck,

    Please tell me how to restore database without sysadmin role, please explain.

    regards

    zahid iqbal

    9873530185

    Monday, June 22, 2015 7:32 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    It should be eniugh to assign at database level the role db_backupoperator and at instance level the role dbcreator.

    You can assign them by means of the script available here:

    https://gallery.technet.microsoft.com/Create-Minimum-Rights-4d746f7d#content

    If this fails, I suggest asking in one of the SQL Server forums (instead of the Training and Certification forum). But since you asked in the T & C forum, let me tell you that this is taught in course 20462, so that the answer becomes relevant for this forum.

    Tuesday, June 23, 2015 5:33 AM