SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Boris Moyse / Shrink Database Files in Size Increments / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 11:25:04 GMT20RE: Shrink Database Files in Size Incrementshttp://www.sqlservercentral.com/Forums/Topic863742-2618-1.aspxHank - I'm very interested in seeing your version and I appreciate your efforts. I'll email you today.Fri, 05 Mar 2010 10:40:04 GMTborismoyseRE: Shrink Database Files in Size Incrementshttp://www.sqlservercentral.com/Forums/Topic863742-2618-1.aspxI have a solution to the @TargetSize in my script... Which I am testing.Thu, 04 Mar 2010 15:20:21 GMThfreemanRE: Shrink Database Files in Size Incrementshttp://www.sqlservercentral.com/Forums/Topic863742-2618-1.aspxVadim, thanks for pointing that out. I can see how that could be a problem for some but not sure yet how to address that in the script....I'll try at some point to spend some time working on that.In most cases, the DBA running a shrink operation would check ahead of time what a reasonable/reachable target size would be. I guess because I assumed this, I never thought of what would happen by setting a unreachable target size.thanksThu, 04 Mar 2010 14:11:02 GMTborismoyseRE: Shrink Database Files in Size Incrementshttp://www.sqlservercentral.com/Forums/Topic863742-2618-1.aspxBoris and Others.Boris, I have taken your concept and fixed at few issue as already reported and have put in some new features. So before I post them on the board as a full script and associated SP, Id like to run them by you and others, I want to discuss my enhanced that are to my needs.Currently, I am shrinking a 150GB allocated down to 10% above the actual size, which is 53GB, so I am breaking at 58GB... You get the idea.Anyway, here is my email address, if you or others choose to directly communicate with me, prior to posting my version of what I am testing. Hank FreemanSenior Systems, Database/Data Warehouse Architecthfreeman@msn.comThu, 04 Mar 2010 13:52:41 GMThfreemanRE: Shrink Database Files in Size Incrementshttp://www.sqlservercentral.com/Forums/Topic863742-2618-1.aspxIf specified @TargetFileSize cannot be reached your script will go into infinite loop.--Vadim.Tue, 02 Mar 2010 11:04:20 GMTrVadimShrink Database Files in Size Incrementshttp://www.sqlservercentral.com/Forums/Topic863742-2618-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Maintenance/69524/">Shrink Database Files in Size Increments</A>[/B]Wed, 10 Feb 2010 17:40:44 GMTborismoyse