SQL Server: Shrink the transaction log On October 14, 2007 By ntanya54In Technology BACKUP LOG database_name WITH TRUNCATE_ONLY USE database_name GO DBCC SHRINKFILE (database_name_log, 1) GO Share this:TwitterFacebookLike this:Like Loading... Related