• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

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