Is there a way by which I can delete periodically the LDF file generated as it takes upto 100 gb of my space and I want to free that space.
Is there a way a procedure can be written that periodically deletes this LDF file?