Hi, You Can use this Stored Procedure for replicated Database or otherwise Database. In your case is necessary Add Schedule Job to execute.

use MyDataBase

go

dbcc shrinkfile ('MyDataBase_log',emptyfile)

go

CREATE PROCEDURE TRANSACTION_LOG_SHRINK

AS...