Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Managing Databases

SQL Server 2008 R2

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.