• Perry Whittle (1/26/2014)


    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

    Perry thanks for the reply,

    My db is already on simple recovery so i will run the command