Skip to Main Content
Essential SharePoint
book

Essential SharePoint

by Jeff Webb
May 2005
Beginner content levelBeginner
336 pages
10h 14m
English
O'Reilly Media, Inc.
Content preview from Essential SharePoint

Appendix A. Upgrading

Upgrading to SQL 2000

The default installation of SharePoint uses WMSDE as the data engine for the content and configuration databases. WMSDE runs locally on the server and limits the total size of SharePoint sites to 2 GB per content database. However, WMSDE does not limit performance, which is a change from previous versions of the data engine.

Upgrading from WMSDE to SQL 2000 (SP3a) on a shared server increases the capacity of SharePoint sites and simplifies maintenance since you can use SQL Server Enterprise Manager to configure automated back-ups and perform other tasks.

Upgrading the databases to a dedicated server running SQL 2000 can significantly improve performance as well as capacity, particularly for high-volume sites.

If you install SQL 2000 on a shared server after installing SharePoint, setup should upgrade the WSMDE server instance to use SQL 2000. To verify the data engine used by a server instance:

  1. Start SQL Server Enterprise Manager.

  2. Register the server instance. SharePoint names the instance machinename /SHAREPOINT by default.

  3. Select the server instance and choose Action Properties.

  4. Check the Product name at the top of the General tab of the Properties dialog. The name should be SQL Server editionname.

If SharePoint was installed using the Typical Installation option on a server already running SQL Server 2000, Setup still configures SharePoint to use WMSDE. To upgrade without reinstalling SQL Server:

  1. Use SQL Enterprise Manager to copy the content ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SharePoint User's Guide

SharePoint User's Guide

Infusion Development Corp. (Infusion Development Corporation)
Beginning SharePoint® 2010: Building Business Solutions with SharePoint

Beginning SharePoint® 2010: Building Business Solutions with SharePoint

Amanda Perran, Shane Perran, Jennifer Mason, Laura Rogers

Publisher Resources

ISBN: 0596008805Errata Page