I have a .LDF log file which currently stands at 88GB and still growing.
I found a previous thread on this topic which I think details what I need to do in order to shrink this file:
However, I am literally a beginner on this subject with no SQL experience what so ever.
I tried running this command from "SQLCMD" but it doesn't work, I'm obviously doing something wrong.
I was hoping someone could offer a step by step guide on what I need to do?
For instance, where do i run the command "DBCC SHRINKFILE (<filename>,<target size>, TRUNCATEONLY)"??
SQL Server version is 2005.