In this chapter, you learned that:
q MOSS is more advanced (and, therefore, more complicated to install) than WSS.
q MOSS has a different type of SQL Express database compared to WSS, which is limited to 4 GB.
q MOSS features:
q Targeting of information on the portal site.
q Global searching, both inside SharePoint and outside.
q My Site is used both as a personal web site for the user and to describe the user's properties, such as the e-mail address, phone numbers, department, picture, and much more.
q The license model for MOSS is based on the edition selected, Standard or Enterprise; the number of MOSS servers; and number of client access licenses (CAL) that can access MOSS.
q Even if you only read information in the portal site, you will need a separate CAL.
q MOSS can use MS SQL Server 2005 or 2000.
q MOSS can use a local or remote database. A local database can be either SQL Express or MS SQL Server 2000/2005.
q You learned the following definitions:
q Stand-alone: MOSS with a local SQL Express.
q Single-Server: MOSS with a local MS SQL Server 2000/2005.
q Front-End Server: A server that has MOSS binaries installed and running one or more of the MOSS roles.
q Back-End Server: A server running MS SQL, used by MOSS for storing data.
q Small farm: MOSS with a remote server running MS SQL Server 2000/2005.
q Large and medium farm: A MOSS configuration with two or more MOSS servers running one or more roles, such as the Web, Index and Search roles.
q The Web service: The service responsible for contact with the user client.
q The Search service: The service responsible for answering any search queries from the client.
q The Index service: The service responsible for crawling through and indexing information.
q There are seven different databases in MOSS, used either for administrative purposes or for storing content in user web sites.
q If you implement the Single Sign-On feature of MOSS, it creates one more database type.
q There may be any number of content databases, but only one each of the other types.
q Hardware requirements for MOSS are higher than for WSS.
q You can use the formula for calculating the normalized operations per second (NOPS) to find out the load for a given user population was covered.
q Even a small farm may support up to 10,000 users in a typical organization, as long as the hardware is properly configured.
q You should make sure that the SQL Server always has at least 50 percent free disk space for its maintenance utilities.
q MOSS requires ASP.NET 2.0 and Windows Workflow Foundation with the .NET 3.0 Framework.
q MOSS uses several more web applications, virtual IIS web sites, than WSS.
q The security account for the application pool is used when communicating with the database.
q There are a number of service accounts that you can define during the installation of MOSS, such as:
q The application pool security account.
q The default content access account.
q The configuration database user account.
q A Basic installation of MOSS is very easy and fast to perform; it does not ask about the application pool security account or the configuration database user account.
q The installation of MOSS must be followed by an installation of the latest service pack.
q Some of the new file directories created during the MOSS installation are:
q C:\Program Files\Common Files\Microsoft Shared\web server exten-sions\12: This is the general file structure for all site definitions and features of MOSS and/or WSS.
q C:\Program Files\Microsoft Office Servers\12.0: This location has several folders and files specific to SharePoint 2007, including the search index.
q C:\Program Files\Microsoft Microsoft Office Servers\12.0\Data\MSSQL: This folder structure stores the SQL Express content.
q You can use the SharePoint Central Administration tool for complete backups of all data including all portal sites, all team sites, and index files.
q You can upgrade a local SQL Express database to MS SQL Server 2005. This is a straightforward process.
q It is possible to migrate from a local SQL Express database to a remote version of MS SQL Server, but it is a complicated process. Check Microsoft's Knowledge Base for more details on this procedure.
q You can uninstall MOSS in several ways:
q Remove the portal site but not the binaries.
q Remove the binaries but not the databases (must be an Advanced installation of MOSS).
q Remove everything.
q When removing SharePoint completely, you must start by removing MOSS, which also removes WSS, and then the database, if you used a local database.
In the next chapter, you will learn more about managing and configuring this new MOSS environment.