It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.
See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
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
| | | | +---sqlworkbenchprojectite
| | | | | +---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?
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
| | | | +---sqlworkbenchprojectite
| | | | | +---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?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
3
7 Comments
To start with, get all of your databases running on SQL 2005 - you can do this by detaching them from the old instances and re-attaching them to SQL 2005 (http://support.microsoft.com/kb/224071/EN-US/).
Once you are happy that all of your databases are running on SQL 2005 and your applications can connect to them, then you can uninstall the other instances (I would start with the MSDE and SQL 2000).
Then also uninstall SQL 2000 Books Online and samples.
Once you are happy that all of your databases are running on SQL 2005 and your applications can connect to them, then you can uninstall the other instances (I would start with the MSDE and SQL 2000).
Then also uninstall SQL 2000 Books Online and samples.
Okay, this will be a lot of work, based on the post. In the meantime, can I get rid of the mdmf files, and possibly the log files, in the "Reporting Services" subdirectory of MSSQL.2? Most of them aren't any more recent than May 2006? There seems to be two batches in that directory (all files are less than 1K unless noted):
Group 1 (Seems recent - starts at 11/9/2006, when I think I installed SQL Server 2005)
- A huge SQLDUMPER_ERRORLOG.log dated yesterday (552 MB)
- SQLDmpr10000.log
- SQLDmpr10000.mdmp
- SQLDmpr0667.suo
- SQLDmpr0667.sln
- About 48 files starting either with "ReportServerService_" or "ReportServerService_Main_
Group 2 (Most recent is 5/21/2006)
- 9,999 files ranging from 5/18/2006 to 5/21/2006 named "SQLDmprNNNN.log", where NNNN is a sequential number starting at 0001 and ending at 9999. Total size of all files, about 1.366 GB. Average file size: 137K.
- 9,999 files ranging from 5/18/2006 to 5/21/2006 named "SQLDmprNNNN.mdmp", where NNNN is a sequential number starting at 0001 and ending at 9999. Total size of all files, about 4.860 GB. Average File size: 486K.
Total size of both *.log and *.mdmp files between 5/18 and 5/21/2006: 6.226 GB.
Can I just delete these stinkin' files for now (those that go back to 5/18 to 5/21)? Don't know why the logs were being generated so foraciously. It looks like a log was created once every minute, with a few exceptions (<5%). Plus, like I said, I don't think I'm even using reporting services...I'm not that familiar with reporting services (obviously), but the only "reporting" I might do would be a crystal report bound to a DB.
Group 1 (Seems recent - starts at 11/9/2006, when I think I installed SQL Server 2005)
- A huge SQLDUMPER_ERRORLOG.log dated yesterday (552 MB)
- SQLDmpr10000.log
- SQLDmpr10000.mdmp
- SQLDmpr0667.suo
- SQLDmpr0667.sln
- About 48 files starting either with "ReportServerService_" or "ReportServerService_Main_
Group 2 (Most recent is 5/21/2006)
- 9,999 files ranging from 5/18/2006 to 5/21/2006 named "SQLDmprNNNN.log", where NNNN is a sequential number starting at 0001 and ending at 9999. Total size of all files, about 1.366 GB. Average file size: 137K.
- 9,999 files ranging from 5/18/2006 to 5/21/2006 named "SQLDmprNNNN.mdmp", where NNNN is a sequential number starting at 0001 and ending at 9999. Total size of all files, about 4.860 GB. Average File size: 486K.
Total size of both *.log and *.mdmp files between 5/18 and 5/21/2006: 6.226 GB.
Can I just delete these stinkin' files for now (those that go back to 5/18 to 5/21)? Don't know why the logs were being generated so foraciously. It looks like a log was created once every minute, with a few exceptions (<5%). Plus, like I said, I don't think I'm even using reporting services...I'm not that familiar with reporting services (obviously), but the only "reporting" I might do would be a crystal report bound to a DB.
Also, do I really need SQLExpress running concurrently with SQL Server 2005 just to allow "Manage Your Website" available?
I know this is extra info, so I'm increasing points.
I know this is extra info, so I'm increasing points.
...but, it is part of "Cleaning up SQL Server," in that you shouldn't need two versions running - otherwise, if it was a totally divergent question, I wouldn't have posted it.
You don't need SQL Express running at the same time as SQL Server 2005. Anything you can do with express you can do with the full version.
BEFORE you delete any files, uninstall al the software that you want to remove. At the end of this, you should have a single SQL Server instance. Then you can delete any remaining files in the other instance folders (MSSQL.1, etc). You need to identify which one of these is the now live SQL Server, and delete accordingly.
You can clear the dump and log files. However, these probably suggest that your SQL Server has been falling over recently (I suspect that is why you are cleaning up your machine). Delete as you wish.
BEFORE you delete any files, uninstall al the software that you want to remove. At the end of this, you should have a single SQL Server instance. Then you can delete any remaining files in the other instance folders (MSSQL.1, etc). You need to identify which one of these is the now live SQL Server, and delete accordingly.
You can clear the dump and log files. However, these probably suggest that your SQL Server has been falling over recently (I suspect that is why you are cleaning up your machine). Delete as you wish.
Featured Post
Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In part one, we reviewed the prerequisites required for installing SQL Server vNext.
In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month3 days, 18 hours left to enroll
630 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.