MS SQL stores database changes into a log file that as more activity occurs on the database the larger the log file grows. When it comes to disk space limitations and performance this becomes a considerable problem. MS SQL Server provides a command to truncate the log file DBCC SHRINKFILE(<log file>, 0, TRUNCATEONLY) The command … Continue reading Shrinking the Log file