SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 SQL Server 2008 - Update 10.0.4000 to 10.50.1600 p
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 01/12/2011 :  16:46:08  Show Profile  Reply with Quote
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

USA
5072 Posts

Posted - 01/12/2011 :  17:09:29  Show Profile  Visit russell's Homepage  Reply with Quote
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.
Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/12/2011 :  17:10:07  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 01/13/2011 :  06:58:03  Show Profile  Reply with Quote
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

Go to Top of Page

GilaMonster
Flowing Fount of Yak Knowledge

South Africa
4507 Posts

Posted - 01/13/2011 :  10:24:48  Show Profile  Visit GilaMonster's Homepage  Reply with Quote
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
Go to Top of Page

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 01/13/2011 :  10:49:43  Show Profile  Reply with Quote
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
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 01/13/2011 :  10:59:51  Show Profile  Visit russell's Homepage  Reply with Quote
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.
Go to Top of Page

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 01/13/2011 :  11:18:43  Show Profile  Reply with Quote
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 ...
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 01/13/2011 :  14:25:38  Show Profile  Visit russell's Homepage  Reply with Quote
Yep, that's what I mean.
Go to Top of Page

agamboa
Starting Member

Mexico
1 Posts

Posted - 05/15/2011 :  19:54:04  Show Profile  Reply with Quote
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.
Go to Top of Page

pallavig
Starting Member

India
1 Posts

Posted - 08/26/2011 :  08:52:58  Show Profile  Reply with Quote
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?
Go to Top of Page

hcmssql
Starting Member

1 Posts

Posted - 09/21/2011 :  05:37:10  Show Profile  Reply with Quote
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!!!

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000