Upgrade from SQL2K8R2 Express Edition SP1 to SQL2008R2 Standard Edition

• Thinky Night

  SSCommitted

  Points: 1663

  More actions

  July 18, 2012 at 10:59 am

  #276069

  Hi All,

  I want to upgrade a SQL Server 2008 R2 Express Edition with Service Pack 1 to Standard Edition RTM.

  Is it possible to upgrade?

  If not, what do i have to do?

  Regards

• Ant-Green

  SSC Guru

  Points: 113509

  More actions

  July 19, 2012 at 2:09 am

  #1514662

  Side by side or in place upgrade?

  Yes it is possible, but will depend on what you need to call the SQL server, downtime etc etc?

  Is Express installed as a named instance or not?

  Does the installation of Standard need to have the same instance name?

  Also have you purchased your licenses to actually be able to legally perform the upgrade?