Post reply

Edition Upgrade from 2008 R2 Express to Workgroup Edition, 10 GB limit

  • April 23, 2012 at 5:33 am

    #255239

    Hi all,

    I have a customer that has run into the 10 GB limit of SQL Server 2008 R2 Express. We saved a few hundred MBs by deleting some BAK / TMP / SAV and other unimportant tables.

    Now the customer has decided to buy Workgroup Edition. I'd like to use SQL Server Installation Center and there

    --> Maintenance

    --> Edition Upgrade

    to to the upgrade.

    Question: will this be sufficient to get rid of the 10 GB limit or must I do anything else? ("Upgrade" the database itself, back it up and re-create from backup or whatever...)

    TIA

    Gerhard

  • April 23, 2012 at 9:34 am

    #1477591

    just upgrading should work after reading the liscense requirements with all I Am Not A Lawyer caveats. however you should back up your master msdb and user databases (Might even take a backup of tmp) before you upgrade incase murphy strikes.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

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

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