CS27510 CS27510 Commercial Commercial

Database Database ApplicationsApplications

MaintenanceMaintenance Disaster RecoveryDisaster Recovery

MaintenanceMaintenance

The Maintenance Plan Wizard helps you set The Maintenance Plan Wizard helps you set up the core maintenance tasks to make sure up the core maintenance tasks to make sure that your database performs well, is that your database performs well, is regularly backed up, and is free of regularly backed up, and is free of inconsistencies. inconsistencies.

The Maintenance Plan Wizard creates one or The Maintenance Plan Wizard creates one or more SQL Server Agent jobs that perform more SQL Server Agent jobs that perform these tasks on local servers or on target these tasks on local servers or on target servers in a multiserver environment. servers in a multiserver environment.

Execution can be at scheduled intervals or on Execution can be at scheduled intervals or on demand. demand.

Some TasksSome Tasks Back Up Database TaskBack Up Database Task

Performs different types of SQL Server database Performs different types of SQL Server database backups.backups.

Check Database Integrity TaskCheck Database Integrity Task Checks the allocation and structural integrity of Checks the allocation and structural integrity of

database objects and indexes.database objects and indexes. Maintenance Cleanup TaskMaintenance Cleanup Task

Removes files related to maintenance plans, including Removes files related to maintenance plans, including reports created by maintenance plans and database reports created by maintenance plans and database backup files.backup files.

Tasks (2)Tasks (2)

Rebuild Index TaskRebuild Index Task Rebuilds indexes in SQL Server database Rebuilds indexes in SQL Server database

tables and views. tables and views. Reorganize Index TaskReorganize Index Task

Reorganizes indexes in SQL Server database Reorganizes indexes in SQL Server database tables and views.tables and views.

Update Statistics TaskUpdate Statistics Task Updates information about the distribution of Updates information about the distribution of

key values for one or more sets of statistics on key values for one or more sets of statistics on the specified databasethe specified database

Disaster RecoveryDisaster Recovery

BackupsBackups FrequencyFrequency Elapsed TimeElapsed Time Full BackupsFull Backups

hourshours Differential BackupsDifferential Backups

shorter than Fullshorter than Full Restoration TimeRestoration Time

Backup StorageBackup Storage

To tapeTo tape Slow but storable off siteSlow but storable off site

To fileTo file LocalLocal FastFast

CombinationCombination Network FileNetwork File Then tape backupThen tape backup

ManagementManagement

Both maintenance and disaster Both maintenance and disaster planning require:planning require: ManagementManagement

Commitment, monitoring and controlCommitment, monitoring and control ProceduresProcedures

Formalise by documentationFormalise by documentation TrainingTraining

For database administratorsFor database administrators