Post reply

Sql server 2008 R2 , Database growth setting

  • February 25, 2013 at 3:11 am

    #268975

    Hi Friends,

    I am observing a around 100 GB growth in the database size due to database growth setting of around GB . Which is fine as per the setting . However this was not the original setting at the time of DB creation. Someone , someday changed it . Can we find this changed date and time? I have tried to create the scenario but not able to find it in database properties window.

    Thanks

    Aslam

  • February 25, 2013 at 3:34 am

    #1590729

    Unless you have some custom auditing implemented to record database property changes, there won't be a record.

    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

  • February 25, 2013 at 4:00 am

    #1590736

    Thanks.

    Aslam

  • February 26, 2013 at 5:49 am

    #1591145

    Hi Friends ,

    Will you please help me on the next steps to recliam the space.As per me :-

    a) Shrink the DB.

    b) Rebuild the indexes.(This will again take some space thats okay ).

    I will first try the steps on some test server and then implement the same on prod .

    Please let me know if i am missing anything.

    Thanks

    Aslam

  • February 26, 2013 at 6:11 am

    #1591157

    Why do you want to remove the free space?

    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

  • February 26, 2013 at 6:15 am

    #1591158

    If I have to restore this copy on other test /dev server , it will require that much space .

    Sometimes the dev/test team asks for multiple copies . In this scenario I will face problem.

    Asking for additional space is a problem at present.

  • February 26, 2013 at 6:27 am

    #1591162

    Then do a once-off shrink, leave enough free space in the database for normal operation, and rebuild all your indexes.

    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

  • February 26, 2013 at 6:44 am

    #1591172

    Thanks Gail. 🙂

Viewing 8 posts - 1 through 7 (of 7 total)

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