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.

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.

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.

Concepts

Other Resources

Help and Information