Which SQL Server installations I can remove?

  • I installed Visual Studio 2010 Professional Edition. It came with SQL Server 2008 Express Edition. Later I installed SQL Server 2008 R2 with Advanced Services. In the Windows 7 installed programs list, I could see following installations:

    Microsoft SQL Server 2008

    Microsoft SQL Server 2008 R2

    Microsoft SQL Server 2008 R2 Data-Tier Application Framework

    Microsoft SQL Server 2008 R2 Data-Tier Application Project

    Microsoft SQL Server 2008 R2 Management Objects

    Microsoft SQL Server 2008 R2 Native Client

    Microsoft SQL Server 2008 R2 Policies

    Microsoft SQL Server 2008 R2 Setup (English)

    Microsoft SQL Server 2008 R2 Transact-SQL Language Service

    Microsoft SQL Server 2008 R2 Setup Support Files

    Microsoft SQL Server Browser

    Microsoft SQL Server Compact 3.5 ENU

    Microsoft SQL Server Compact 3.5 ENU SP1 Design Tools English

    Microsoft SQL Server Compact 3.5 SP2 ENU

    Microsoft SQL Server Compact 3.5 SP2 Query Tools ENU

    Microsoft SQL Server Database Publishing Wizard 1.3

    Microsoft SQL Server Database Publishing Wizard 1.4

    Microsoft SQL Server Native Client

    Microsoft SQL Server System CLR Types

    Microsoft SQL Server VSS Writer

    I want to use SQL Server on single PC as of now and I don't want to use any Compact Edition. I am also confused with the first two items in the above list.

    Please let me know which installations I can remove?

    "Here is a test to find out whether your mission in life is complete. If you're alive, it isn't. "

    Richard Bach

  • You're safe to remove Microsoft SQL Server 2008 as that looks like its the Express instance you installed.

    Everything which says 2008R2 is part of the second instance you installed (the one you say you want to keep) - and the other stuff is shared components being used by both instances - removing them would cause problems for the instance you are leaving installed.

    I think the Compact Edition is installed as part of Visual Studio which may explain why you have two different versions of it installed - but I may be wrong.

    http://sqlvince.blogspot.com/[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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