6 thoughts on “SQL Server Quickie #16 – Database Shrink Operations”

1. 

   mashrur shuvo

   08/25/2014 at 1:29 PM

   Hi Klaus,

   Your Free Videos are very help full.

   Mashrur

   Reply
   1. 

      Klaus Aschenbrenner

      08/26/2014 at 8:46 AM

      Hello Mashrur,

      Thanks for the nice feedback 🙂

      Best regards,

      -Klaus

      Reply
2. 

   Vinh Phan

   08/27/2014 at 1:29 PM

   Thank Klaus very much, all video and articles are very useful. I love it so much

   Reply
   1. 

      Klaus Aschenbrenner

      08/27/2014 at 2:06 PM

      Hello Vinth,

      Thanks for the great feedback!

      Best regards,

      -Klaus

      Reply
3. 

   Mark Workman

   07/10/2015 at 3:04 PM

   We have 250GB of images that have been added into the database over the last 10 years. We would like to remove the images from the database and link to files in a filesystem.
   Our data size would go from 275GB to 50Gb or so. We will not be adding images further so it will grow more slowly. The images are the only thing in tha Secondary filegroup. Would we not want to reclaim the space in some way?
   Thanks
   Mark

   Reply
   1. 

      Klaus Aschenbrenner

      07/10/2015 at 4:53 PM

      Hello Mark,

      Thanks for your comment.
      Of course, in that case you can run a Shrink operation.
      Shrinks are not always bad, but you have to be aware of the side-effects – like index fragmentation.

      Thanks,

      -Klaus

      Reply