installing 32bit sql on windows 2003 64bit | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

installing 32bit sql on windows 2003 64bit

Hi Guys. I’ve been having problems while installing sql server on windows 2003. Here are my questions. Is it possible to install sql server 2005 32bit on a windows 2003 64bit platform? If yes, can I have the procedure?
Next, Can I detach a 2005 32bit database and attach it to a 2005 64bit? Is there any downside? if it is possible, can I have the procedure? Thanks
Yes, you can install sql server 2005 32 bit on windows 2003 64 bit it will be running on WOW64… But why do you want to install 32 bit sql server 2005 when there is no price difference between 32 bit and 64 bit and it is interchangeble…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

No problem in detach and attach of database also as it needs SQL engine to attach. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
You can use BACKUP/RESTORE too…there is no special method moving 32 bit to 64bit and there is no down side…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

Moving databases – detach and attach is better and as referred having a full database backup is always helpful. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
I agree with Satya…
For high availability backup/restore is the way to minimize the down time when the databases are big…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

High availability is fine but how about transferring the data or updates since the last update [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]. So in this case having a downtime with prior testing would help in acquiring minimum downtime.<br /><br /><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Writer, Contributing Editor & Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing. <hr noshade size="1">The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.</i></font id="size1"></font id="teal"></center>
thanks for all the replies. It really helped. Mirdassou
I have a couple of questions regarding the same topic. Mirdas has asked the question about detaching from 32-bit and attaching it in 64-bit and it was clarified that there are no issues. 1. But my question is can the d/b’s on 64-bit SQL Server be detached and attached in 32-bit SQL Server without any issues? 2. Also because we are planning to move to 64-bit SQL Server only on our production, will there be any compatibility issues between these servers and th eothers 32-bit ones with respect to any inter-server activities like replication or mirroring? Thanks
Satya
1. I think yes as the database level there will not be any difference on 32 or 64 bit as it lies only to the system for SQL engine and windows operating system. 2. IMHO its better to re-install the replicatio & mirroring when you have moved to 64 bit, as it tends break few things on Replication. As we have had such issues and having less documentation on the web and support calls with PSS taking longer time we have decided to install afresh, that solved the issue. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Yes, you can move databases back and forth between 32-bit and 64-bit versions of SQL Server. Scrip the replication for future use and same script If you get any connectivity issues, please check the following blog…
http://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspx
http://blogs.msdn.com/sql_protocols/archive/2005/12/22/506607.aspx MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

If you are choosing the upgrade path then here are few points: – Directly upgrading from 32-bit SQL Server 2000 to 64-bit SQL Server 2005 on x64 machines is not supported. 1. Install 64-bit SQL Server 2005 side by side with 32-bit SQL Server 2000, which is supported. 2. Transfer all data from SQL Server 2000 to SQL Server 2005 while SQL Server 2000 is still running. 3. Test and tune 64-bit SQL Server 20005. When it works well, switch applications refering to 32-bit SQL Server 2000 to this 64-bit SQL Server 2005. 4. You can uninstall 32-bit SQL Server 2000 when everything works fine if necessary. 5. If you need to use Reporting Services then ensure the IIS has been configured properly before installing the RS components.q Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
]]>