Maintenance & Disaster Recovery
Transcript Maintenance & Disaster Recovery
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
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
Execution can be at scheduled intervals or on demand.
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
Maintenance Cleanup Task
Removes files related to maintenance plans, including reports created by
maintenance plans and database backup files.
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
shorter than Full
Slow but storable off site
Then tape backup
Both maintenance and disaster planning require:
Commitment, monitoring and control
Formalise by documentation
For database administrators