On the remote database, run the SQL Remote Message Agent (dbremote) with the -x option and specify a size for the transaction log. This option causes the SQL Remote Message Agent (dbremote) to rename and restart the transaction log when the transaction log exceeds the specified size.

The following command deletes the transaction log when it is larger than 1 MB:

dbremote -x 1M  -c "UID=ManagerSteve;PWD=sql;DBF=c:\mydata.db" 

On the remote database, set the delete_old_logs option to On. Setting the delete_old_logs_option causes the old transaction log files to be deleted automatically by dbremote when they are no longer needed for replication.

A transaction log is no longer needed when all subscribers have confirmed that they have received and successfully applied all the changes recorded in that transaction log file. You can set the delete_old_logs option either for the PUBLIC role or just for the user contained in the dbremote connection string.

The following statement sets the public delete_old_logs option to delete transaction logs that were created more than 10 days ago:

SET OPTION PUBLIC.delete_old_logs = '10 days';