Looks like that was the answer! It has already dropped from 393MB to 91MB! THANK YOU!

These forums are awesome!!

ok great!

I have tape backups running regularly. And yes I will manually do it now. Then set a plan to backup once a day with int!

Thanks

Integrity of the db or log?

I have no int for the Trans logs.

The database right now is only about 50MB and growing.

Sorry, SQL Server 2000

I have tried resizing (making larger) the File Size of the transaction log. It only continued to grow. And giving me that message when it reached that ceiling.

Backing up transaction...

THANK YOU! Got it.

Cool! Where do I get that neat little tool? (Log explorer)

Great! Thanks, I will give that a try.

Looks like it will be a regular scrub due to imports.

Yeah, I am thinking it's hardware! I am ordering a new server with dual GHz processors and 2GB RAM.

I have some clustered indexes and have defraged the indexes in...

So I should continue to let SQL allocate the memory?

It just appears that retrieving the data is very slow. So the users say.

There are only 20-30 users connected at any time.

But will take a look a those Alert logs! Thanks

I have. Nothing out of the ordinary as far as I can tell. While in task manager -> i look at the momory usage for applications and SQL is by...