Is there a way to shrink a large log file? I was asked to look into why a .log file from an SQL Server 2005-08 DB was large. I thought at first that maybe it's holding data that was never written or commited to the .mdf file. But I'm not sure if there is a way that I can view .log file data. So I guess I need to determine if the data in the .log file is needed before I shrink it. Can someone tell me the proper way to go about this?
Thanks in advance!!