Upgarding SQL 2000 Standard Edition to SQL 2000 Enterprise Edition

• Carl Rimmer

  SSCarpal Tunnel

  Points: 4068

  More actions

  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

   

• vambati

  SSCrazy

  Points: 2769

  More actions

  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.

• Mark Harr

  SSCrazy Eights

  Points: 9921

  More actions

  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