MSDE vs SQL2000 vs SQL2005 Express

Hi guys,

I'm currently using MSDE for SharePoint, Monitoring and WSUS on my SBS2003
Server. We purchased the premium edition but I never installed the full
version of SQL at the time as I didn't see a need for it. I was wondering if
upgrading to SQL2000 would provide better performance for the above databases?
Should I upgrade from MSDE to full SQL2000 that came with SBS?

...Now that SQL 2005 Express is out perhaps I should just upgrade directly to
SQL 2005 Express? I'm not sure if this is a good idea as I have heard both
good and bad things about installing SQL 2005 Express on a SBS2003 Server.

Everything is working fine so perhaps I should just stick with MSDE and adopt
the attitue "If it's not broken - don't try to fix it"

--
Message posted via http://www.winserverkb.com

.

Relevant Pages

  • Re: Do I install SQL or MSDE
    ... Thanks for using the SBS newsgroup! ... difference of MSDE and SQL. ... In SBS 2003 environment, after you setup SBS 2003 server box successfully, ...
    (microsoft.public.windows.server.sbs)
  • RE: Fail to install MSDE (log attached)
    ... trouble getting MSDE installed. ... Setup failed to configure the server. ... file located in the install directory where you are installing MSDE. ...
    (microsoft.public.sqlserver.msde)
  • RE: MSDE to SQL Server
    ... I understand that you want to upgrade MSDE instances ... We can upgrade the instance SHAREPOINT to SQL and it is not recommended ... Business Server 2003 ...
    (microsoft.public.windows.server.sbs)
  • Automatic setup of MSDE, Replication, IIS and SQL Server CE components
    ... Server CE 2.0 on a PocketPC and synchronizes against an MSDE 2000 using ... Installing the MSDE 2000 and running the procedures for creating the ... I know this is a complex task, but given that MSDE 2000 and SQL Server CE ...
    (microsoft.public.sqlserver.replication)
  • Automatic setup of MSDE, Replication, IIS and SQL Server CE components
    ... Server CE 2.0 on a PocketPC and synchronizes against an MSDE 2000 using ... Installing the MSDE 2000 and running the procedures for creating the ... I know this is a complex task, but given that MSDE 2000 and SQL Server CE ...
    (microsoft.public.sqlserver.msde)
Loading