• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 121
  • Last Modified:

MS SQL Server Web Edition 2012 32 bits to 64 bits upgrade

Which steps should I follow for the most easy upgrade path? If in place upgrade possible, would be perfect (no need to detach databases etc).
Obviously, same named instance, to not confuse all the software using this database.
0
Kimputer
Asked:
Kimputer
  • 3
  • 3
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
In place upgrade will be possible if the Operating System it's also 64bits. If so you don't need to detach databases and neither change instance name but SQL Server will be offline during the upgrade.
0
 
KimputerAuthor Commented:
Just for my piece of mind, do you have a link to a MS document or technet/blog post? Or did you already finish a few of these upgrades yourself?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes I did It already. Not from 32bit to 64 but from SQL Server 2005 to 2012. And also from MSSQL 2008R2 Standard Edition to Enterprise Edition. What the setup will do is to run again the install but with configured values from the existed instance.
Of course perform an image of the server before you start the upgrade. You can also perform a search in the internet if you want, just for peace of your mind.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
KimputerAuthor Commented:
SQL in place upgrade for 2005 to 2012 (both 32 bits) I'm familiar with. That's why my question was specifically for 2012 32 bits to 64 bits (yes Windows Server already 64 bits). And since you didn't perform this specific upgrade, where is the official documentation (as said, MS document / technet / blog?)
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I couldn't find any official document but if you run the setup will immediately see if it's shows you the option to upgrade the instance or not.
If not then the workaround is to uninstall the 32bits version and install the 64bits version and give the instance the same name as previous version. Of course you'll need to have extra work as you need to recreate users and attach all the user databases. And if you have linked servers, jobs and replications you need to script them before start with the upgrade.
0
 
KimputerAuthor Commented:
Sorry for the C grade, but the fact is that your original answer is still wrong (32 to 64 bits, inplace, is not possible, yes I already ran the setup)
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now