Alright, so if that is the case, there is no harm in using Truncate over Delete to clear out a large table that needs to be reloaded.

That's what I wanted...

I agree with you, but if you wanted to do a point-in-time restore at 12:03, would the table be truncated or would the log not restore because Truncates are minimally...

I am not talking about Truncating the log file, I am asking if you use the Truncate statement to Truncate a table, does it break your point-in-time recovery.

I realize...

Can someone confirm Franks statement for sure.

Thanks

We are using SQL Server 2000 Enterprise Edition. What I don't exactly understand is that the article you pointed me to says not to use AWE if you have 4GB...

John, hey great thinking. Thanks for the tip. I just needed a way so the logs didn't get so big. This will definitley help. Ugly, but gets the job done....

The database is set to SIMPLE mode right now. I do not have an additional 7 gig that I can put half the data into and then delete the original...

I have found the answer. First off, I believe the Everyone group should be added to the ReportManager folder. That is how it is on a fresh install. So I...

Thanks for the suggestion. I will definatley check that out.

I was wondering if the max worker thread setting would help. I had read that if you have more than 255 connections that you could bump it up. But I...

Our application is a think client bought from a vendor and we don't have much control over it. I am sometimes timing out in QA with a query to a...

This problem is really crazy. It works most of the time. I just tried every possible combination of saving a file from QA and now can't reproduce the problem.

Could it...

When it happens, we are saving to a directory that .sql files already exist in and you can do the Save several times. It seems to be saving a file...

I have tried to use the sp_force_shrink_log SP in the past and it seems to work but takes quite a while on really large databases. Step 2 does cut the...

I just didn't want the vendor to have to deal with stuff that they don't need to. It leaves a little more room for error.

Thanks though.