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.

Read more: http://feeds.dzone.com/~r/dzone/snippets/~3/UBgGtPU64Gk/14191