Managing Databases

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

In This Section

  • 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.