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.