WSS 3.0 & SharePoint 2007 Updates: The Tour Starts Here

1. WSS 3.0 & SharePoint 2007Updates: The Tour Starts Here Presented by: JD WadeSharePoint Engineer, MCTS, MCSE Mail: jd.wade@hrizns.com Blog: http://wadingthrough.wordpress.com Twitter: JDWade FriendFeed: http://friendfeed.com/jdwade

2. Agenda • Overview of Updates • Installation Recommendations • Deployment Process • Slipstream Process SharePoint

3. Overview • First security patch released in September 2007 • SP1 released in December 2007 • Infrastructure Update released in July 2008 • Security patch released August 2008 • August 2008 Cumulative Updates Released • Security patch released October 2008 • October 2008 Cumulative Updates Released • Security patch released November 2008 • Coming Soon: Dec. 2008 Cumulative Updates Released • Coming Soon: Jan. 2009 -- Standard support for RTM (SP0) ends • Coming Soon: Feb-April 2009: Service Pack 2 SharePoint

4. SP1 Overview • Fixes Requiring Registry Change to Activate • KB 932619: Case-sensitive web content crawling • KB 937775: Search results for doc lib or lists not returned when using SQL query to sort • KB 937039: Search content contain particular Chinese Traditional characters • KB 931008: WSS 2.0 Upgrade, Application Pool set to “Network Service” SharePoint

5. SP1 Overview • Fixes Requiring Other Changes to Activate • KB 934577: Support for crawls of FBA or cookie based authentication sites • KB 934253: Web File Properties dialog box displays incorrect properties • KB 934613: Fix for Features with UserSelectionMode or UserSelectionScope attribute SharePoint

6. SP1 Overview • New stsadm commands (WSS) • KB 939035stsadm –o mergecontentdbs • KB 939535 (for host-named site collections)stsadm –o renamesite KB 942388: Object Model SPSite.Rename made public • KB 939809stsadm –o tzmove SharePoint

7. SP1 Overview • New stsadm commands (SharePoint) • Technetstsadm –o peoplepicker-searchadcustomfilterstsadm –o peoplepicker-serviceaccountdirectorypathstsadm –o peoplepicker-setsiteaccountdirectorypathstsadm –o peoplepicker-getsiteaccountdirectorypath SharePoint

8. Infra Update Overview • New Features • Search 2008 Functionality • Change Logs Maintained • Improved update speeds • Support for Kerberos access to SSP Web Services • Search crawl speed improved including incremental crawls • Fixes • Content Deployment Updates • BDC Fixes • Issues • Reverse Proxy SharePoint

9. Infra Update Overview • Fixes Requiring Other Changes to Activate • KB 953289: Support for declarative workflows to start automatically with e-mail • KB 953630: A Declarative Workflow does not resume when a Delay activity is triggered SharePoint

10. August 2008 Security Patch • Watch timer logging levels (MS KB 941789) August 2008 Cumulative Update Overview SharePoint • Numerous fixes • Reverse Proxy issue fixed (MS KB 956248)

11. October 2008 Cumulative Update Overview • Numerous fixes SharePoint

12. Recommendations • Install W2K3 Post SP1 or SP2 Hotfix 946517 • Prior to install of WSS/SharePoint fixes • More stable OWS Timer, solves IIS Manager unresponsive issue, & prevents DCOM errors among other problems SharePoint

13. Recommendations • Install .Net Framework 3.5 SP1 • Prior to install of WSS/SharePoint fixes • Must have WSS/MOSS SP1 installed to be supported • Installs .Net Framework 2.0 SP1 & 3.0 SP1 • Installs AJAX components • Multiple issues resolved • Consider AjaxifyMOSS on Codeplex SharePoint

14. Recommendations • Install SharePoint Admin Toolkit 2.0 • Install after WSS/SharePoint Updates • Requires WSS/MOSS SP1 • Adds Batch Site Manager • Adds stsadm command to update alerts urls • Adds Replication Manager SharePoint

15. Recommendations • Install Updated FoxIt PDF iFilter • Install after WSS/SharePoint Updates • Already have to reinstall after WSS/SharePoint fixes • 32-bit & 64-bit (May ‘08) • Install MS Filter Pack (KB 946336) • Install after WSS/SharePoint fixes • SP1 already breaks a couple types (KB 943102) • Same work, additional types enabled SharePoint

16. Deployment Check Disk Space Backup and verify restore Backup OOB Files

17. Deployment Document content databases Stsadm –o enumcontentdbs Run Orphan Repair Tool Stsadm –o databaserepair Run DBCC CHECKDB on databases Check database sizes

18. Deployment Disable anti-virus software (KB 936867) Verify No UpgradeTimer Jobs Defragment indexes in SQL (KB 943345) Rename previousupgrade logs Backup

19. Deployment Stop WWW service on all WFE Preparetomoveand Disconnect ContentDatabases Logon as Setup Run packages Cancel Wizard

20. Deployment Central Administration Run upgrade (KB 948780)Using psconfig

21. Deployment Verify upgrade

22. Deployment • Application • Web Front End Run upgradeUsing psconfig

23. Deployment Start WWW service on all WFE Enable anti-virus software (KB 936867) Install language pack updates Attach databases

24. Deployment Complete full crawl Backup Done

25. Deployment Process Pre-steps (complete prior to upgrade) Check for adequate disk space for binaries, index files (2.85 times), SQL database files (incl. tempdb), temp file locations, and log files. Backup farm and verify restore capabilities.See backup notes here: http://technet.microsoft.com/en-us/library/cc706876.aspx Backup any SharePoint out-of-box files you have customized Document content databases (stsadm –o enumcontentdbs) Check content database sizes (<100GB, load balance Site Coll.) Run orphan repair tool (KB 923904: stsadm –o databaserepair). Run DBCC CHECKDB on all databases and address any errors. Defragment databases (KB 943345). Verify no upgrade timer jobs exist (see Deployment Guide). SharePoint

26. Deployment Process Upgrade steps Backup farm just prior to upgrade Rename upgrade log file on all servers (file is cumulative). Disable anti-virus (KB 936867). Stop the WWW service on all WFE. To speed up upgrade or if content DBs are greater than 25GB, preparetomove and then disconnect databases (can use batch file). Logged in as the Setup account, run appropriate packages. Cancel SharePoint Configuration Wizard each time. Determine best first server to run upgrade (see Deployment Guide) Run upgrade using “psconfig –cmd upgrade –inplace b2b” command line. Upgrade Process is fully described in KB 948780(Baretail can be used to monitor upgrade log). SharePoint

27. Deployment Process Verify upgrade was successful using the upgrade log. Check the version number in CA (see Deployment Guide). Complete upgrade on all other servers as described in above order If you detached databases, begin attaching again one by one, upgrade process will be done when they attach. There is a more advanced parallel upgrade process for very large farms available in deployment document. Install WSS and SharePoint Language Pack updates for both WSS and SharePoint. Enable anti-virus (KB 936867) Start the WWW service on all WFE Complete a full crawl of all SharePoint content [New features and change log lost with detach (KB 949603)] Backup farm SharePoint

28. Installation Order & Links • Infrastructure Updatehttp://blogs.msdn.com/sharepoint/archive/2008/07/15/announcing-availability-of-infrastructure-updates.aspx • August 2008 Cumulative Updatehttp://blogs.msdn.com/sharepoint/archive/2008/09/29/announcing-august-cumulative-update-for-office-sharepoint-server-2007-and-windows-sharepoint-services-3-0.aspx • October 2008 Cumulative Updatehttp://blogs.msdn.com/joerg_sinemus/archive/2008/10/29/the-october-cumulative-update-for-wss-v3-and-moss-2007.aspx • Deployment Guidehttp://go.microsoft.com/fwlink/?linkID=105621&clcid=0x409 • Updates Resource Centerhttp://technet.microsoft.com/en-us/office/sharepointserver/bb735839.aspx SharePoint

29. Slipstream WSS-MOSS Copy Source to Installation Point

30. Slipstream WSS-MOSS Updates Extract the update package(s) <package> /extract:<path>

31. Slipstream WSS-MOSS Updates Delete the wsssetup.dll file(s) wsssetup.dll

32. Slipstream Done WSS-MOSS Updates Copy the extracted filesto the Updates folder

33. Q & A