Post reply

Howmuch additional approx. disk space required for SQL7 to SQL 2000 Upgrade?

  • July 29, 2005 at 1:17 pm

    #102675

    Howmuch additional  disk space required for SQL Server 7.0 to SQL 2000 Upgrade in approximate?

    From BOL , I found that for SQL 6.5 to SQL 2000 Upgrade

    "Estimate the disk space required. In addition to the hard disk space used by Microsoft SQL Server 2000, you need approximately 1.5 times the size of the SQL Server 6.5 databases."

    Appreciate your views.

    S SIVAPRASAD

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • August 1, 2005 at 12:54 am

    #578423

    I can't say anything about that figure, or give any other general figure, but I can give a warning though. In 6.5, fixed-length fields that was set to NULL only used two bytes storage size. In 7 (and later) they will instead be stored using the same number of bytes as a non-NULL value of the same type. So if you have a char(100) somewhere containing a lot of NULL values, then watch out for the increased storage size required for this.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

Viewing 2 posts - 1 through 1 (of 1 total)

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