You can Use the following Query to Shrink the Log File.

USE DatabaseName

GO

DBCC SHRINKFILE(<TransactionLogName>, 1)

BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY

DBCC SHRINKFILE(<TransactionLogName>, 1)

GO

For More Info Please Read : http://blog.sqlauthority.com/2006/12/30/sql-server-shrinking-truncate-log-file-log-full/

I want to share this across as I recently faced issue. Today in morning when I tried to connect to database server, I find it in suspect mode. At this...