Can We upgrade SQL Server 2005 Enterprise Edition to SQL Server 2008 Standard Edition

• pshaship

  SSCertifiable

  Points: 6125

  More actions

  September 7, 2010 at 3:10 pm

  #387741

  Hi,

  We have SQL Server 2005 x64 Enterprise Edition with SP3 on a two node active/passive Windows 2003 Cluster.

  Now we are planning to upgrade to SQL Server 2008 x64 Standard Edition With SP1 on a two node active/passive Windows 2008 cluster using Side-by-Side upgrade method and want to make sure whether this upgrade path is supported or not by MS?

  So does upgrading SQL Server 2005 Enterprise Edition to SQL Server 2008 Standard Edition supported by MS?

  Could you please provide me the MS links

  Thanks

• WayneS

  SSC Guru

  Points: 95460

  More actions

  September 7, 2010 at 5:01 pm

  #1217675

  Yes.

  SQL Server 2008 Upgrade Technical Reference Guide

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• Jeffrey Williams

  SSC Guru

  Points: 90303

  More actions

  September 8, 2010 at 2:42 pm

  #1218255

  Just to be clear - you are not really upgrading an instance of SQL Server. You are installing a new instance and migrating the databases to the new instance.

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs