Server - Level Roles in SQL Server

SQL Server supports 8 types of fixed server level roles which are used to divide the functionality or work among the administrators .

Once the login is created it can't perform any task by default .

Role is nothing but collection of privileges.

1. System Admin

  Member of System Admin role can perform any activity on the server .

2. Server Admin 

  Member of Server Admin role can set server level settings using sp_configure procedure.

3. Setup Admin

  Member of Setup Admin role can install service packs , hot fixes and can execute scripts submitted by the development members.

4. Security Admin

  Member of Security Admin role can create logins , roles etc.

5. DB Creator

  Member of DB Creator role can create and manage databases and also can restore databases.

6. Disk Admin

  Member of Disk Admin can work with Data and T.Log files .

7. Bulk Admin

  Member of Bulk Admin can perform bulk operations like bcp , import and export etc.

8. Process Admin

  Member of Process Admin can work with processes i.e can kill the process .

Note: You can easily remember this roles with short cut called 4S2DBP.