Clear Transaction Log From SQL Server Database
Join the DZone community and get the full member experience.Join For Free
Clear the transaction Log if you are facing a low disk space on the database server. To truncate log, use the following commands:
DBCC SHRINKFILE('logfilename', 1) BACKUP LOG redeoba WITH TRUNCATE_ONLY DBCC SHRINKFILE('logfilename', 1)where log filename is usually database name, i.e., northwind.log. Spring Framework
Opinions expressed by DZone contributors are their own.