Solved

Uninstall SQL Server 2000 on SBS2003

Posted on 2011-09-08
2
338 Views
Last Modified: 2012-05-12
Hello,

I have SQL Server 2000 and SQL Sever 2005 running on my SBS2003. There are no custom applications using the SQL Server 2000 anymore. To reduce space and memory usage I would like to uninstall SQL Server 2000. Is this possible? Or is the SQL Server 2000 needed by the SBSServer itself (e.g. for Sharepoint that we are not using or by the SBS Monitoring)?

These are the installations:
list of installed server programs

Thanks in advance!!

Chris
0
Comment
Question by:skiaholic
2 Comments
 
LVL 13

Accepted Solution

by:
stergium earned 500 total points
ID: 36509525
hello.
sbs2003 does not have sqlserver installed as a product. its an addon.  sbs monitoring is using msde not 2000 (unless otherwise stated/configured)
so yes you can uninstall it.
hope that helps
0
 

Author Comment

by:skiaholic
ID: 36522476
Thanks a lot for the info.
I did uninstall SQL Svr 2000.

In the list of installed porgrams there is "Hotfix 2055 for SQL Server 2000 ENU (KB960082)". It takes 1 GB of disk space.  
I suppose that I can uninstall this as well. However when trying to uninstall it asks whether I would like to uninstall instance "SBSMonitoring (SP 2055 ENU)". I think it is better not to do this. SBS Monitoring is a standard functionality of the SBS, right? Is this needed. It says it was used last time in 2008.


Can you please give me your advice? Thanks!
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Extract XML Data from using TSQL 5 32
BULK INSERT most recent CSV 19 21
Slow SQL query 12 29
add 1 to a field for 100 rows 11 24
Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now