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