Service Pack 2 - PowerPoint PPT Presentation

and Office SharePoint Server

Service Pack 2

• Better memory management and performance
• Database performance improvements, indexes rebuilt using timer job
• Site collections become read only when database is set to read only
• More improvements to content deployment
• Better support for Office Clients using FBA
• Clients must have SP2

• Better support for IE 8
• Better support for Level 2 Browsers
• Firefox 3
• Additional STSADM commands

• Before
• After

• preupgradecheck
• variationsfixuptool
• enumallwebs
• exportipfsadminobjects
• listqueryprocessoroptions
• setqueryprocessoroptions

• Replacement to prescan.exe
• Uses rule files wss and oss
• Great tool to use now
• Installed features
• Language packs
• Sites and Servers
• AAM

• Administrator tool to fix variations used on publishing sites
• Ability to scan and fix errors in variation pages

• Shows all sites within a site collection
• Show all sites in a content DB
• Shows SiteID, WebIDs and....
• the Site Template used, great when doing export and import jobs

• export InfoPath Form Services admin objects
• Exports as a CAB file
• No importipfsadminobjects??

• Listqueryprocessoroptions show the current values
• Setqueryprocessoroptions use to change values from default
• Settings are applied at the SSP level

• Securitytrimmingcachesize
• Used to increase cache size, decrease request for security data from SQL
• Securitytrimmingmultiplier
• Used for large content base with limited user base
• Nearduplicatemultiplier
• Increase when you have multiple items that are similar
• Joinmultiplier
• Increase when you have items and metadata that are similar
• Sdidjoinmultiplier
• Increase when you have many results being removed via Search Results removal feature

• Backup
• nositelock – used to prevent a sitelock being applied during backup.
• Force – ignores disk space check
• osearch
• reprovisionindex
• Allows you to specify a new query server with no downtime.

• Updatefarmcredentials
• resume – similar to a force switch
• Deleteweb / deletesite
• Force
• Siteid
• Databasename
• databaseserver

• ONE WAY STREET!!
• Find your license key
• Test first
• Backup

• Both WSS and MOSS updates must be applied
• 32 or 64?
• Install WSS first
• Cancel the configuration wizard
• Install MOSS update
• Run configuration wizard
• Updates clients - SharePoint Designer

• Why?
• Copy your media to hard drive or USB

Download SP2 and run the following

• WSS
• wssv3sp2-kb953338-x64-fullfile-en-us.exe /extract:c:\WSS_SP2
• MOSS
• officeserver2007sp2-kb953334-x64-fullfile-en-us.exe /extract:c:\MOSS_SP2

• Copy all MSP files to \x64\updates or \x86\updates directory
• Copy both WSS and MOSS files
• Remove wsssetup.dll for MOSS

• WSS KB article
• http://support.microsoft.com/kb/953338
• WSS Fixes
• http://download.microsoft.com/download/7/A/3/7A3E2E01-5454-4427-95CB-28CE84523B0A/Windows%20SharePoint%20Services%203.0%20Service%20Pack%202%20Changes.xlsx
• MOSS KB Article
• http://support.microsoft.com/kb/953334
• MOSS Fixes
• http://download.microsoft.com/download/4/1/F/41F3A698-55E8-40B4-A306-AD6CF1F95394/2007%20Office%20Servers%20Service%20Pack%202%20Changes.xlsx

April Cumulative Update

• WSShttp://support.microsoft.com/kb/968850
• MOSS

http://support.microsoft.com/kb/968851