To improve performance, you can use the optimize database command to truncate the database transaction log file. You should perform the optimize command regularly and after performing backup and restore on a database.

You can optimize a database by using one of the following tools:

For more information about transaction logs, refer to the following help topic for SQL Server:

The Transaction Log

https://docs.microsoft.com/sql/relational-databases/logs/the-transaction-log-sql-server?view=sql-server-2017