Using database maintenance plans, we can automate basic database administration activities. Maintenance plans are SQL Server integration service packages which are executed by SQL Server Agent job on configured schedule. Using maintenance plans, we can automate the following tasks.
- Shrink a database
- Backup a database
- Operator notification
- Update database statistics
- Perform database integrity check
- Execute SQL Server Agent jobs
- Execute T-SQL script
- Reorganize or rebuild indexes
Moreover, we can set up an alert to notify a DBA about the status of maintenance plan execution by enabling the Database Mail.
In this article, I am going to explain how to create a basic maintenance plan to perform database consistency check on a user database. Read More