Downgrading from SQL 2005 Ent. to SQL 2005 Standard

• freeman77

  Newbie

  Points: 9

  More actions

  April 22, 2011 at 8:19 am

  #143806

  Has anyone run into any issues downgrading from Enterprise to Standard? I have a SQL 2005 machine running Enterprise. A while back, we realized we only needed Standard on it, so we backed up databases, uninstalled Enterprise, and then installed 2005 Standard. However, looking at my machine today, everything indicates that it is 2005 Enterprise. As I get ready to repeat the above process, just curious if anyone else has ever run into a similar issue.

  thanks

• Meet George Jetson

  SSChampion

  Points: 11638

  More actions

  April 22, 2011 at 12:09 pm

  #1314975

  I can't imagine there being any problems with it. Take a look at this blog (related to 2008) and see if it can give you any guidance.

  http://dbgoby.blogspot.com/2007/11/changing-sql-server-edition.html

  Chris Powell

  George: You're kidding.
  Elroy: Nope.
  George: Then lie to me and say you're kidding.