Database Administrators perform several tasks while maintaining databases that have been deployed to instances of the SQL Server Database Engine.
In This Section
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.