• If you are setting up a lot of SQL Express instances it may be worth looking at SQL FineBuild.

    The latest 3.2.0 release detects if Express Edition is being installed and sets up a number of Windows tasks to do the normal database maintenance processes (backups, index rebuild, etc). If an edition with SQL Agent is installed, FineBuild sets up the same tasks to run within SQL Agent.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara