Transcript Maintenance & Disaster Recovery

CS27510 Commercial
Database Applications


Maintenance
Disaster Recovery
Maintenance



The Maintenance Plan Wizard helps you set up the core
maintenance tasks to make sure that your database
performs well, is regularly backed up, and is free of
inconsistencies.
The Maintenance Plan Wizard creates one or more
SQL Server Agent jobs that perform these tasks on
local servers or on target servers in a multiserver
environment.
Execution can be at scheduled intervals or on demand.
Some Tasks

Back Up Database Task


Check Database Integrity Task


Performs different types of SQL Server database backups.
Checks the allocation and structural integrity of database objects and
indexes.
Maintenance Cleanup Task

Removes files related to maintenance plans, including reports created by
maintenance plans and database backup files.
Tasks (2)
Rebuild Index Task


Reorganize Index Task


Rebuilds indexes in SQL Server database tables and views.
Reorganizes indexes in SQL Server database tables and views.
Update Statistics Task

Updates information about the distribution of key values for
one or more sets of statistics on the specified database
Disaster Recovery

Backups
Frequency
 Elapsed Time
 Full Backups



Differential Backups


hours
shorter than Full
Restoration Time
Backup Storage

To tape


Slow but storable off site
To file
Local
 Fast


Combination
Network File
 Then tape backup

Management

Both maintenance and disaster planning require:

Management


Procedures


Commitment, monitoring and control
Formalise by documentation
Training

For database administrators