ldf Log File Size Reduction

[drallabs]

I have a database with a log file (ldf) that has grown to 90gb. I would like to reduce this size of this file. Approximately 99% of this file is used. The Shrink command will not reduce it any lower than 90gb. It seems that there are a bunch of transactions in the log file that need to be purged. I dont need the transactions they are no longer needed. How do I reduce the content of this file so I can free up used disk space?

Thanks

 

[SQLDenis]

backup log dbname with truncate_only

followed by a dbcc shrinkfile

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[SQLSister]

Followed by setting up the transaction log to back up periodically or it will just grow this big again.

"NOTHING is more important in a database than integrity." ESquared