How do I go from SQL 2008 build 10.0.1600 to build 10.50.1600

Question

How do I go from SQL 2008 build 10.0.1600 to build 10.50.1600

ma29

Old Hand

Points: 356
More actions
May 10, 2011 at 11:43 am

#250562

I currently have SQL 2008 build 10.0.1600 running on a machine. In order to install a database for a demo I need SQL 2008 build 10.50.1600.1.
What is the best way to upgrade to build 10.50.1600.1 from 10.0.1600?

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

10.0.* is SQL 2008

10.5.* is SQL 2008R2. a next higher version of SQL; you'd have to either download an express version of R2, or buy , at a minimum, the developer version for ~$50 and upgrade

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

ma29 Old Hand Points: 356 More actions · Answer 2

I do have an R2 version do I need to go through the whole install or does it update all

aspects of the program.

Lowell SSC Guru Points: 323518 More actions · Answer 3

ma29 (5/10/2011)
I do have an R2 version do I need to go through the whole install or does it update all
aspects of the program.

that's up to you; you can either install a seperate instance of R2, so you have both 2008 and an isntance of 2008R2, or upgrade your existing instance and replace it with just the R2 version. either way, it's a full install, just different options.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

ma29 Old Hand Points: 356 More actions · Answer 4

ma29

Old Hand

Points: 356

May 10, 2011 at 12:45 pm

#1322597

Great thanks!

Maddy...! SSC Eights! Points: 995 More actions · Answer 5

Hello all,

I have successfully upgraded my sql server database engine from version 10.0.1600 to 10.50.2500 but when i try to open it after my upgrade , the sql server database engine asked me a question .

Do you want me to import the custom settings or .......... ?

Without knowing it completely I hit Ok and the settings were applied/changed (exactly do not know what happend ).

Now the problem is when i try to see the server version when connecting through management studio it still shows me the same version 10.0.1600.

My question is

1. Is this due to the import of custom settings or else is my upgrade unsuccessful.

2. If its due to the import of custom settings how can I revert back and see version 10.50.2500 when i connect through sql server management studio.

Thanks In advance.

With Regards,

Maddy.

.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

Did you install a separate R2 instance or did you upgrade the existing instance? From the description, sounds like you installed a separate instance so you have 2008 and 2008 R2 on the machine and then connected to the wrong instance.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Maddy...! SSC Eights! Points: 995 More actions · Answer 7

No Gail,

I upgraded the same instance on the server.

Maddy...! SSC Eights! Points: 995 More actions · Answer 8

My operating system is 32 bit and i installed 32 bit upgrade as I do not know what is bit rate does sql server uses either it 32 or 64

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

On a 32 bit operating system only 32 bit processes can run. On a 64 bit OS, both 32 and 64 can run. Hence if you installed SQL 2008 R2 on a 32 bit OS, it's the 32 bit version of SQL.

Either you installed a second instance and didn't realise or the installation failed or you didn't upgrade the database engine, just the client tools.

p.s. 32 bit or 64 bit is not a bit rate. It's the size of the address pointers.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 10

GilaMonster (3/30/2012)
p.s. 32 bit or 64 bit is not a bit rate. It's the size of the address pointers.

The most visible effect of this architecture is the amount of RAM the OS can use. With 32-bit you can go only till 4 gigabyte (actually a bit less, as some memory is reserved).

2^32 = 4294967296 ˜ 4 gigabyte

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP