• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Automatically Truncate MS SQL Log Files?

eugenevdm

Regular Pleskian
How can I automatically truncate the MS SQL log files on all our Plesk servers? The problem is these files grow infinitely and then client moan because they get traffic warning.

Ideally I want to put a limit on this or automatically truncate them on a regular basis. We have quite a few servers so automation is essential. Maybe there is some default I can change?

For now I have to manually log in to the server and do this:
declare @dbname nvarchar(255)
set @dbname = 'db_name'
backup log @dbname with truncate_only
DBCC SHRINKDATABASE (@dbname, 0)
 
Just a minor update. Plesk allows log files to grow to 2 GB by default on MS-SQL.

On SQL 2008 you have to do:

Code:
declare @dbname nvarchar(255)
set @dbname = 'bigboysdb'
backup log @dbname to disk='NUL'
DBCC SHRINKDATABASE (@dbname, 0)
 

Similar threads

Back
Top