upgrade sql server 2005 standard edition to enterprise edition - kindly assist

• chewelson

  SSC Enthusiast

  Points: 115

  More actions

  June 8, 2009 at 9:32 am

  #155798

  Hi all experts,

  I'm a newbie here in sql server administration. Need your kind assistance on this.

  I unable to find a link that provide guidance on upgrading sql server 2005 standard edition to enterprise edition.

  Need some pointers on how to upgrade.

  1) do i have to bring down any sql server services or databases offline before performing upgrade?

  2) execute the following, am i right? "start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME= UPGRADE=SQL_Engine SKUUPGRADE=1 /qb"

  3) currently the standard edition is of service pack 2. understand that service pack 2 need to be reinstall after upgrade. however, i would like to know after the upgrade, will the service pack 2 be automatically removed? do i have to manually remove it and reinstall it?

  thanks

• Vinay Thankur

  SSCarpal Tunnel

  Points: 4178

  More actions

  June 8, 2009 at 10:02 am

  #1006144

  http://qa.sqlservercentral.com/Forums/Topic375915-146-1.aspx

  Thanx.
  Vinay

  http://rdbmsexperts.com/Blogs/
  http://vinay-thakur.spaces.live.com/
  http://twitter.com/ThakurVinay

• Chand00

  SSCertifiable

  Points: 6466

  More actions

  June 8, 2009 at 10:44 am

  #1006183

  Check out this http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66. Hope this may help you

  [font="Verdana"]Thanks
  Chandra Mohan[/font]

• sam-1083699

  SSC Eights!

  Points: 843

  More actions

  June 8, 2009 at 11:25 am

  #1006199

  Hi,

  Can you please explain me clearly what you did?after you done with this problem. It may help me later.

  thanks,

  sam