reduce MSSQL ldf log file size

[RFH Reseller: Rappie]

Hey Guys,

How can I reduce MSSQL ldf log file size?
Its now over 145MB while the row size of the database itself is only 15 MB. Since the whole database size is added to the webspace, this really adds up.

Any clues?

[RFH Reseller: SKILLIT]

Try this:

DBCC SHRINKDATABASE
( 'database_name' [ ,target_percent_free ] )

Full syntax in transactional sql reference.

David.

[RFH Reseller: askjim]

had some probs in past shrinking log files, not sure if the following will help otherwise try www.sqlteam.com

backup log dbname with truncate_only