SQL Server 2005 Enterprise edition to SQL Server 2008 Standard edition

• passivebyz

  SSCommitted

  Points: 1908

  More actions

  June 14, 2010 at 10:56 pm

  #236446

  Hi,

  Can we upgrade SQL Server 2005 Enterprise edition to SQL Server 2008 Standard edition?

  Thanks

• chetanr.jain

  Hall of Fame

  Points: 3938

  More actions

  June 15, 2010 at 12:26 am

  #1180212

  Hi,

  As per my knowledge, You cannot directly upgade From Enterprise Edition to Standard Edition.

  Below is the Microsoft link supporting to my words :

  http://msdn.microsoft.com/en-us/library/ms143393.aspx

  It Says from 2005 Enterprise edition, you can upgrade to 2008 Enterprise or DataCenter Edition.

  On the other hand, you can try Side by side upgrade,

  Install SQL 2008 Standard Edition.

  Take the backup of all of the necessary scripts [Users, Logins, Roles etc.]. Take the full DB backup.

  Take last T-Log backup followed by tail backup from SQL 2005 Instance

  Restore all of the backups on your newly cretaed 2008 standard edition. Then execute the necessary scripts backups.

  Hope it works.

• Johan Bijnens

  SSC Guru

  Points: 135369

  More actions

  June 15, 2010 at 2:25 am

  #1180251

  in place upgrade may not be supported !

  Also keep in mind, SQL2005EntEdtn vs SQL2008(r2 ?) StdEdtn means feature loss !!

  e.g. no more online reindex, ...

  "Compare Edition Features"

  http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me