In SQL Server 2005 we could use "BACKUP LOG WITH TRUNCATE_ONLY" however TRUNCATE_ONLY is no longer supported in SQL 2008. You do not have to worry if your databese in simple recovery mode because SQL Server 2008 takes care of truncating the logs for you. If your database is in bulk-logged or full recovery model then schedule transaction log backup on regular interval and you will need to use "dbcc shrinkfile (DBName_Log,10)" to shrink the actual file size. [More]

If you do not want to strugle with cursors to delete duplicate records I have a simple solution for you. For this you must have a primary key or a unique key that has auto increment. [More]