Home Forums Article Discussions Article Discussions by Author Discuss content posted by Simon Facer Why SHRINKFILE is a very bad thing, and what to do about it. RE: Why SHRINKFILE is a very bad thing, and what to do about it.

  • November 9, 2010 at 12:01 am

    #1248032

    Simon Facer (11/8/2010)

    Comments posted to this topic are about the item <A HREF="/articles/SHRINKFILE/71414/">Why SHRINKFILE is a very bad thing, and what to do about it.</A>

    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