Freeing the log will not always succed because the 'loose' space is not at the end.

I allways use the following script to get the job done:

   SET NOCOUNT ON

   DECLARE...