SQL 2000/2005 on same server

We currently have a default and named instance of SQL 2000 on a server, along with two named instances of SQL 2005. We are in the process of moving the databases from 2000 to 2005, but we need to uninstall the default instance of SQL 2000 first without affecting the named 2000 instance - is this possible?

asked Jul 20 '12 at 03:58 PM in Default

SDabbs
0 ● 1

(comments are locked)

2 answers:

Shouldn't be a problem with uninstalling the default instance, however I would read this http://technet.microsoft.com/en-US/library/ms144255(v=sql.90) as there could be issues with SQL-DMO

answered Jul 20 '12 at 05:26 PM

Kev Riley ♦♦
46.1k ● 38 ● 43 ● 69

(comments are locked)

Do you need to uninstall or simply stop and disable the service?

answered Jul 20 '12 at 06:22 PM

Fatherjack ♦♦
38.8k ● 55 ● 69 ● 104

I don't think I can stop and disable the services, because I need to install a default instance of SQL 2005 (ultimate goal), and my understanding is that you cannot have two default instances, even if they are different versions, running on the same server. Right now, I have over 100 databases on the named 2000 instance that I am moving over, and it will take some time, but I really need the default 2000 instance to be 2005, because we have an app that will only run on a default instance.

Jul 23 '12 at 10:52 AM SDabbs

Agreed, there is one default instance. You state "we need to uninstall the default instance of SQL 2000 first without affecting the named 2000 instance" - Why cant you just stop the default instance rather than uninstal it?

Each instance shows up in the Services.msc as a separate service ...

Jul 23 '12 at 10:55 AM Fatherjack ♦♦

If you stop the default 2000 instance services, can you then install a 2005 default instance, i.e., stopping and disabling the 2000 default instance services has the same effect as uninstalling it (as far as installing a new default 2005 instance is concerned)?

Jul 23 '12 at 10:58 AM SDabbs

I don't know, my answer was phrased as a question that was meant to indicate that it might be worth trying rather than actually un-installing and then having a bigger job to rebuild your server if there is an error. Try it out on your test server and see which is the easier/more appropriate solution.

Once un-installed it will take a lot longer and a lot more effort to re-install than simply restarting the service that you stopped before your test.

Jul 23 '12 at 11:07 AM Fatherjack ♦♦

Thanks for the advice - we are going to prep a test server today.

Jul 23 '12 at 11:09 AM SDabbs

(comments are locked)