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 |
|---|---|
Describes starting, stopping, and configuring the SQL Server service. |
|
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. |
|
Describes how to set up failover clustering and database mirroring to maximize database availability. |
|
Describes how client applications connect to an instance of SQL Server and how to configure the client protocols and network libraries. |
|
Describes methods to move large amounts of data in or out of the database. |
|
Describes how to protect your data against hardware failure by using the SQL Server backup and restore system. |
|
Describes how to use SQL Server Agent to automate administrative tasks. |
|
Describes how to evaluate system performance, and identify and remove system limitations. |