For Sql Server 2005
BACKUP LOG
[DBNAME]
WITH TRUNCATE_ONLYDBCC SHRINKFILE(
[DBNAME]
_log)For Sql Server 2008
ALTER DATABASE [DBName]
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (DBName_log, 1);
GO
-- Reset the database recovery model.
ALTER DATABASE [DBName]
SET RECOVERY FULL;

Venkatesan JayakanthamPosted Jun 3, 2010, 8:38 PM
Manish, In addition to this, we should change the recorvery model of the database to simple recovery model before the above command execution. After the log file, we need to change the database to full recover model. Cheers, Venkatesan Prabu .J http://venkattechnicalblog.blogspot.com/