Having some problems with a transaction log. During some large batch loads the log has grown to about 10 GB. It is set to truncate on checkpoint, so the actual space used is back down to less than 200 MB. My question is, how do I shrink the log itself from the file size of 10 GB to, say, 1 GB? I've tried 'backup log stage with no_log', also tried 'dbcc shrinkfile (stage_Log, 1000)', but these don't seem to gain me anything. I'd rather not have to recreate the database to accomplish this.