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

  5. Database maturity

  6. DEVTEST

  7. Differential backups

  8. Distribution statistics

    1. description

    2. maintenance task

      1. plan properties

      2. report options

      3. scan type

      4. SQL Server Agent job

      5. task order

      6. update statistics task

      7. update type

      8. wizard progress

E

  1. Execute SQL Server Agent Job task

  2. Execute T-SQL task

F, G

  1. Full backups

  2. Full Recovery model

H

  1. Heap table

  2. History Cleanup task

I, J, K

  1. Index

    1. B-Tree structures

    2. categories

    3. clustered indexes

    4. definition

    5. delete object

    6. maintenance plans

    7. new index

    8. nonclustered indexes

    9. primary key index

    10. properties

    11. rebuilding vs . reorganising

    12. storage option

  2. Interface

L

  1. Logs Cleanup task

    1. maintenance task

    2. plan properties

    3. report options

    4. SQL server agent jobs

    5. wizard progress

M, N

  1. Maintenance Cleanup task

    1. backups cleanup task

    2. vs . history cleanup tasks

    3. logs cleanup task

    4. maintenance plans

    5. text files cleanup task

  2. Maintenance plan

    1. Backup phase

    2. complexity

    3. creation

    4. database backup

      1. differential backup configuration

      2. full backup configuration

      3. job properties

      4. transaction log backup configuration

    5. database integrity

      1. check integrity task

      2. job schedule

      3. maintenance tasks

      4. plan properties

      5. report options

      6. SQL Server Agent

      7. wizard

    6. database maturity

    7. DBAs

    8. description

    9. design surface

      1. task options

      2. vs . wizard interface

    10. DML statements

    11. indexes

    12. planning

    13. Post-Backup phase

    14. Pre-Backup phase

    15. precedence constraints

      1. constraint options

      2. editor

      3. full backups

      4. multiple constraints

    16. principles

    17. reorganising indexes

    18. set up

    19. SQL Server Agent jobs

    20. SQL Server Integration Services package

    21. structure

    22. testing

    23. T-SQL Script

      1. export package

      2. import package

      3. Integration Services Maintenance plan

      4. Job Activity Monitor

      5. query results

      6. SQL Server Agent jobs

      7. subplan properties

      8. update statistics plan

    24. wizard interface tasks

O

  1. Notifying database operators

    1. maintenance plan

      1. Local server connection

      2. Net Send operator

      3. Notify Operator task

      4. Pager operator

      5. SQL Server Agent job

      6. subplan properties

    2. operator profile

      1. configuration task

      2. maintenance plans

      3. profile security

      4. SQL Server Agent jobs

  2. Notify Operator task

P, Q

  1. Pager Operator

  2. Precedence constraint

  3. Primary key index

R

  1. Rebuild Index task

  2. Rebuilding indexes

  3. Reorganize Index task

  4. Reorganizing indexes

    1. maintenance plans

      1. plan properties

      2. report options

      3. SQL server agent jobs

      4. task order

      5. wizard progress

    2. vs . rebuilding

S

  1. Shrink Database task

    1. disk space considerations

    2. disk usage report

    3. Maintenance plans

      1. plan properties

      2. report options

      3. SQL Server Agent jobs

      4. task order

      5. wizard progress

    4. transaction log

  2. Simple recovery model

  3. SQL Server Agent jobs

    1. advanced option

    2. alerts option

      1. SQL Server event alert

      2. SQL Server performance condition alert

      3. WMI event alert

    3. Alerts page settings

    4. Alerts tab

      1. General

      2. Options

      3. Response

    5. Backup Maintenance Plan

    6. differential backups

      1. check integrity task

      2. reorganize index task

      3. shrink database task

      4. update statistics task

    7. disable jobs

    8. distribution statistics

    9. editing

    10. e-mail

      1. account settings

      2. configuration task

      3. configuration wizard

      4. enable mail profile

      5. interface options

      6. new profile

      7. profile security

      8. Send Test e-mail

      9. SMTP accounts

      10. in SSMS

      11. system parameters

    11. full backups

      1. bak files task

      2. check integrity task

      3. cleanup history task

      4. rebuild index task

      5. shrink database task

      6. trn files task

      7. txt files task

      8. update statistics task

    12. general option

    13. General page settings

    14. Gmail’s SMTP

      1. account setting

      2. configuration wizard

      3. database mail account

      4. forwarding and POP/IMAP

      5. manage profile security

      6. profile setting

      7. server access

      8. system parameters configuration

      9. testing

    15. job creation

    16. notifications

    17. Notifications page settings

    18. Notifying database operators

    19. query

    20. schedule needs

    21. Schedule page settings

    22. schedules option

    23. shrink database

    24. steps option

    25. Steps page settings

    26. sysjobschedules

    27. table creation

    28. targets

    29. Targets page settings

    30. transaction log backups

      1. check integrity task

      2. shrink database task

      3. update statistics task

    31. transaction log backupsreorganize index task

    32. TRUNCATE and DELETE FROM

    33. T-SQL Statement execution

  4. SQL Server Agent logs, cleanup

    1. history cleanup tasks

    2. maintenance plan

      1. job schedule

      2. plan properties

      3. wizard progress

    3. report options

    4. tasks

      1. maintenance task order

      2. maintenance tasks

T

  1. Text Files Cleanup operation

    1. maintenance tasks

    2. plan properties

    3. report options

    4. SQL server agent jobs

    5. wizard progress

  2. Transaction log

  3. Transaction log backups

  4. T-SQL Statement execution

    1. click and drag technique

    2. maintenance plan

      1. Alerts tab

      2. design surface

      3. job properties

      4. Log File Viewer

      5. Notifications tab

      6. Schedules tab

      7. source types

      8. SQL Server Agent jobs

      9. SqlStatementSourceType

      10. Start jobs

      11. Steps tab

      12. subplan properties

      13. Targets tab

      14. toolbox

      15. T-SQL plan

U, V

  1. Update Statistics task

W, X, Y, Z

  1. Windows Management Instrumentation (WMI)

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.224.59.145