SQL Server Performance Forum – Threads Archive
SQL Server 2005 Upgrade from SQL Server 2000
Hi All, I did an upgrade of SQL Server 2000 to SQL Server 2005. After install, i can still see two of them as independent entities. I am also able to use them independently. My expectation was that 2000 will be upgraded to 2005 and i will see only one installed program. Can anybody tell me why is it happening and how can i make sure that there is only SQL Server 2005 on my box. Regards,Amit
How did you do the upgrade. is it from the upgrade tool or from backup restore —————————————-
Did you choose upgrade while installing SQL Server 2005 or installed as another instance? You can go to services in computer managment and check if you have seperate services for each version. Resolution:
————
Uninstall SQL 2005 from Add and Remove programs and upgrade SQL 2000 once again. OR move SQL 2000 databases/dts/jobs/logins/setup replication, logshipping etc on/to sql 2005 and uninstall sql 2000. Help:
————
Run SQL 2005 upgrade adviserhttp://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1158719,00.html?bucket=ETA http://www.microsoft.com/downloads/…d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en
Deepak Kumar
MVP, MCDBA – SQL Server Disclaimer: This post is provided as is with no rights & warranty for accuracy, for the sake of knowledge sharing only.
I chose to upgrade the default instance of SQL Server 2000 Amit
I suggst Deepak’s reference to use Upgrade advisor as it gives more information about the upgrade issues.
When upgrade is finished it will not uninstall the SQL 2000 version, as you have to do that manually. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
I think i found the issue. My SQL Server 2000 was an RTM version with no service pack. SQL Server 2005 needs to have 2000 with SP4 for upgrade to happen. The setup should have pointed this out but somehow it went through and installed SQL Server 2005 also. I have run it again after uninstalling SQL Server 2005, putting SPs for 2000 and running 2005 install again Amit
I believe during the setup it is only a warning message and not a show stopper to install SQL 2005. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>