Solved

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

Posted on 2015-01-19
6
101 Views
Last Modified: 2015-01-19
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
Comment
Question by:Kimputer
  • 3
  • 3
6 Comments
 
LVL 48

Expert Comment

by:Vitor Montalvão
ID: 40557831
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
 
LVL 35

Author Comment

by:Kimputer
ID: 40557892
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
 
LVL 48

Expert Comment

by:Vitor Montalvão
ID: 40557919
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
LVL 35

Author Comment

by:Kimputer
ID: 40557943
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
 
LVL 48

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40557968
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
 
LVL 35

Author Closing Comment

by:Kimputer
ID: 40558024
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
OSQL to execute sql command 26 24
Nested Case statement 4 39
Solar Winds can't see SQL Server Express 17 35
Substring works but need to tweak it 14 16
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question