Home Forums SQL Server 2005 Backups SQL LiteSpeed Backup job failing intermittenly RE: SQL LiteSpeed Backup job failing intermittenly

  • Did you check the memory use when you are running backups and other batch processes? You need to set your max memory use to take these into account.

    If you have done this and 13GB looks OK, then it probably is. Just remember that if extra software is added to the server (including Windows, SQL and anti-virus fixes) or you add lots of new batch tasks then you should review the SQL max memory limit to see if it is still OK.

    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