Practical Maintenance Plans in SQL Server : Automation for the DBA - Beard, Bradley; SpringerLink (Online service) (Berkeley, CA : Apress : Imprint: Apress, 2016)
Introduction -- 1. Backing Up a Database -- 2. Checking Database Integrity -- 3. Executing SQL Server Agent Jobs -- 4. Purging Log History -- 5. Clearing Old Backup Files -- 6. Rebuilding Indexes -- 7. Reorganizing Indexes -- 8. Shrinking Database Files -- 9. Updating Object Statistics -- 10. Executing T-SQL Statements -- 11. Notifying Database Operators -- 12. Tying It All Together.
Keywords: Database management; Database Management