Hi

Change your recovery option to Simple this will prevent the log from capturing all the data and filling up

this option should only be used if there is no transactional...