I can't figure out how to shrink the size of the databases ldf file.
The DBA says I should use
backup log dbname with truncate_only
And while that looks like it executed correctly in SQL Query Analyzer the ldf file is still over 2 Gb.
**Clarification based on some comments and some answers below.***The specific database in question is a database is on my laptop and I use it for development processes only. The log file was growing to a point where the looked to cause a full disk. There is no production risk involved. I understand that the method in the question I asked and the answer I accepted are risky in a production environment.*
