Practical Maintenance Plans in SQL Server

1. Introduction to Maintenance Plans
Bradley Beard

2. Backing Up a Database
Bradley Beard

3. Checking Database Integrity
Bradley Beard

4. Executing SQL Server Agent Jobs
Bradley Beard

5. Cleaning Up SQL Server Agent History
Bradley Beard

6. Cleaning Up Maintenance Files
Bradley Beard

7. Rebuilding Indexes
Bradley Beard

8. Reorganizing Indexes
Bradley Beard

9. Shrinking the Database and Files
Bradley Beard

10. Updating Object Statistics
Bradley Beard

11. Executing T-SQL Statements
Bradley Beard

12. Notifying Database Operators
Bradley Beard

13. Tying It All Together
Bradley Beard

Avainsanat: Computer Science, Database Management