Post reply

Upgrade Standard Edition to Enterprise Edition

  • December 10, 2004 at 9:28 am

    #85021

    I have two servers that I need to upgrade from SQL 2K Standard to SQL 2K Enterprise edition so that I can use log shipping.  What is the best method to go about this?  Detach databases, uninstall standard then install Enterpise and then reattach databases??  Or can you run install from the CD and just upgrade?

    Thanks

  • December 10, 2004 at 9:47 am

    #533375

    I have only downgrade so in my experience, the first option sounds right.

     

    mom

  • December 10, 2004 at 9:53 am

    #533377

    I am agree. And a little note. Don't try to restore msdb or master databases, you can attach or restore only users databases. You have to recreate logins, jobs, etc. with scripts.

  • December 10, 2004 at 5:51 pm

    #533421

    Check the article below. It talks about upgrading Personal edition to Enterprise edition.I believe you can use the same process for upgrading to enterprise edition from standard edition. Make sure you have a good backup of your data.

    http://www.windowsitpro.com/Article/ArticleID/20246/20246.html

  • December 13, 2004 at 5:09 am

    #533483

    Using the CD, I successfully upgraded from Standard Edition to Enterprise Edition.  Thanks for the replys.

Viewing 5 posts - 1 through 4 (of 4 total)

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