How to downgrade from SQL Server 2008 Enterprise to SQL Server Standard edition

• APA0876

  Hall of Fame

  Points: 3853

  More actions

  December 19, 2012 at 7:17 am

  #266527

  Hi,

  How to downgrade from SQL Server 2008 Enterprise to SQL Server Standard edition?

  If I want to do it on the same machine keeping the same default instance name?

  I appreaciate your assistance.

  Thanks

• Ant-Green

  SSC Guru

  Points: 113499

  More actions

  December 19, 2012 at 7:24 am

  #1570073

  Backup all databases, script out all server wide objects, uninstall, reinstall, run all server with objects back in, restore all databases bar master

  Or

  Install a standard named instance, transfer everything to that instance.

  Uninstall Enterprise

  Install Standard

  Transfer from Named Standard to Default Standard

  Uninstall Named Standard

  Or

  Get another server

  Install Standard

  Transfer all objects

  Shut down old server

  Rename new server

  Drop old server name sp_dropserver

  Add new server name sp_addserver