• if you dont want the log keep the DB in Simple recovery.

    why are you switching it to simple and full.

    is this simple but if you dont have full backup you may lose all the data in case of failure.

    please go through the comments posted by others and gails article is nice.

    Regards
    Durai Nagarajan