Managing Databases

Database Administrators perform several tasks while maintaining databases that have been deployed to instances of the SQL Server Database Engine.

DDL Triggers

Describes using Data Definition Language (DDL) triggers to perform administrative tasks such as auditing and regulating changes to the definitions of database objects.

Transaction Log Management

Describes the architecture of transaction logs and how to manage them. Transaction logs are a key component used to back up and restore databases.

Backing Up and Restoring Databases in SQL Server

Describes how to set up and test a backup and restore plan to help protect against the loss of data.

Rebuilding System Databases

Describes how to rebuild the system databases, such as when changing the default collation for an instance of the Database Engine.

Importing and Exporting Bulk Data

Describes several mechanisms that can be used to move large amounts of data into or out of a database.

Copying Databases to Other Servers

Describes how to copy a database from one instance of the Database Engine to another, such as when establishing a test or reporting server.