Shiifting From Standard to Enterprise Edition(SQLServer2000)

• U J

  SSCrazy

  Points: 2423

  More actions

  November 17, 2006 at 7:52 am

  #153304

   

  dear all,

  i m having SQL Server 2000 Standard Edition on my production server.

  now i want to deinstall Standard Edition and install Enterprise Edition

  but this is production server and i want to retain all databases,Logins,Users,Jobs and maintainance plans as they are in the Standard Edition [?].

  Please can anybody tell me wht should i do?

  wht will be the Plan Of Action ? [?]

  [] Tnks a lot in advance []

  -Tushar

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  November 17, 2006 at 8:07 am

  #672619

   

  I think you can upgrade the version from standard to enterprise.

  If you do install a clean enterprise version, then,

  Backup all your databases;

  Uninstall the standard version;

  Install the enterprise version;

  Start the SQL Server in a single user mode;

  Restore all system databases;

  Restore all user databases;

  Restart the SQL Server

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  November 17, 2006 at 8:19 am

  #672628

  Please do not cross-post. It's easier to follow only one thread.  Finish this discusison here pls :

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=323833