Post reply

Upgarding SQL 2000 Standard Edition to SQL 2000 Enterprise Edition

  • October 31, 2005 at 3:52 am

    #115476

    All,

    I have a production box that I want to upgarde from SQL 2000 Standard Edition to SQL 2000 Enterprise Edition.  Am I able to install Enterprise Edition over the top of Standard or do I need to :

    Backup master and msdb

    unattach all user dbs

    Uninstall Standard Edition

    Install Enterprise Edition

    Restore master

    Restore msdb

    Any help would be appreciated.

    Regards

    Carl

     

  • October 31, 2005 at 1:07 pm

    #601406

    U can run setup and it should take care of the upgrade on its own. U don't need to backup/restore. But its always recommended to back all the databases before any upgrade.

    Good Luck.

    Babu.

  • November 1, 2005 at 11:22 am

    #601628

    There are some "gotchas" in running the setup.  Check this article for the details on how to upgrade SQL Server editions:

    How to perform an edition upgrade within SQL Server 2000

     



    Mark

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

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