Shrink Database Files in Size Increments

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Boris Moyse » Shrink Database Files in Size Increments

Shrink Database Files in Size Increments

Rate Topic

Display Mode

Topic Options

Author

Message

borismoyse

Posted Wednesday, February 10, 2010 5:40 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 06, 2013 2:39 PM
Points: 5, Visits: 72

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

Post #863742

rVadim

Posted Tuesday, March 02, 2010 11:04 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 3:12 PM
Points: 890, Visits: 2,070

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

--Vadim.

Post #875393

hfreeman

Posted Thursday, March 04, 2010 1:52 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 18, 2012 9:31 AM
Points: 7, Visits: 26

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

Post #877148

borismoyse

Posted Thursday, March 04, 2010 2:11 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 06, 2013 2:39 PM
Points: 5, Visits: 72

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

Post #877162

hfreeman

Posted Thursday, March 04, 2010 3:20 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, April 18, 2012 9:31 AM
Points: 7, Visits: 26

I have a solution to the @TargetSize in my script... Which I am testing.

Post #877226

borismoyse

Posted Friday, March 05, 2010 10:40 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 06, 2013 2:39 PM
Points: 5, Visits: 72

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

Post #877793

« Prev Topic | Next Topic »

Permissions