Sunday, February 19, 2012

After Sql 2005 Install, Sql 2000 Still There

Hi.

I just downloaded and installed Sql 2005 from the MS site.
I see that my instance of Sql 2000 is still on the same computer.
I assumed that Sql 2005 would upgrade but it didnt. Should I
simply delete my instance of 2000 or will this cause complications?
Sorry - newbie question.pbd22 (dushkin@.gmail.com) writes:

Quote:

Originally Posted by

I just downloaded and installed Sql 2005 from the MS site.
I see that my instance of Sql 2000 is still on the same computer.
I assumed that Sql 2005 would upgrade but it didnt. Should I
simply delete my instance of 2000 or will this cause complications?


That depends on how you opted to do your installation: as a new instance
or an upgrade. Since you say that you downloaded SQL 2005 from MS,
I assume that you installed SQL Express, which by default is installed
as a named instance, SQLEXPRESS.

I would keep both instances, as you may want to compare SQL 2005 to
SQL 2000.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

No comments:

Post a Comment