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.
In This Section
Managing the SQL Server Utility
Describes application and multi-server management for SQL Server.Managing Data-tier Applications
Describes managing a data-tier application (DAC), an entity that contains all of the database and instance objects used by an application.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.