• USE database_name

    GO

    DBCC SHRINKFILE(2,1)

    BACKUP LOG database_name WITH TRUNCATE_ONLY

    DBCC SHRINKFILE(2,1)

    The above assume the logfile is file 2.

    SP_helpdb databasename

    Right click db,TASKS,SHRINK change to log and see how much space is actually being used.

    Then click cancel.