Upgradation frm SQL 2k to 2k5

Question

Upgradation frm SQL 2k to 2k5

SkyBVI

SSCoach

Points: 15128
More actions
September 2, 2010 at 10:50 am

#223302

Hi,
I hav sql server 2000 SP4 on windows 2003. I want to upgrade it to SQL 2005.
I installed the cd of sql 2005 enterprise edition, then ran the sql 2005 upgrade advisor.
After that i installed sql 2005 frm setup.
Now , i got sql 2005 but it didnt replace the sql 2000. When I open the SSMS (sql 2005), it shows
that the sql server analysis services , reporting, integration services are all 9.0.0.... (sql 2005) but the sql server database services are on 8.0.2039 (sql 2000)
when i run this
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
It says 8.0.2039 with sp4, same as before and the earlier sql 2000 is also existing.
I want just 1 sql server 2005 on my machine,
how to proceed?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP

Viewing 15 posts - 1 through 15 (of 22 total)

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

It seems that you did not pick the database engine option during setup. Or did you install a new instance?

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

SkyBVI SSCoach Points: 15128 More actions · Answer 2

I guess, i installed a new instance

shld i delete sql 2005 and start again?

Regards
Sushant Kumar
MCTS,MCP

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

If your goal is to have a single instance - it might be advisable.

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

SkyBVI SSCoach Points: 15128 More actions · Answer 4

do i need to run upgrade advisor again ?

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

WayneS SSC Guru Points: 95409 More actions · Answer 5

No.

Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes

If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

SkyBVI SSCoach Points: 15128 More actions · Answer 6

when it asks default instance or named instance, whcih should i choose?

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

Default - if that is what your initial instance in 2K was.

You need to make sure you are running upgrade and not just the regular install.

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

SkyBVI SSCoach Points: 15128 More actions · Answer 8

@ cirqued

How to make sure

im just installing the sql 2005 setup.exe

Regards
Sushant Kumar
MCTS,MCP

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 9

Before going any further, are you installing this on the same server as your SQL 2000 instance? Have you backed up everything? Once it starts upgrading SQL 2000 to 2005, there is no going back to 2000. If the upgrade fails that could spell trouble.

Jason, might need those boots here too. 🙂

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

SQLBuddy123 One Orange Chip Points: 28294 More actions · Answer 10

Hi Sushanth,

As alvin said there is no going backwards once you start the inplace upgrade. There are only 2 choice. Either the Upgrade should succeed or it should fail.

So before doing doing an inplace upgrade you should always have some sort of backups available either server level or sql server backups to rollback incase of a failure. If its a VM then you should take a snapshot of the VM before you do the inplace upgrade.

You should'nt uninstall SQL Server. If you do so you will end up with having no sql on the Box. If you have not already uninstalled the SQL Server try to reinstall it by selecting only the Database engine option.

Thank You,

Best Regards,

SQLBuddy

SQLRNNR SSC Guru Points: 281334 More actions · Answer 11

sqlbuddy123 (9/2/2010)
Hi Sushanth,
As alvin said there is no going backwards once you start the inplace upgrade. There are only 2 choice. Either the Upgrade should succeed or it should fail.
So before doing doing an inplace upgrade you should always have some sort of backups available either server level or sql server backups to rollback incase of a failure. If its a VM then you should take a snapshot of the VM before you do the inplace upgrade.
You should'nt uninstall SQL Server. If you do so you will end up with having no sql on the Box. If you have not already uninstalled the SQL Server try to reinstall it by selecting only the Database engine option.
Thank You,
Best Regards,
SQLBuddy

Good recommendations on the VM.

With the uninstall, he now has two instances of SQL server. One is a SQL 2000 instance and the other is a SQL 2005 instance. He only wants one instance and is probably only licensed for the one (depending on the agreement - I know).

Having this second instance installed could cause confusion for some in the future as well as vulnerabilities if one forgets about it and does not maintain it.

You can remove this instance and then re-try the install as an upgrade rather than a new instance install - which was what was done.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 12

sushantkumar1984 (9/2/2010)
Hi,
I hav sql server 2000 SP4 on windows 2003. I want to upgrade it to SQL 2005.
I installed the cd of sql 2005 enterprise edition, then ran the sql 2005 upgrade advisor.
After that i installed sql 2005 frm setup.
Now , i got sql 2005 but it didnt replace the sql 2000. When I open the SSMS (sql 2005), it shows
that the sql server analysis services , reporting, integration services are all 9.0.0.... (sql 2005) but the sql server database services are on 8.0.2039 (sql 2000)
when i run this
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
It says 8.0.2039 with sp4, same as before and the earlier sql 2000 is also existing.
I want just 1 sql server 2005 on my machine,
how to proceed?
Regards,
Sushant

It seems that this article might be of some assistance to you:

http://www.sqlservercentral.com/articles/Administration/2987/

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

SkyBVI SSCoach Points: 15128 More actions · Answer 13

I removed the sql 2005 instance and again re installed it

Just the sql server database services and the reporting services failed, other services were installed.

and as a result i got the prompt that the MS SQL server setup failed.

Is the CD corrupt or what>?

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 14

Were there any errors or warning? What does the log file have about the problem(s)?

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]