Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Administering SQL Server Overview

Administering SQL Server Overview

SQL Server 2000

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.

© 2015 Microsoft