Thanks to everyone who replied.

Using a combination of the suggestions, the log file has been successfully truncated to a more appropriate size.

Pankaj;

Reccovery Model - Full

Initial size - not to sure how to identify this

Growth - Automatic by 10% unrestricted,

dbcc sqlperf(logspace)

    Database Name Log Size (MB) Log Space Used (%) Status     ...

I have tried as you suggested, but it only appeared to remeove a small percentage of the log file (maybe todays transactions ?).

The log file still remains abnormally large.

Thanks for...