Yo mates – harryb here – publisher of the above title. I am posting up a passage as a daily virtual book reading 🙂
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 5 Installing 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_ServerName_1 .mdf_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!