What is the best way to shrink a log file without breaking the log chain? I realize you can do something like:
alter database yourDb set recovery simple go dbcc shrinkfile(LogFileName, 0) go alter database yourDb set recovery full go
But I really don't want to break the log chain. Is there any way to accomplish this?