You need to truncate the log (it is best to make a back up first). You can do this through Enterprise Manager by shrinking the database or look up on in SQL Server Help file -- Books on Line (BOL) and search for truncate log for what to do in Query analizer.