Does SQL 2008 R2 64 bit OEM can be downgrade to 32 bit?

All replies

• 

  

  0

  Sign in to vote

  From licensing perspective installing x64 or x86 (32bit) version is not considered as downgrade. As long as you will install 2008 R2 you can use either version - 64bit or 32bit.

  ---

  Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
  Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.

  Friday, March 23, 2012 7:38 AM
• 

  

  3

  Sign in to vote

  You would need to backup all your databases and completely uninstall SQL Server 2008R2 x64 and then install the x86 edition and restore your databases.

  While this details how to upgrade from x86 to x64 it follows the same principles of this change from x64 to x86 just ignore the stuff about SQL 2000.

  http://blogs.msdn.com/b/cindygross/archive/2009/07/07/x64-windows-upgrade-from-32bit-sql-server-to-64bit-sql-server.aspx

  Make sure that you install up to the same patch level so if you have installed CUs etc make sure to install them as well

  This begs the question of why you want to do this?

  Important : This information is provided without warranty or guarantee that anything will work.  TRY THIS ON A TEST BOX FIRST!

  ---

  
  Blog: http://www.certsandprogs.com
  
  70-515 Objectives List with MSDN Links
  70-536 Objectives List with MSDN Links
  70-505 Objectives List with MSDN Links
  70-562 Objectives List with MSDN Links
  70-433 Objectives List with MSDN Links

  • Proposed as answer by Mr. Wharty Saturday, March 24, 2012 1:14 AM
  • Marked as answer by Mr. Wharty Friday, March 30, 2012 2:47 PM

  Friday, March 23, 2012 9:18 AM