Thanks for the tip Martin. 

Yeah. I guess I'll play around with the test dev box and then see if it's worth purchasing an ent license.

Thanks for the information.

Thanks for the info.

What about SQL 2005? I have a box running the Dev edition which is supposedly pretty much like Enterprise edition. Thanks.

Thanks Jason!  I'm going to test this out tonight. 

I've tried this in simple recovery mode and executed checkpoint a few hours ago but it's failing because there's no more drive space on the log drive.

This is basically my...

I just tried it after looking it up on MSDN but I'm still getting the message:

The file 'Log1' cannot be removed because it is not empty.

Log1 = .ldf file name.

Hi Paul.  Thanks for the quick reply.  Can you give me more specific instructions?  What's BOL?

The second LDF file's small and there shouldn't be anything in there.  I just want...