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 ...