This post of is part of my Install SharePoint 2013 Three-tier Farm project.
A clean SQL Server maintenance plan should include three processes, backup, integrity check and index optimize.
You could simply set up a SQL Server maintenance plan within the SQL Server management studio. But be aware that there are better solutions, E.g. Ola Hallengren’s SQL Server Maintenance Solution is my absolutely favourite.
Ola Hallengren is a Microsoft MVP who has simplified the installation of SQL Server maintenance plans. There are many other MVP’s who even recommend his solutions over the SQL Server management solution:
Ola Hallengren publishes a free set of database maintenance scripts that are like maintenance plans that went to college, married into a nice family, and went to training school afterwards.
However the installation of the SQL ServerMaintenance Solution is very easy. A little bit more difficult is the scheduling, that’s why I create a clone repository for Ola’s SQL scripts and added and example of how to schedule these jobs.
You’ll find the repository on GitHub: https://github.com/janikvonrotz/SQL-Server-Maintenance