Microsoft® SQL Server™ administration applications, and the accompanying services, are designed to assist the system administrator with all administrative tasks related to maintaining and monitoring server performance and activities.
| Topic | Description |
|---|---|
| Starting, Pausing, and Stopping SQL Server | Explains starting SQL Server, and what you need to do before, during, and after you log in. |
| Backing Up and Restoring Databases | Describes how to protect and restore data over a wide range of potential system problems. |
| Managing Servers | Describes how to register and configure remote and linked servers, add or remove servers, and fine-tune server settings. |
| Managing Clients | Describes how to configure a client’s connections with server components and change the default network protocol to meet the needs of your site. |
| Automating Administrative Tasks | Describes how to establish which administrative responsibilities will occur regularly, define jobs and alerts, and run SQL Server Agent. |
| Managing Security | Describes how to protect and safeguard database access by restricting permissions to include only authorized users. |
| Monitoring Server Performance and Activity | Describes how to develop a strategy for ensuring that server and activity performance are at acceptable levels. |
| Integrating SQL Server with Other Tools | Describes how to integrate SQL Server with other tools and applications. |