September 2, 2010 at 10:50 am
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
September 2, 2010 at 10:53 am
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
September 2, 2010 at 11:15 am
I guess, i installed a new instance
shld i delete sql 2005 and start again?
Regards
Sushant Kumar
MCTS,MCP
September 2, 2010 at 11:29 am
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
September 2, 2010 at 11:39 am
do i need to run upgrade advisor again ?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
September 2, 2010 at 11:48 am
No.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
September 2, 2010 at 11:50 am
when it asks default instance or named instance, whcih should i choose?
Regards,
Sushant
Regards
Sushant Kumar
MCTS,MCP
September 2, 2010 at 11:51 am
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
September 2, 2010 at 11:57 am
@ cirqued
How to make sure
im just installing the sql 2005 setup.exe
Regards
Sushant Kumar
MCTS,MCP
September 2, 2010 at 11:59 am
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. 🙂
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]
September 2, 2010 at 12:05 pm
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
September 2, 2010 at 12:17 pm
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
September 2, 2010 at 12:18 pm
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://qa.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
September 2, 2010 at 1:39 pm
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
September 2, 2010 at 1:46 pm
Were there any errors or warning? What does the log file have about the problem(s)?
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]
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply