Administering the Database Engine

The high-performance Database Engine in Microsoft SQL Server 2005 has many self-tuning configuration options. However, database administrators still must configure such aspects as links to other servers in your organization and an effective database backup strategy. This section of Books Online provides information to help you get the best performance out of your database system and to protect your data against hardware failure or natural disaster.

In This Section

Topic Description

Managing the Database Engine Services

Describes starting, stopping, and configuring the SQL Server service.

Managing Servers

Describes managing multiple servers with SQL Server Management Studio, managing memory, configuring the server side of the network connections, linking to other servers, configuring mail for the SQL Server engine, and setting configuration options for the Database Engine.

Configuring High Availability

Describes how to set up failover clustering and database mirroring to maximize database availability.

Client Network Configuration

Describes how client applications connect to an instance of SQL Server and how to configure the client protocols and network libraries.

Importing and Exporting Bulk Data

Describes methods to move large amounts of data in or out of the database.

Backing Up and Restoring Databases in SQL Server

Describes how to protect your data against hardware failure by using the SQL Server backup and restore system.

About SQL Server Agent

Describes how to use SQL Server Agent to automate administrative tasks.

Monitoring and Tuning for Performance

Describes how to evaluate system performance, and identify and remove system limitations.