Link to home
Start Free TrialLog in
Avatar of barl009
barl009

asked on

upgrade sql 2005 32bit to sql 2008 32 or 64bit on a server 2008 r2 box

Have an upgrade process that I have to do to get my Veeam server up to version 9.5 to utilize nimble snapshots instead of the VMware snapshots:
1.install sql express 2005 management studio, is this the same installation for all versions of sql? Have to copy DB and Config in case of a problem
2.upgrade the sql express from 2005 to 2008r2 on a MS OS server 2008r2 64 bit (or am I limited to the 32 bit upgrade?)
3.I realized that the sql express install is 32bit.   that was a mistake, it should have been 64bit am I tied into the 32 bit management studio and what about the upgrade path to the sql express 2008?
4.What file do I use?  
5.how do I back up the database and the configurations?
6.What are any other caveats?
7. could I upgrade to 2012 sql express?  should I upgrade to 2012?
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Can you explain me what is your requirement.?
Avatar of arnold
Upgrade path is a risky move since you are working on a premise that everything goes well.
Depending on the instance you use, an option you might want to consider us a fresh install of the same instance.
To achieve this, add a secondary ip, then during the install of SQL 2008 r2 express 64 bit version, bind the instance to the newly added ip.
2008 r2 has an ssmse as well. Backup the db from the current, restore it on the new instance after you use the ms provided steps to transfer logins.

In short, search for SQL server transfer logins. An ms site provides ths SPs to facilitate the enumeration of existing logins with the encrypted password and Sid in the form of
Create login username password=encrypted sid=sid
This is needed since the backup db security will be maintain and if the logins are not transferred, the manually created users will gave differing Sid from the recorded Sid in the backup. It there is an so to fix logins, but maintaing this practice maintains uniformity as well as simplifying transitions as well as not having to go through the app to reconfigure login creds.

If you can, test the upgrade of veeam duration as well as how long it takes to backup, restore the db to know what the range of time you need.
My recommendation is to create a new 64bit server and install the new 64bbit version of the products and then perform a side-by-side database migrations.
Why do you want to migrate to SQL Server 2008R2 and not going immediately for a more recent version?
Avatar of barl009
barl009

ASKER

I want to just upgrade the 2005 sql express (32 bit) to 2008 r2 sql express 32 bit.  Here are the options of the files.
SQLEXPR_x86_ENU.exe
SQLEXPR32_x86_ENU.exe

I don't want to do anything crazy.....Can't find which file is best and what are the differences?
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of barl009

ASKER

I was a simple upgrade once I had the right file.  thanks.