200 likes | 494 Views
Windows SharePoint Services and Office SharePoint Server. Service Pack 2. Enhancements / Fixes and Additions. 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
E N D
Windows SharePoint Services and Office SharePoint Server Service Pack 2
Enhancements / Fixes and Additions • 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
Enhancements / Fixes and Additions • Better support for IE 8 • Better support for Level 2 Browsers • Firefox 3 • Additional STSADM commands
And the ugly • Before • After
New STSADM Commands • preupgradecheck • variationsfixuptool • enumallwebs • exportipfsadminobjects • listqueryprocessoroptions • setqueryprocessoroptions
preupgradecheck • Replacement to prescan.exe • Uses rule files wss and oss • Great tool to use now • Installed features • Language packs • Sites and Servers • AAM
variationsfixuptool • Administrator tool to fix variations used on publishing sites • Ability to scan and fix errors in variation pages
enumallwebs • 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
exportipfsadminobjects • export InfoPath Form Services admin objects • Exports as a CAB file • No importipfsadminobjects??
listqueryprocessoroptionssetqueryprocessoroptions • Listqueryprocessoroptions show the current values • Setqueryprocessoroptions use to change values from default • Settings are applied at the SSP level
setqueryprocessoroptions • 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
STSADM additions • 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.
STSADM additions • Updatefarmcredentials • resume – similar to a force switch • Deleteweb / deletesite • Force • Siteid • Databasename • databaseserver
Installing Service Pack 2 • ONE WAY STREET!! • Find your license key • Test first • Backup
Installing Service Pack 2 • 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
Slipstream • 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
Slipstream • Copy all MSP files to \x64\updates or \x86\updates directory • Copy both WSS and MOSS files • Remove wsssetup.dll for MOSS
Resources • 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
Just when you thought it was under control April Cumulative Update • WSShttp://support.microsoft.com/kb/968850 • MOSS http://support.microsoft.com/kb/968851