ନ୍ୟୁଜ୍

Learn how to shrink a data or log file in SQL Server by using SQL Server Management Studio or Transact-SQL. Shrinking data files recovers space by moving pages of data from the end of the file to ...
Many times the large size of transaction log file (.ldf) in microsoft sql is too big which leads to performance issues and loss of valuable disk space.therefore it's imperative to periodically do ...
This event is not triggered if the log file shrinks because of an explicit ALTER DATABASE statement. Include the Log File Auto Shrink event class in traces that monitor the shrinking of the log file.
So I have a specific database that won't release and shrink its log files. The DB backups are happening successfully, but I still have 4GB of logfiles (and no, this DB does not generate 4GB of log ...
You should be regularly backing up the database and log file which will shrink the log.