Shrink Database Files in Size Increments

  • Comments posted to this topic are about the item Shrink Database Files in Size Increments

  • If specified @TargetFileSize cannot be reached your script will go into infinite loop.

    --Vadim.

    --Vadim R.

  • 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

    hfreeman@msn.com

    Hank Freeman
    Senior SQL Server DBA / Data & Solutions Architect
    hfreeman@msn.com
    678-414-0090 (Personal Cell)

  • 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

  • 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)

  • Hank - I'm very interested in seeing your version and I appreciate your efforts. I'll email you today.

  • 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