SQL Server 2008 - Update 10.0.4000 to 10.50.1600 p

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

SQL Server 2008 - Update 10.0.4000 to 10.50.1600 p

Author

Topic

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2011-01-12 : 16:46:08

Hello,

On a Server I have SQL Server 2008 10.50.1600 and on my computer I have SQL Server 2008 10.0.4000.

Now I am not able to do a database backup from the server and use it in my computer.

I installed SQL Server Express in both places using Web Plataform Installer.

Everything was working fine. Both with the same version.

However, out of nothing they have a different version.
I tried to upgrade in my computer using Windows Update but no luck.

What should I do?

Thank you,
Miguel

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-01-12 : 17:09:29

10.50.xxxx is SQL Server 2008 R2.

You can't restore backups from 2008 R2 to 2008.

You'll need to script out all the objects and then BCP the data out, BULK INSERT it in.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-12 : 17:10:07

They're not the same version.

The server is running SQL 2008 R2. Your computer is running SQL 2008. Different versions completely (like SQL 2005 and SQL 2008), if you want to upgrade your desktop, you'll need to locate or buy a copy of SQL 2008 R2 and install it.

--
Gail Shaw
SQL Server MVP

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2011-01-13 : 06:58:03

Hello,

I checked my computer and it seems I have two versions installed:
- Microsoft SQL 2008 (10.0.4000.0 SP2 Express Edition 64-bit)
- Microsoft SQL 2008 R2 (10.50.1600.1 RTM Express Edition 64-bit)

They both show in programs list. And I am using:
- SQL Server Configuration Manager, Version: 2009.0100.1600.01
- Microsoft SQL Server Management Studio 10.50.1600.1

However, the "server engine" running is SQL 2008 (10.0.4000.0).

How can I change it to 10.50.1600.1 RTM?

Thank You,
Miguel

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-13 : 10:24:48

By downloading and installing SQL 2008 R2 Express edition.

Are you sure you don't already have both database engines installed and are just connecting to the wrong one?

--
Gail Shaw
SQL Server MVP

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2011-01-13 : 10:49:43

Yes,

I think I have both engines installed but I don't know how to turn the SQL 2008 R2 on and turn off the other one.

That is what I was asking. How can I do it?

Thank You,
Miguel

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-01-13 : 10:59:51

Disable the service for the one you don't want to use in the services applet.

More importantly, you need to know the instance name that you want to connect to.

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2011-01-13 : 11:18:43

You mean checking the services in Local Services under control panel?

I went there and I have only one SQL Server (SQL Express) which is running ... But I don't find another SQL Server instance ...

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-01-13 : 14:25:38

Yep, that's what I mean.

agamboa
Starting Member

1 Post

Posted - 2011-05-15 : 19:54:04

quote:
Originally posted by shapper

You mean checking the services in Local Services under control panel?

I went there and I have only one SQL Server (SQL Express) which is running ... But I don't find another SQL Server instance ...

Hi Miguel, I've the very same problem you have (or had), Did you find out how to fix this issue?.

Thank you in advance for your help.

Regards,

Alberto G.

pallavig
Starting Member

1 Post

Posted - 2011-08-26 : 08:52:58

I have upgraded sql server 2008 r2 from 10.0.1600 to 10.50.1600 , but when I opened sql server it is not showing the upgraded version. unspammed
Can we give me any suggestion?

hcmssql
Starting Member

1 Post

Posted - 2011-09-21 : 05:37:10

quote:
Originally posted by pallavig

I have upgraded sql server 2008 r2 from 10.0.1600 to 10.50.1600 , but when I opened sql server it is not showing the upgraded version. unspammed
Can we give me any suggestion?

hi,
1)click 'Connect' to the database engine
2)click <...browse for more..> for to look into more server instance name

Mssql server 2008 has different instance name with R2. So, you must browse for more to get the R2 instance name. I think you could login successfully. All the best!!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources