SQL Server Integration Services includes a set of tasks that perform database maintenance functions. These tasks are commonly used in database maintenance plans, but the tasks can also be included in SSIS packages. For more information, see Maintenance Plan Wizard and Maintenance Plans.
The maintenance tasks can be used with SQL Server 2000 and SQL Server databases and database objects.
The following table lists the maintenance tasks.
Performs different types of SQL Server database backups.
Checks the allocation and structural integrity of database objects and indexes.
Runs SQL Server Agent jobs.
Runs Transact-SQL statements
Deletes entries in the history tables in the SQL Server msdb database.
Removes files related to maintenance plans, including reports created by maintenance plans and database backup files.
Sends notification messages to SQL Server Agent operators.
Rebuilds indexes in SQL Server database tables and views.
Reorganizes indexes in SQL Server database tables and views.
Reduces the size of SQL Server database data and log files.
Updates information about the distribution of key values for one or more sets of statistics on the specified table or view.