• Hi Simon,

    Thanks for such a nice explaination. I have some diffrent case hope you will give suggestion for this.

    I did logShipping for a large database now the file size increased vastly so i have used shirnkfile with truncate only option so that my logshipping will not disturb. but size of ldf file increase up to 40 to 60 GB.

    Any idea or guidance to reduce the file size without affecting LogShipping.

    Thanks

    Raj

    Taking frequent t-log backups using log shipping should reduce/stop ldf growth.

    Shrink of log file doesnt distrub log shipping.