MSSQL shrinking transaction log file

The transaction log file in MSSQL is shrinking.

While the database is up and running, open SQL enterprise management and right-click SID, then select properties, then recovery mode — > change the option from full to simple ( database restart is not required)

Then go back to SID and go to task --> shrink files — > and right-click on the transaction log file to shrink it based on the proportion remaining in database properties.

Please enable full recovery mode once you've finished shrinking.

As is customary, a full backup must be kept.

Shrinking datafiles ---> This is not suggested to be done online because it may slow down the system and need a lot of read / write operations.

edited - MSSQL shrinking transaction log file