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:
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)