February 10, 2010 at 5:40 pm
Comments posted to this topic are about the item Shrink Database Files in Size Increments
March 2, 2010 at 11:04 am
If specified @TargetFileSize cannot be reached your script will go into infinite loop.
--Vadim.
--Vadim R.
March 4, 2010 at 1:52 pm
Boris 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 Freeman
Senior Systems, Database/Data Warehouse Architect
Hank Freeman
Senior SQL Server DBA / Data & Solutions Architect
hfreeman@msn.com
678-414-0090 (Personal Cell)
March 4, 2010 at 2:11 pm
Vadim, 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.
thanks
March 4, 2010 at 3:20 pm
I have a solution to the @TargetSize in my script... Which I am testing.
Hank Freeman
Senior SQL Server DBA / Data & Solutions Architect
hfreeman@msn.com
678-414-0090 (Personal Cell)
March 5, 2010 at 10:40 am
Hank - I'm very interested in seeing your version and I appreciate your efforts. I'll email you today.
May 19, 2016 at 7:15 am
Thanks for the script.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply