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.