I have found a solution as follows:
Here’s the quick fix…
1) Backup the log file by right clicking on the database and selecting backup
2) Set the Config database to simple recovery model (Right Click on database / properties / options)
3) Right click on database and select Tasks/Shrink/Files and select file type = log, action = release unused space
Reset back to full recovery model, if desired.
Powered by www.itgroove.net
Sponsored by Major Change (.com) – The Online Change Register