• If you are having to shrink files because you are running out of disk space then you need to get more disk space. Repeated shrink and grow of database files will harm your performance, whatever the reason is for why you are doing it.

    If your log file is growing 'too big', how often are you doing a log backup? You may find that doing a log backup every 3 hours (or more often if needed) will stop your transaction log getting 'too big'.

    If you are using Full Recovery or Bulk Logged Recovery, then you need to do log backups as well as database backups. Books Online (BOL) explains why this is necessary, and there are lots of forum posts on this subject you can find with Google.

    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