Shrink Transaction Logs
Running the following code truncates the transaction log. A full database backup should be run after this script to insure point of time recovery in any production environment.
USE
GO
BACKUP LOG <DB> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TLOGNAME>, 1)
GO
-- New way
use
ALTER DATABASE SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(, 1)
ALTER DATABASE SET RECOVERY FULL WITH NO_WAIT
ALTER DATABASE
DBCC SHRINKFILE(
ALTER DATABASE
Shrink Transaction Logs
Shrink the trans log for sql 2k or sql 2k5 (force)