Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

A production server has accidentally been installed with SQL Server 2012 32bit version, while it needed a 64bit version.

How best to fix this issue?

Is it possible to simply UPGRADE from 32 to 64 bit version?

Should I just install a new instance of 64 bit version of SQL Server 2012 and then simply restore the backups?

share|improve this question
add comment

2 Answers

up vote 7 down vote accepted

As stated in BOL here:

Cross-platform upgrade is not supported. You cannot upgrade a 32-bit instance of SQL Server to native 64-bit using SQL Server Setup. However, you can back up or detach databases from a 32-bit instance of SQL Server, and then restore or attach them to a new instance of SQL Server (64-bit) if the databases are not published in replication. You must re-create any logins and other user objects in master, msdb, and model system databases.

If you have installed a default instance of SQL Server and wish to keep it that way your only option is to remove the current install and install using the 64-bit media. Otherwise you can install a 64-bit instance as a named instance on the same server.

Cindy Gross has some additional useful information here.

share|improve this answer
    
thanks Shawn! question - I seem to recall that named instances were problematic... not sure if I am going to get my self into trouble by installing named instance –  Greg Bala Dec 14 '13 at 23:34
1  
Not sure what you mean by problematic, I support many servers that have named instances running. –  Shawn Melton Dec 14 '13 at 23:59
add comment
  1. Backup all databases
  2. Remove SQL Server 32-bit
  3. Reinstall SQL Server 64-bit
  4. Restore all databases
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.