Administration (Database Engine)

The high-performance Database Engine in Microsoft SQL Server 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.

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.

DDL Triggers

Describes the function of DDL Triggers as a special kind of trigger that fires in response to Data Definition Language (DDL) statements.

Logon Triggers

Describes logon triggers, which fire in response to the LOGON event.

Connecting to the SQL Server Database Engine

Contains information on installing, enabling, and configuring network protocols on the server and client computers.

Managing the Database Engine Services

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

Transaction Log Management

Contains discussions of recovery models and their impact on transaction log management, managing log space, managing long-running transactions, and the factors that can delay log truncation.

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.

Rebuilding System Databases

Describes how to fix corruption problems in the master, modelmsdb or resource system databases or to modify the default server-level collation.

Importing and Exporting Bulk Data

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

Copying Databases to Other Servers

Contains introductions to alternative ways to copy databases to other servers.

About SQL Server Agent

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

Administering Servers by Using Policy-Based Management

Describes how to use SQL Server Management Studio to create policies to manage entities on the server, such as the instance of SQL Server, databases, or other SQL Server objects.

Administering Multiple Servers Using Central Management Servers

Describes how an instance of SQL Server that is designated as a Central Management Server controls server groups that maintain the connection information for one or more instances of SQL Server.

Administration: How-to Topics (Database Engine)

How to manage services, configure availability, back up and restore databases, manage servers and server connectivity, and configure clients.

Community Additions