Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By : Satya Shyam K Jayanty
Book Image

Microsoft SQL Server 2008 R2 Administration Cookbook

By: Satya Shyam K Jayanty

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2008 R2 Administration Cookbook
Credits
Foreword
About the Author
Acknowledgment
About the Reviewers
www.PacktPub.com
Preface
More DBA Manageability Best Practices

Designing maintenance tasks on a mission-critical environment


The key responsibility for a database administrator is to handle the data recovery strategy. There are varieties of tasks included in a Disaster Recovery (DR) plan that allows the restore of databases with minimum data loss The architecture and mechanics of backup and restore operations are fundamental to the maintenance task process.

SQL Server includes maintenance plans that provide various database maintenance tasks including backup, optimization, and integrity checks. There are multiple backup options available such as full database backup, differential backups, and transaction log backups. Similarly, the database optimization tasks - reorganizing and rebuilding of indexes-are essential to keep up the performance in addition to the integrity checks such as database consistency checks (DBCC). Database maintenance plans have been an integral part since SQL Server version 6.5 and are executed and scheduled using the SQL Server...