• Sorry Steve I had a hard day yesterday, You must be one of the lucky ones.

    More than once I have had problems with databases that are in full recovery that the log files do not whant to shrink no matter what you try until you 'reset' their recovery. This has remained an enigma but the sollution that I suggested has resolved the log file shrinkage in all the cases that I have had.

    I agree with you completely, the way that you suggest is the recommended way, this has not always been the successfull in my case. But this should solve the problem in more than 80% of the cases.

    I appologise again.

    Lukas

    Lukas Botha