Post reply

IS Shrink part of Full Backup by default or as an option

  • March 23, 2011 at 2:30 pm

    #1302712

    Prolly not...when I look at the General Tab of properties of the DB I see 119.74Mb of Space Available

    The individual ndf files have restricted growth to 102400 Mb and most of these are within an Mb of that. So it looks like it's got it's 10% of freespace left, although my math is pretty bad so I can't say that with confidence 🙂

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

  • March 23, 2011 at 3:12 pm

    #1302734

    In that case shrinking to 10% free is not going to do anything.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 1, 2011 at 2:16 pm

    #1306689

    I ran the shrink today on my gynormous SharePOint content database and it completed in about 4 minnutes. woot.

    If I wanted to suspend the shrink operation that I initiated via the dbcc shrinkdatabase command, is there another command to submit in order to do this?

    Even as a mother protects with her life
    Her child, her only child,
    So with a boundless heart
    Should one cherish all living beings;

Viewing 3 posts - 31 through 32 (of 32 total)

You must be logged in to reply to this topic. Login to reply