SQL Server 2008 Upgrade failed

Question

Post reply

SQL Server 2008 Upgrade failed

espanolanthony

SSCarpal Tunnel

Points: 4204
More actions
August 24, 2011 at 7:27 am

#246866

I have SQL Server 2008 Standard x64. I was trying to upgrade this version to SQL Server 2008 Enterprise R2. And I did upgrade successfully and then restarted the Server also.
But, when I start the SQL serevr I see tat the Product version is still
10.0.4000.0SP2Standard Edition (64-bit).
and when I go to Help--About options I see that the version is 10.50.1600.1. Which is R2 version.
I am very confused what went wrong. Can someone help me out please.

Viewing 13 posts - 1 through 12 (of 12 total)

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

espanolanthony SSCarpal Tunnel Points: 4204 More actions · Answer 1

espanolanthony

SSCarpal Tunnel

Points: 4204

August 24, 2011 at 8:39 am

#1372622

Any one on this please.....

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

If we knew we'd have told you by now.

What problem is this causing you that this can't wait a couple hours?

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

espanolanthony (8/24/2011)
Any one on this please.....

Patience. We're all volunteers with our own jobs and problems. If you want immediate help, hire someone.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

When you start SQL Server, you see a product version?

Or do you mean SSMS?

If SSMS, did you upgrade the tools too? My bet is no.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

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

espanolanthony (8/24/2011)
But, when I start the SQL serevr I see tat the Product version is still
10.0.4000.0SP2Standard Edition (64-bit).

Then either the installation failed or you're looking at the wrong instance

and when I go to Help--About options I see that the version is 10.50.1600.1. Which is R2 version.

Help-> about just gets you the version of the client tools. It's got nothing to do with the version of the server

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

GilaMonster (8/24/2011)
espanolanthony (8/24/2011)
Any one on this please.....
Patience. We're all volunteers with our own jobs and problems. If you want immediate help, hire someone.

I know of a few consultants looking for extra work...:-D

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

SQLRNNR (8/24/2011)
GilaMonster (8/24/2011)
espanolanthony (8/24/2011)
Any one on this please.....
Patience. We're all volunteers with our own jobs and problems. If you want immediate help, hire someone.
I know of a few consultants looking for extra work...:-D

Thanks for recommending me Jason :hehe:.

espanolanthony SSCarpal Tunnel Points: 4204 More actions · Answer 8

espanolanthony

SSCarpal Tunnel

Points: 4204

August 24, 2011 at 11:00 am

#1372717

when I upgraded I upgraded all the tools also.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

If it is causing problems, I would reinstall the tools.

Otherwise, your database upgrade succeeded.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

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

SQLRNNR (8/24/2011)
If it is causing problems, I would reinstall the tools.
Otherwise, your database upgrade succeeded.

Err, the database engine is still 2008 and the tools are 2008 R2.

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

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

espanolanthony (8/24/2011)
when I upgraded I upgraded all the tools also.

And by the looks of things the database engine upgrade failed and the tools upgrade succeeded. I'd be looking through the upgrade logs at this point for the reason for the DB engine not to have been upgraded.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

GilaMonster (8/24/2011)
SQLRNNR (8/24/2011)
If it is causing problems, I would reinstall the tools.
Otherwise, your database upgrade succeeded.
Err, the database engine is still 2008 and the tools are 2008 R2.

d'oh

@espanolanthony - how exactly are you determining the Product version?

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events