Practical Maintenance Plans in SQL Server: Automation for the DBA

Index

A, B

1. Backup Cleanup task

   1. delete backup file

      1. based on extension

      2. specific file

   2. maintenance tasks

   3. plan properties

2. Backup Database task

3. B-Tree structures

4. Bulk Logged Recovery model

C

1. Check Database Integrity task

D

1. Database administrator (DBA)

2. Database backup

   1. backup types

      1. absolutely ideal

      2. differential

      3. full

      4. ideal setting

      5. vs . recovery models

      6. transaction log

   2. maintenance plan

      1. differential backup configuration

      2. full backup configuration

      3. job properties

      4. transaction log backup configuration

   3. recovery model

      1. vs . backup types

      2. bulk logged

      3. full

      4. simple

   4. recovery models

3. Database Consistency History report

4. Database integrity

   1. database consistency report

   2. definition

   3. maintenance plan

      1. check integrity task

      2. job schedule

      3. maintenance tasks

      4. plan properties

      5. report options

      6. SQL Server Agent

      7. wizard

   4. structural integrity ...