Solved
Cleaning Up SQL Server
Posted on 2006-11-23
I've gone through several iterations of local SQL Server installs on my machine and would like to know what I should / need to keep and what I can get rid of.
I first installed MSDE 2000. Created a bunch of databases.
Then installed Microsoft SQL Server 2000 standard edition.
Then installed Microsoft SQL Server 2005 from Visual Studio 2005.
Then installed Microsoft SQL Server Express (because I couldn't get website management tools to function using regular SQL Server 2005).
The SQL Programs listed in Add/Remove Programs (control panel) are:
-- Microsoft SQL Server 2000 (plus Books Online and Sample Database Scripts) Combined size 151.99 MB
-- Microsoft SQL Server 2005 (plus Backward Compatibility, Books Online, and Mobile Developer Tools) Combined size 8976.13 MB
-- Microsoft SQL Server Desktop Engine - 58.99 MB
-- Microsoft SQL Server Native Client - 4.16 MB
-- Microsoft SQL Server Setup Support Files (English) - 20.00 MB
-- Microsoft SQL Server VSS Writer - 0.66 MB
The folders in my [C:\Program Files\Microsoft SQL Server\] folder are:
Folder PATH listing
C:\PROGRAM FILES\MICROSOFT SQL SERVER
+---80
| +---COM
| | \---Resources
| | \---1033
| \---Tools
| +---Binn
| | \---Resources
| | \---1033
| +---Books
| +---DevTools
| | +---Include
| | +---Lib
| | \---Samples
| | +---ado
| | +---dblib
| | +---desktop
| | +---dts
| | +---esqlc
| | +---misc
| | +---msdtc
| | +---odbc
| | +---ods
| | +---oleauto
| | +---sqldmo
| | +---sqlns
| | +---sqlrepl
| | +---utils
| | \---xml
| +---HTML
| +---Install
| +---Scripts
| \---Templates
| +---DTS
| +---SQL Profiler
| \---SQL Query Analyzer
| +---Attach and Detach Database
| +---Create Database
| +---Create Function
| +---Create Index
| +---Create Procedure
| +---Create Statistics
| +---Create Table
| +---Create Trigger
| +---Create View
| +---Manage Extended Property
| +---Manage Linked Server
| +---Manage Login Role User
| \---Using Cursor
+---90
| +---COM
| | +---en
| | \---Resources
| | \---1033
| +---DTS
| | +---Binn
| | | \---Resources
| | | \---1033
| | +---Connections
| | | \---en
| | +---ForEachEnumerators
| | | +---en
| | | \---Resources
| | | \---1033
| | +---LogProviders
| | +---MappingFiles
| | +---Packages
| | +---PipelineComponents
| | | \---Resources
| | | \---1033
| | \---Tasks
| | \---en
| +---EULA
| +---NotificationServices
| | \---9.0.242
| | +---Bin
| | | +---de
| | | +---en
| | | +---es
| | | +---fr
| | | +---it
| | | +---ja
| | | +---ko
| | | +---zh-CHS
| | | \---zh-CHT
| | \---XML Schemas
| +---SDK
| | +---Assemblies
| | | \---en
| | +---Include
| | \---Lib
| | \---x86
| +---Setup Bootstrap
| | +---1033
| | +---Bin
| | +---BPA
| | | +---1033
| | | +---bin
| | | +---Repository
| | | | +---ASPNETUSERENCRYPTED
| | | | | \---bin
| | | | +---DBUNWRITABLE_UPGBLKR
| | | | | \---bin
| | | | +---DUPLICATEINDEX_UPGBLKR
| | | | | \---bin
| | | | +---DUPLICATESID
| | | | | \---bin
| | | | +---LOGINNAMEASSERVERROLE
| | | | | \---bin
| | | | +---RESERVEDATABASEID
| | | | | \---bin
| | | | +---RSCUSTOMASSEMBLIES
| | | | | \---bin
| | | | +---RSCUSTOMSECURITY
| | | | | \---bin
| | | | +---RSDEFAULTIIS
| | | | | \---bin
| | | | +---RSDEFAULTIISYUKON
| | | | | \---bin
| | | | \---YUK1_UPGBLKR
| | | | \---bin
| | | \---Schemas
| | +---Help
| | | \---1033
| | +---LOG
| | | \---Files
| | \---Resources
| | \---1033
| +---Shared
| | +---1028
| | +---1031
| | +---1033
| | +---1036
| | +---1040
| | +---1041
| | +---1042
| | +---2052
| | +---3082
| | +---ASConfig
| | +---ErrorDumps
| | \---Resources
| | \---1033
| \---Tools
| +---Bin
| +---binn
| | +---Resources
| | | \---1033
| | +---Samples
| | +---schemas
| | | \---sqlserver
| | | \---2004
| | | +---07
| | | | +---dta
| | | | +---queryprocessor
| | | | \---showplan
| | | +---bulkload
| | | | \---format
| | | +---SOAP
| | | | +---options
| | | | \---types
| | | | +---SqlMessage
| | | | +---SqlParameter
| | | | +---SqlResultStream
| | | | +---SqlRowCount
| | | | \---SqlTransaction
| | | \---sqltypes
| | \---VSShell
| | +---Common7
| | | +---IDE
| | | | +---1033
| | | | +---DataWarehouseDesigner
| | | | | +---DSVRefreshPage
| | | | | | \---Images
| | | | | +---KPIsBrowserPage
| | | | | | \---Images
| | | | | \---UIRdmsCartridge
| | | | +---HTML
| | | | | \---XMLLinks
| | | | | \---1033
| | | | +---PrivateAssemblies
| | | | | \---1033
| | | | +---profiles
| | | | +---ProjectItems
| | | | +---PublicAssemblies
| | | | +---Resources
| | | | | \---1033
| | | | +---SqlToolsData
| | | | | \---1033
| | | | +---sqlworkbenchprojectitems
| | | | | +---AnalysisServices
| | | | | | +---DMX
| | | | | | | +---Model Content
| | | | | | | +---Model Management
| | | | | | | \---Prediction Queries
| | | | | | +---MDX
| | | | | | | +---Expressions
| | | | | | | \---Queries
| | | | | | \---XMLA
| | | | | | +---Management
| | | | | | +---Schema Rowsets
| | | | | | \---Server Status
| | | | | +---Connections
| | | | | +---Sql
| | | | | | +---Aggregate
| | | | | | +---Assembly
| | | | | | +---Backup
| | | | | | +---Certificate
| | | | | | +---Database
| | | | | | +---Database Mail
| | | | | | +---Database Trigger
| | | | | | +---Default
| | | | | | +---Earlier Versions
| | | | | | | +---Attach and Detach Database
| | | | | | | +---Create Database
| | | | | | | +---Create Function
| | | | | | | +---Create Index
| | | | | | | +---Create Procedure
| | | | | | | +---Create Statistics
| | | | | | | +---Create Table
| | | | | | | +---Create Trigger
| | | | | | | +---Create View
| | | | | | | +---Manage Extended Property
| | | | | | | +---Manage Linked Server
| | | | | | | +---Manage Logins, Roles, and Users
| | | | | | | \---Using Cursor
| | | | | | +---Endpoint
| | | | | | +---Event Notification
| | | | | | +---Extended Property
| | | | | | +---Full-text
| | | | | | +---Function
| | | | | | +---Index
| | | | | | +---Linked Server
| | | | | | +---Login
| | | | | | +---Notification Services
| | | | | | +---Partition Function
| | | | | | +---Partition Scheme
| | | | | | +---Recursive Queries
| | | | | | +---Restore
| | | | | | +---Role
| | | | | | +---Rule
| | | | | | +---Service Broker
| | | | | | | +---Application
| | | | | | | +---Contract
| | | | | | | +---EndPoint
| | | | | | | +---MessageType
| | | | | | | +---Queue
| | | | | | | +---Route
| | | | | | | +---Security
| | | | | | | \---Service
| | | | | | +---SQL Trace
| | | | | | +---Statistics
| | | | | | +---Stored Procedure
| | | | | | +---Synonym
| | | | | | +---Table
| | | | | | +---Trigger
| | | | | | +---User
| | | | | | +---User-defined Data Type
| | | | | | +---User-defined Type
| | | | | | +---View
| | | | | | \---XML Schema Collections
| | | | | \---SQLCE
| | | | | +---Database
| | | | | +---Index
| | | | | \---Table
| | | | +---sqlworkbenchprojects
| | | | +---VS SCC
| | | | | \---1033
| | | | \---Xml
| | | | \---1033
| | | +---Packages
| | | | +---1033
| | | | \---Debugger
| | | | \---1033
| | | \---Tools
| | | \---VDT
| | | \---1033
| | +---SDK
| | | \---v2.0
| | | \---Bin
| | \---Xml
| | +---1033
| | | \---Snippets
| | \---Schemas
| | \---1033
| +---Books
| | \---1033
| +---Profiler
| | +---Templates
| | | +---Microsoft Analysis Services
| | | | \---90
| | | \---Microsoft SQL Server
| | | +---80
| | | \---90
| | \---TraceDefinitions
| | \---1033
| +---Reporting Services
| | \---SharePoint
| +---Samples
| | +---AdventureWorks Analysis Services Project
| | | +---Enterprise
| | | \---Standard
| | +---AdventureWorks Data Warehouse
| | \---AdventureWorks OLTP
| \---Templates
| \---olap
| \---1033
| +---Cube Templates
| | +---Adventure Works Enterprise Edition
| | \---Adventure Works Standard Edition
| \---Dimension Templates
+---InetPub
| \---wwwroot
+---MSSQL
| +---Binn
| | \---Resources
| | \---1033
| +---Data
| +---Install
| \---LOG
+---MSSQL.1
| +---MSSQL
| | +---Data
| | +---LOG
| | \---Template Data
| \---OLAP
| +---Backup
| +---bin
| | +---Cartridges
| | +---en
| | +---isapi
| | | \---Resources
| | | \---1033
| | \---Resources
| | +---1028
| | +---1031
| | +---1033
| | +---1036
| | +---1040
| | +---1041
| | +---1042
| | +---2052
| | \---3082
| +---Config
| +---Data
| | +---ExcelMDX.0.asm
| | +---System.0.asm
| | +---VBAMDX.0.asm
| | \---VBAMDXINTERNAL.0.asm
| \---Log
+---MSSQL.2
| \---Reporting Services
| +---LogFiles
| +---ReportManager
| | +---Bin
| | | +---de
| | | +---es
| | | +---fr
| | | +---it
| | | +---ja
| | | +---ko
| | | +---zh-CHS
| | | \---zh-CHT
| | +---de
| | | \---help
| | +---en
| | | \---help
| | +---es
| | | \---help
| | +---fr
| | | \---help
| | +---images
| | +---it
| | | \---help
| | +---ja
| | | \---help
| | +---js
| | +---ko
| | | \---help
| | +---Pages
| | +---Styles
| | +---zh-CHS
| | | \---help
| | \---zh-CHT
| | \---help
| +---ReportServer
| | +---bin
| | | +---de
| | | +---es
| | | +---fr
| | | +---it
| | | +---ja
| | | +---ko
| | | +---Resources
| | | | +---1028
| | | | +---1031
| | | | +---1033
| | | | +---1036
| | | | +---1040
| | | | +---1041
| | | | +---1042
| | | | +---2052
| | | | \---3082
| | | +---zh-CHS
| | | \---zh-CHT
| | +---Pages
| | +---ReportBuilder
| | | +---1028
| | | +---1031
| | | +---1036
| | | +---1040
| | | +---1041
| | | +---1042
| | | +---2052
| | | +---3082
| | | +---de
| | | +---es
| | | +---fr
| | | +---it
| | | +---ja
| | | +---ko
| | | +---zh-CHS
| | | \---zh-CHT
| | \---Styles
| \---RSTempFiles
\---MSSQL.3
\---MSSQL
+---Backup
+---Binn
| \---Resources
| \---1033
+---Data
+---Install
+---LOG
+---repldata
\---Template Data
The MSSQL.2 "Reporting Services" folder is huge (6+ GB) and has a bunch of mdmf and log files that I can't imagine ever using. In fact I don't think I'm using "Reporting Services" (I'm not generating any reports). Services running under Admin Tools : Services related to SQL Server are:
MSSQLSERVER {depends on SQL Server Agent}
SQL Server (SQLEXPRESS) {no dependencies}
SQL Server Active Directory Helper [not started] {no dependencies}
SQL Server Analysis Services (MSSQLSERVER) {no dependencies}
SQL Server Browser {no dependencies}
SQL Server Reporting Services (MSSQLSERVER) {no dependencies}
SQL Server VSS Writer {no dependencies}
SQL Server Agent {depended upon by MSSQLSERVER}
So, what I need is essentially Microsoft SQL Server 2005, but also, apparently, SQLExpress to "Manage a Website" in Visual Studio. If I delete the SQL2000 and MSDE apps, will I lose any of my databases? They all appear in SQL 2005 Management Studio - but I'm quite afraid.
Anyone out there got any suggestion on how to clean up this mess?