Re: Do I install SQL or MSDE
- From: v-yanniw@xxxxxxxxxxxxxxxxxxxx ("Jenny wu [MSFT]")
- Date: Tue, 22 Nov 2005 06:23:06 GMT
Hi Morris,
Thanks for using the SBS newsgroup! Also thanks for Mariette's input.
For your description, I understand that you have some concern about the
difference of MSDE and SQL. If I am off base, please don't hesitate to let
me know.
As Mariette said, Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) has
limitation of Database size of 2GB and concurrent connection of 25 users.
It is the free, redistributable version of SQL Server that is ideal for
client applications that require an embedded database.
You can refer to the following link to get detail inforation:
http://www.microsoft.com/sql/msde/default.asp
In SBS 2003 environment, after you setup SBS 2003 server box successfully,
WMSDE has been installed for your databases. It has not storage limits and
is fine in a small-scale environment, when you are hosting just a few Web
sites. But if your server suddenly gets popular and you need to start
hosting hundreds of sites, you may run into performance and storage
problems.
Some of the WMSDE Limitations as follows.
1)Cannot use WMSDE for web farm setup.
2)WMSDE overcomes limitations that MSDE has (like 2gb size limit, number
of simultaneous connections).. However you can't use it for anything else,
because you can only use it for a specified signed schema (WSS Schema).
3) No Full Text search.
4)The instance of WMSDE installed can be used only by WSS.
To get full text search, you can upgrade the instance SHAREPOINT from WMSDE
to SQL to get full text search function of Sharepoint services.
You can follow the instructions are outlined in Premiuminstallsteps.htm on
the root of the Premium CD to upgrade the instance SHAREPOINT to SQL and it
is no need to manually migrate data from MSDE to SQL server and all dada is
kept.
Before you do the upgrade process, I suggest you backup your Companyweb
data firstly in case any unexpected things happen. You can refer to the
following KB article to backup:
829112 How to back up and restore http://companyweb data in Windows Small
Business Server 2003
http://support.microsoft.com/?id=829112
And also you can refer to the following KB article to get detail
information to upgrade the instance of Microsoft SQL Server Desktop Engine
(Windows) (WMSDE) that is used for Windows SharePoint Services,
How to turn on full-text search in Windows SharePoint Services on a Windows
Small Business Server 2003-based computer
http://support.microsoft.com/default.aspx?scid=kb;en-us;837367
Related information:
841773 BUG: SQL Server Setup stops responding when you upgrade an instance
of
http://support.microsoft.com/?id=841773
Hope above information helps! If you have any further concern or question
on the issue please feel free to let me know. I am looking forward to your
reply!
Have a nice day!
Sincerely,
Jenny Wu
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.
Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.
For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.
Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>From: "Mariette Knap [SBS MVP]" <mariette@xxxxxxxxxxxxxxxxxxxx>
>References: <68937A68-642F-47EB-9714-695EA6F89271@xxxxxxxxxxxxx>
>Subject: Re: Do I install SQL or MSDE
>Date: Mon, 21 Nov 2005 21:20:52 +0100
>Lines: 21
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
>X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
>X-RFC2646: Format=Flowed; Original
>Message-ID: <#tgHTkt7FHA.740@xxxxxxxxxxxxxxxxxxxx>
>Newsgroups: microsoft.public.windows.server.sbs
>NNTP-Posting-Host: concentrix.xs4all.nl 213.84.171.103
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP11.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.windows.server.sbs:224361
>X-Tomcat-NG: microsoft.public.windows.server.sbs
>
>In news:68937A68-642F-47EB-9714-695EA6F89271@xxxxxxxxxxxxx,
>Morris <Morris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
>> I know that SBS ships with SQL I also know that ISA, WSUS, Sharepoint
>> all can use and deploy MSDE, With more programs requiring SQL should
>> I dploy SQL or work with the MSDE. I do relize that with MSDE if one
>> Data base hoses I will not bring down the entire server. just
>> wondering what other pros and cons there might be as to how my
>> instalations should go thanks Morris.
>
>MSDE has normally a 2GB limit. What programs require SQL for you?
>
>--
>Mariëtte Knap
>Microsoft SBS-MVP
>One of the Magical M&M's
>www.smallbizserver.net
>Take part in SBS forum:
>http://www.smallbizserver.net/Default.aspx?tabid=53
>
>
>
.
- References:
- Re: Do I install SQL or MSDE
- From: Mariette Knap [SBS MVP]
- Re: Do I install SQL or MSDE
- Prev by Date: RE: XP Clients getting EventIDs 14, 29 and 5719; can't process group policy
- Next by Date: RE: ExChSrv sends multiple copies of emails to users via POP3
- Previous by thread: Re: Do I install SQL or MSDE
- Next by thread: Re: This computer cannot be upgraded to the OEM version of Windows
- Index(es):
Relevant Pages
|
