• Firstly, DONT TYPE IN CAPS, its extremely rude 😉

    To shrink the log file the first step you have accomplished, setting recovery to simple. Next issue the following

    DBCC SHRINKFILE (Logfilename, 1)

    Post back any output

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉