Overview of Administering SQL Server

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.
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.
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.
Using the Web Assistant Wizard Explains how to use the wizard to create Web pages.
Migrating from Other Products to SQL Server Explains how to tranfer data and objects from another database management system (DBMS) to SQL Server.


(c) 1988-98 Microsoft Corporation. All Rights Reserved.