Backups 4: Setting Up Ola Hallengren’s Maintenance Scripts
If you’re a full time database administrator, then rather than using maintenance plans, you should upgrade to Ola Hallengren’s maintenance scripts. They’re free, open source, and are used all over the world to do powerful, configurable maintenance tasks. For support and feature requests, head to Ola’s Github repository.