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?
more ▼

asked Jul 20, 2012 at 03:58 PM in Default

SDabbs gravatar image

0 1 1 1

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
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
more ▼

answered Jul 20, 2012 at 05:26 PM

Kev Riley gravatar image

Kev Riley ♦♦
53.9k 47 49 76

(comments are locked)
10|1200 characters needed characters left
Do you need to uninstall or simply stop and disable the service?
more ▼

answered Jul 20, 2012 at 06:22 PM

Fatherjack gravatar image

Fatherjack ♦♦
42.8k 75 79 108

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, 2012 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, 2012 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, 2012 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, 2012 at 11:07 AM Fatherjack ♦♦
Thanks for the advice - we are going to prep a test server today.
Jul 23, 2012 at 11:09 AM SDabbs
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 20, 2012 at 03:58 PM

Seen: 518 times

Last Updated: Jul 23, 2012 at 11:49 AM