Make sure the log has been backed up first or set the recovery model to simple.

This will allow the log file to be shrunk to a size smaller than the...