It's not the end of it. Switching to the Simple mode does not turns transaction log off. It only automaticaly clears the transaction log from complete transactions. If you want to limit the size of transaction lo9g, limit the size of transactions.

>
>Setting the Recovery model to Simple, backing up the DB and then shrinking the log did the trick.
>
>Thanks again for all you advice.
>