Restore database RRS feed

  • Question

  • 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.


    zahid iqbal


    Monday, June 22, 2015 7:32 AM


  • 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:


    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