O'Reilly logo

Microsoft SQL Server 2008 R2 Administration Cookbook by Satya Shyam K Jayanty

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required