How can I shrink or delete the log files in a MS SQL database?

Question

My .ldf file is over 100 GIGABYTES now. I'd like to delete it, shrink it, whatever so it doesn't take so much space on my hard drive. I get an error when I try to delete it that says "The Primary Data or Log File cannot be removed from a database."

Answer 1

Truncating the transaction log:

BACKUP LOG { database_name | @database_name_var }
{
[ WITH
{ NO_LOG | TRUNCATE_ONLY } ]
}