If I am reading you correctly, this should do what I need:

USE CHEMPAXDW

GO

DBCC SHRINKFILE('CHEMPAXDW_Log', 10000)

BACKUP LOG WITH TRUNCATE_ONLY

DBCC SHRINKFILE('CHEMPAXDW_Log', 10000)

GO

Wow. That could be a problem. The whole issue here is that there is no disk space. I don't have a place to back it up to.

I ran the SHRINK statement, but it only saved me 5 GB. I need to do the Truncate thing first.

I know this sounds weird, but I have spent...

Helpful article, Lynn, but reading it makes me think we need to stay in Full Backup mode.

Ok, thanks. I am still unclear on much...

OK, thanks, both of you.

I have some follow-up questions, though. I just want to be very clear before I do something drastic.

1. If I run the command using Judy's...

I tell you, after working with SSRS for a few months, I thought I had a handle on it, but I am not getting what anyone is saying, and I'm...

Ok, I added a parameter, set it to Boolean, put in a value of Fields!Agencies.Value (as the name of the field I am trying to affect is "Agencies") and I...

Bob:

Thanks. I am not clear on what you said here regarding the boolean parameter. I don't see where to add one in the textbox properties box. I also see a...

Yes, I'm using Reporting Services.

I understand I have to to create something that will truncate for display, and then show the whole thing, as you suggest. I guess what I'm...