Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007

    Question Unanswered: Server and database role requests for normal user


    I want to know how to assign a normal user to take backup,Restore and attach and detach the database in sqlserver2000.

    Please can anyone help me to find out which server role or database role will suites my requirements.

    Md S.Hassan

  2. #2
    Join Date
    May 2007
    somewhere in dbforums
    Any logon that requires permissions to perform backup or restore operations should be provided membership in the following SQL Server roles:

    Server Role : sysadmin
    DB role : db_backupoperator, dbo_owner

    Permissions required for performing restore -
    Server role : sysadmin, dbcreator
    DB role : db_owner

    for further information you can check this site out
    Last edited by nick.ncs; 06-05-07 at 07:19.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts