Thursday, November 1, 2007

SQL Maintenance Plan Wizard at MSDN

Maintenance Plan Wizard

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.

Maintenance plans only run against databases set to compatibility level 80 or higher. The Maintenance Plan Wizard does not display databases set to compatibility level 70 or lower.

No comments: