![[Table of Contents]](/dwicons/b_toc.gif)
|
Introducing Sybase Workplace SQL Server
|
System Administration
The term system administration refers to an assortment of tasks including, but not limited to, managing SQL Server's physical storage, creating and backing up databases, creating user accounts, granting permissions, and running diagnostic and repair functions.
The user responsible for system administration is the SQL Server System Administrator, who may or may not be the same individual or individuals who are system administrators for the server machine's operating system. For SQL Server, the System Administrator can log in to SQL Server as the special, predefined user "sa" and knows the system administrator password. The "sa" account has special privileges not held by normal users. The system administrator can grant other users permission to perform certain system administration tasks.
SQL Server Manager allows you to execute the most common system administration tasks through a graphical interface. Some tasks must be executed using Transact-SQL commands or SQL Server utilities directly. See the SQL Server Manager User's Guide for information about SQL Server Manager and the System Administration Guide and the Performance and Tuning Guide for complete information about SQL Server system administration.
![[-]](/dwicons/i_colpse.gif)