O'Reilly logo

Practical Maintenance Plans in SQL Server: Automation for the DBA by Bradley Beard

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

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

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