RE: SBS2003 Sharepoint Limitations



Hello John,

Thank you for posting here.

According to your description, I understand that you want to know the
database limitations of sharepoint in SBS 2003. If I have misunderstood the
problem, please don't hesitate to let me know.

Based on my research, by default, the sharepoint uses WMSDE database to
store information, the limitations of sharepoint depend on database
limitations. There is some info about WMSDE database limitations:

WMSDE

The MSDE version that ships with Windows SharePoint Services is called as
Microsoft SQL Server 2000 Desktop Engine (Windows)-(WMSDE). WMSDE and has
no storage limits unlike MSDE.

When you install Microsoft Windows SharePoint Services on a single server
using the defaults, you have an installation that uses Microsoft SQL Server
2000 Desktop Engine (Windows) (WMSDE) for your databases. This 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.

Below mentioned link provides more information on the above.

http://www.microsoft.com/WindowsServer2003/technologies/sharepoint/default.m
spx

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.

If you use SBS 2003 or SBS 2003 sp1, you can try to update your WMSDE
database to SQL Server 2000 Desktop Engine

How to back up and restore installations of Windows SharePoint Services
that use Microsoft SQL Server 2000 Desktop Engine (Windows)
http://support.microsoft.com/?id=833797

If you use SBS 2003 R2, you can try to update your WMSDE database to SQL
Server 2005 Workgroup Edition, please go through the following KB:

How to upgrade the initial release of Windows Small Business Server 2003 R2
to include the final release version of SQL Server 2005 Workgroup Edition
http://support.microsoft.com/?id=924000

About SQL Server 2005 Workgroup Edition new features, please go through the
following page:

SQL Server 2005 Workgroup Edition Features Comparison page.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Hope info above will give you some help.

Thanks and have a nice day!

Best regards,

Terence Liu(MSFT)

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: "John Bouley" <spamjabouley@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
| Subject: SBS2003 Sharepoint Limitations
| Date: Thu, 18 Jan 2007 16:10:30 -0500
| Lines: 8
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
| Message-ID: <OYntWU0OHHA.4172@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.windows.server.sbs
| NNTP-Posting-Host: 038-149.lan.ma.np1.net 64.61.38.149
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:11277
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| Are there any size or number of document limitations to Sharepoint
Services?
| Currently out site is maintained by the MSDE and not the full SQL engine.
| Are there any differences if the database is upgraded to SQL?
|
| Thanks,
| John
|
|
|

.



Relevant Pages

  • Re: Maximum database size for WSS using SQL Server 2000
    ... When using SQL Server 2000, there are no limitations to database size. ... whole bunch of images into SharePoint, that will take up lots of storage ... times are caught by surprise as to the rapid growth of SharePoint databases. ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Event 27745 Error
    ... Additional error information from SQL Server is included below. ... We are worried that the SharePoint Services would crash one day, ... Unable to connect to database. ... information or message DLL files to display messages from a remote computer. ...
    (microsoft.public.windows.server.sbs)
  • Re: Error 18456 (MSSQL$SHAREPOPINT Service is Missing)!
    ... Is it possible that the SharePoint database has been upgraded to SQL Server? ... Event Source: MSSQL$SHAREPOINT ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Check the database connection information and make sure that the database ... Uninstall SQL Server; ... Reinstall Monitoring and Sharepoint and make sure they work; ...
    (microsoft.public.windows.server.sbs)
  • Re: What is the best databse to use and why?
    ... If you feel comfortable with it, and can live within the programming ... MySQL has limited development tools compared to Oracle or SQL Server, ... and has limitations in some coding areas. ... since a database you haven'tisted may better suit your needs. ...
    (microsoft.public.inetserver.asp.db)