Re: After Sql 2005 Install, Sql 2000 Still There



pbd22 (dushkin@xxxxxxxxx) writes:
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@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.



Relevant Pages

  • Re: SQL Server 2005 Cluster Setup Quiz
    ... SQL Server 2005 failover cluster has been installed? ... drive of a SQL Server 2005 failover cluster installation? ...
    (microsoft.public.sqlserver.clustering)
  • Missing DLL during re-installation
    ... The installation appeared to complete successfully and I ... SQL Server Setup failed to execute a command for server configuration. ... Refer to the server error logs and Setup ...
    (microsoft.public.sqlserver.setup)
  • Re: Solution to do Accent Insensitive Full Text Search with SQL Server 2000
    ... Also note that SQL 2005 does support accent insensitive searching. ... Looking for a SQL Server replication book? ... Installing an accent insensitive version of Microsoft Search ... This is the installation program we will use to ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL Server Std over SBS 2003 std
    ... What Henry is referring to is that SBS2003 Premium comes with SQL2000 ... Sorry if I sound dumb but SQL is a whole new topic for me. ... You could just install SQL Server std on the SBS Box (that is what an ... You could also upgrade to SBS 3002 R2 Premium with SQL Server 2005 ...
    (microsoft.public.windows.server.sbs)
  • Re: Sharepoint Upgrade to SQL Server Halts at Setup is Preparing to Copy Files
    ... associated SQL Agents/dependant services and then start the upgrade or 2) ... Once the other instances are stopped see if the setup continues.. ... > We already have SQL Server installed on our server prior to this upgrade, ...
    (microsoft.public.windows.server.sbs)