70-282 Exam Cram: Upgrading SharePoint [Microsoft Small Business Specialist Primer book]

Yo mates – harryb here – publisher of the above title. I am posting up a passage as a daily virtual book reading 🙂

Upgrading SharePoint

SharePoint comes included with SBS (standard and premium editions) using the MSDE (Microsoft SQL Desktop Engine). Even though the 2 GB size limit and maximum user restriction of five have been removed from the MSDE, you should upgrade SharePoint to use a full instance of SQL server to take advantage of its indexing and search capabilities. Here again, if we were true to version# you know that you can’t really upgrade to SharePoint 3.0 in SBS. Microsoft has a document (Installing Windows SharePoint Services 3.0 on a Server Running Windows Small Business Server 2003 – just use your favorite search engine to find it) explaining that an in-place upgrade from WSS2.0 is currently not supported and a side-by-side installation is strongly recommended.

So, there is real life and then there is the Microsoft exam. Reverting back to doing an upgrade from the MSDE to SharePoint on SQL2000, SQL the Microsoft recommended steps are as follows:

When installing SQL server to upgrade SharePoint, make sure you:

• Stop the http://companweb website (in Internet Information Services).

Chapter 5Installing Windows Small Business Server 2003

·           Stop the MSSQL$SHAREPOINT Service.

·                       Select UPGRADE when prompted (do not install a new instance).

·                       Choose SHAREPOINT from the upgrade box.

·                       Install SQL SP3a after the SQL upgrade.

·                       Check that the MSSQL$SHAREPOINT Service started.

·                       Start http://companyweb.

IMPORTANT: SQL Service Pack 3a must be installed on every single instance of an SQL new install or upgrade. If you install a new instance and upgrade SharePoint to use an SQL instance, you must install SQL SP3a for each individual instance.

Before you undergo this procedure it is recommended that you back up the SharePoint database files which are located at:

%SystemDrive%\Program Files\Microsoft SQL Server\MSSQL$ SHAREPOINT\data

and back up the following files:

·                       STS_ServerName_1 .mdf

·                       STS_Config.mdf

·                       STS_ServerName_1 .mdf_log.LDF

·                       STS_Config_log.LDF


Harry Brelsford, CEO at SMB Nation (www.smbnation.com)

MBA, MCSE, CNE, CLSE, CNP, MCP, MCT, SBSC (Microsoft Small Business Specialist)

PS – did you know my Windows Small Business Server 2008 (SBS 2008) book is almost here? Yes!


1 Comment

Filed under Book

One response to “70-282 Exam Cram: Upgrading SharePoint [Microsoft Small Business Specialist Primer book]

  1. Pingback: Microsoft SharePoint Articles on 11 Dec 08 | Microsoft SharePoint & Windows (Vista, Azure, 7) Cloud & Social Computing Space

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s