Shrink an LDF file?
Back when I was less old, and less bitter and twisted, I remember asking the boss how to shrink an LDF file on an older version of MS SQL.
His response was that I should stop the server instance and delete the LDF file, then restart the service, and it should create a new smaller one...
So I did...
Good thing I copied the LDF file to another location, 'cos when I tried restarting the service it wouldn't come back up, and it definitely didn't create a new fresh transaction log like he said it would!
Biting the hand that feeds IT
