locked
Increasing the size of the container in SQL Server 2005 RRS feed

  • Question

  • Hello --

    One of our systems is running SQL Server 2005, and has a database that was initially 'sized out' at thirty, 30, gigabytes. The space that is currently taken up by the database is twenty-nine, gigabytes. We are at a point where resizing the container available to the database is a necessity, and I need feedback on the following:

    We can either manually resize the database to fifty, 50, gigabytes, or let the server automatically do the resizing. The database will continue to grow, but giving it the aforementioned space will give us over three years before we need to consider resizing it again. I am of the opinion the manual approach is the way to go in this scenario, but I wanted to get feedback on this.

    Prior to doing this, we will do a full backup of the database, and after the resizing is done, we intend to run the database consistency checker to verify the change made did not adversely effect it.
    Monday, December 3, 2012 6:06 PM

Answers

  • I am of the opinion the manual approach is the way 

    Hello,

    When you do it manually before it's done automatically, then you can scheduled it for a time, where there is only less workload to avoid timeout/a slow system; you should prefer this way.


    Olaf Helper

    Blog Xing

    • Proposed as answer by Kalman Toth Tuesday, December 4, 2012 12:45 AM
    • Marked as answer by Allen Li - MSFT Tuesday, December 11, 2012 1:49 AM
    Monday, December 3, 2012 8:22 PM
    Answerer

All replies