One of the best maintenance scripts I’ve come across in quite a while, covers the following areas.
- Backup
- Integrity checking
- Optimizing indexes
- Executing and logging commands
- Utility functions
If your using Maintenance Plans, stop now and implement this instead.
Get it here ola.hallengren.com