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? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions