Thanks a lot you guys =)

anyone??

Thanks guys!

I just have 1 more question.

The boss said we can rewrite the DTS in SSIS or run DTS under SQL2000 DTS runtime

What does he mean to run DTS under...

Thanks again =)

You guys should get paid for this 🙂

Well I think he means for sys.databases log_reuse_wait_desc

NOTHING - doesn't reuse and just keeps adding to the log file (please correct me if i'm wrong)

LOG_BACKUP - backs up the...

hi Guys,

It turns out that the simple recovery mode isn't good enough. The boss wants to know if you can reuse the logs without backing them up. I'm not sure...

Thanks a lot you guys!!! 🙂

Thanks for your quick reply.

I don't think this DB is in production. It's in a test environment and I need to do what you said. Change to simple recover mode...

Thanks for all your help guys! I appreciate it very much

No one???