The user does not have backup permission on our production database. He just uses a development database to do his work and we are not concerned if he breaks anything there. I just wanted to verify what I had thought about the With NO_LOG option.

I also don't understand why the transaction log is filling up so fast. I post a new question for that though.