Today we are writing about how to shrink the size of a transition log (.LDF) for SQL database. It can cause performance issues, also it will take a lot of valuable disk space and consume resources when you back up. Therefore it's imperative to periodically maintain the database to keep the .ldf file under control.
Just for an example we have SharePoint server; also we have many content Databases and PWA site databases as well which will get increased always which we can control using script.
We need to follow the below steps to complete the task.