Automatically Truncate MS SQL Log Files?

[eugenevdm]

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)

 

[eugenevdm]

**** bump ****

 

[eugenevdm]

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:

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