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

    Question Unanswered: Server and database role requests for normal user

    Hi,

    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.

    Regards
    Md S.Hassan

  2. #2
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    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
    http://vyaskn.tripod.com/sql_server_..._practices.htm
    Last edited by nick.ncs; 06-05-07 at 08: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
  •