Uninstalling SQL 2k components

Question

Uninstalling SQL 2k components

NewBeeSQL

SSCrazy

Points: 2170
More actions
December 10, 2009 at 9:57 am

#218636

Folks..
In one of our production servers, MS SQL 2000 and MS SQL 2005 are running. now we have migrated all the databases from sql 2000 to sql 2005.
Now, task assigned to me is...removing sql 2000 components from the box...
Can anyone please suggest me what precautions / steps / process to be taken removing SQL 2000 components from the server. I have to make sure that none of the applications should be impacted which are connected to sql 2005 on this server.
Thanks all...
-----------------------------------------------------------------------
For better assistance in answering your questions[/url]
Perforamance Issues[/url]
Cross Tabs and Pivots[/url]
Cross Apply[/url]
The Numbers or Tally Table- Jeff Moden[/url]

Viewing 7 posts - 1 through 6 (of 6 total)

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

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 1

Is your SQL Server 2000 DB engine still running?

If so, I would first stop the DB engine and check if there is any impact ( Incase any apps are wrongly configured and using the 2000 Engine). If no errors and issues have been reported then you may plan for the un-install of SQL 2000.

Be careful while un-installing the components, not to uninstall / change the SQL Native Client tools etc.

Of course have a downtime scheduled to test after installation.

Such a task doesn't have a fallback plan. Hope for the best and nothing gets broken.

Have you considered this? Just disable all SQL Server components and let the server run with SQL 2005, which should not have any issues.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

NewBeeSQL SSCrazy Points: 2170 More actions · Answer 2

Thanks bru for response..

One more thing i missed in my original post is...compatiblilty level for the DBs in SQL 2005 is set to 80. does it have any dependency on sql 2000 components...

-----------------------------------------------------------------------
For better assistance in answering your questions[/url]
Perforamance Issues[/url]
Cross Tabs and Pivots[/url]
Cross Apply[/url]
The Numbers or Tally Table- Jeff Moden[/url]