Administering SQL Server
Administering SQL Server Overview
Microsoft® SQL Server™ 2000 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 how to start an instance of SQL Server, and what you need to do before, during, and after you log in. |
| Failover Clustering | Describes how to set up and use a failover cluster. |
| Importing and Exporting Data | Describes how to retrieve data from external sources and feed data to other applications. |
| Backing Up and Restoring Databases | Describes how to protect and restore data over a wide range of potential system problems. |
| Using the Copy Database Wizard | Describes how to copy or move databases between servers and upgrade databases from SQL Server version 7.0 to SQL Server 2000. |
| Managing Servers | Describes how to register and configure remote and linked servers, add or remove servers, and modify server settings. |
| Managing Clients | Describes how to configure client 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. |
| Using the Web Assistant Wizard | Explains how to use the wizard to create Web pages. |