Dear all,

My current SQL Version is SQL 2008 R2 (32BIT).I want to upgrade this to SQL 2008 R2 (64 BIT).

Do I need to Uninstall SQL SERVER 2008 R2 (32 BIT) and then again run the installation of SQL SERVER 2008 R2(64 BIT)?

What will happen to my data backup of 32 BIT?Can I restore the data base on 64 BIT?

What are the steps to be followed during this upgrade? 

Regards

Hello,

You cannot use SQL Server setup program to perform a cross platform upgrade. It is not supported by SQL Server setup.

However, you can perform a side-by-side upgrade by installing a named instance of SQL Server (x64) on the same computer, then you can perform a backup on the existing instance and restore it on the new 64-bit instance.

You can transfer logins from one instance to the other using the procedure explained on the following article and avoid orphan logins.

https://support.microsoft.com/en-us/kb/918992

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator 5 hours 49 minutes ago
• Proposed as answer by Shanky_621MVP, Moderator 2 hours 20 minutes ago

My current SQL Version is SQL 2008 R2 (32BIT).I want to upgrade this to SQL 2008 R2 (64 BIT).

Do I need to Uninstall SQL SERVER 2008 R2 (32 BIT) and then again run the installation of SQL SERVER 2008 R2(64 BIT)?

As Alberto says you need to do side by side migration. Don't straight away uninstall SQL 2008 32 bit.You should first  install 2008 R2 64 bit on same machine or different machine then move then backup sql server 32 bit databases and restore it on 64 bit. Migrate logins and jobs as well

What will happen to my data backup of 32 BIT?Can I restore the data base on 64 BIT?

What are the steps to be followed during this upgrade? 

Hello,

You cannot use SQL Server setup program to perform a cross platform upgrade. It is not supported by SQL Server setup.

However, you can perform a side-by-side upgrade by installing a named instance of SQL Server (x64) on the same computer, then you can perform a backup on the existing instance and restore it on the new 64-bit instance.

You can transfer logins from one instance to the other using the procedure explained on the following article and avoid orphan logins.

https://support.microsoft.com/en-us/kb/918992

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

• Edited by Alberto MorilloMVP, Moderator Saturday, July 11, 2015 1:16 AM
• Proposed as answer by Shanky_621MVP, Moderator Saturday, July 11, 2015 4:45 AM

My current window version is 32 BIT.Can I do the side installation of 64 BIT SQL server.

Regards

Sandeep Kumar

My current window version is 32 BIT.Can I do the side installation of 64 BIT SQL server.

Regards

Sandeep