Dave,

You are correct that does solve the transaction log problem for now, but how can he avoid the transaction log from getting away from him again? 

Verify this, I am not...

Emir Sadikovic has the best idea here.  Create a backup device.  Select your database and look under management.  From there you can create a backup...

Thanks for the responses. I am working through them as we post and will respond with what works and what doesn't work for my situation. You will be...

Thanks for the responses. I am working through them as we post and will respond with what works and what doesn't work for my situation. You will be...

Tony,

Thanks for the reply, but the server is already set to mixed mode.