WSS3MOSS2K7 SP1 STLSUG_May08

1
WSS 3.0 SharePoint 2007Service Pack 1 The
Tour Starts Here
Presented by JD Wade, SharePoint
Consultant MCTS MOSS 2007 Config, MCTS WSS 3.0
Config, MCSE E-Mail jd.wade_at_hrizns.com Blog
http//wadingthrough.wordpress.com Twitter
http//twitter.com/JDWade
2
Agenda

• Contents of Service Pack 1
• Installation Recommendations
• Deployment Process
• Slipstream Process for MOSS

SharePoint
3
Overview

• Released in December 2007
• Over 200 individual fixes or improvements

SharePoint
4
Overview

• Web content/collaboration fixes and improvements
• KB 926284, 929360, 931637, 932055, 932918,
  932922, 937207, 937498, 937906, 938183, 938241
• Search fixes and improvements
• KB 933939, 934249, 936877, 937039, 937203,
  937904, 938569

SharePoint
5
Overview

• Infrastructure fixes and improvements
• KB 939599, 932347, 933138, 934882, 935605,
  935958, 938663, 939188
• Multiple category fixes
• KB 934793, 936867, 937208, 937901, 939077,
  942390, 942388, 931636. 934790, 938536, 935592
• Enterprise features fixes and improvements
• KB 937906

SharePoint
6
Overview

• Development fixes including AJAX support
• KB 932056, 941955
• Change in security for Designer Workflows
• KB 947284
• External storage API
• KB 938499

SharePoint
7
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
8
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
9
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
10
Overview

• New stsadm commands (SharePoint)
• Technetstsadm o peoplepicker-searchadcustomfilt
  erstsadm o peoplepicker-serviceaccountdirectoryp
  athstsadm o peoplepicker-setsiteaccountdirectory
  pathstsadm o peoplepicker-getsiteaccountdirector
  ypath

SharePoint
11
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
• Install .Net Framework 2.0 3.0 SP1
• Prior to install of WSS/SharePoint fixes
• Multiple SharePoint issues resolved
• See Aaron Stebners blog for .NET AIP instructions

SharePoint
12
Recommendations

• Install Blackout Rollups
• Install after WSS/SharePoint SP1
• KB 948945, 948947, 948957
• Includes Post SP1, Oct 07 and Dec-Feb fixes
• Install Updated FoxIt PDF iFilter
• Already have to reinstall after WSS/SharePoint
  fixes
• 32-bit (Mar 08), 64-bit (Dec 07)

SharePoint
13
Recommendations

• Install MS Filter Pack (KB 946336)
• Install after WSS/SharePoint fixes
• More types indexed with same work(KB 943102)
• Known Issue GroupBoard Workspace 2007(KB
  941678)
• If used, install update prior to patching

SharePoint
14
Deployment
15
Deployment
16
Deployment
17
Deployment
18
Deployment
19
Deployment
Central Administration
20
Deployment
21
Deployment

• Application
• Web Front End

22
Deployment
23
Deployment
Done
24
Deployment Process

• Check for adequate disk space for binaries, index
  files, and log files.
• Backup farm and verify restore capabilities.
• Run orphan repair tool (KB 923904 stsadm o
  databaserepair).
• Defragment databases (KB 943345).
• Verify no upgrade timer jobs exist (see
  Deployment Guide).
• Disable anti-virus (KB 936867).
• Rename upgrade log file (file is cumulative).
• Stop the WWW service on all WFE.
• To speed up upgrade or if content DBs are greater
  than 25GB, preparetomove and then disconnect
  databases using batch file after documenting
  content database settings (stsadm o
  enumcontentdbs).

SharePoint
25
Deployment Process

• Run WSS SP1 package on all WFE and Application
  servers. Cancel SharePoint Configuration Wizard.
• Run SharePoint SP1 package on all WFE and
  Application servers. Cancel SharePoint
  Configuration Wizard.
• Run blackout packages on all WFE and Application
  servers. Cancel SharePoint Configuration Wizard.
• Determine best first server to run upgrade (see
  Deployment Guide)
• Run upgrade using psconfig command line which
  allows you to monitor upgrade more closely on
  first server chosen. Upgrade Process is fully
  described in KB 948780
• 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

SharePoint
26
Deployment Process

• Install WSS and SharePoint Language Pack SP1
  updates.
• 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.
• Enable anti-virus (KB 936867)
• Start the WWW service on all WFE
• Complete a full crawl of all SharePoint content
  (KB 949603)
• Backup farm

SharePoint
27
Slipstream
WSS-MOSS
Copy Source to Installation Point
28
Slipstream
WSS-MOSS
Updates
Extract the update package(s)
/extract
29
Slipstream
WSS-MOSS
Updates
Delete the wsssetup.dll file(s)
wsssetup.dll
30
Slipstream
Done
WSS-MOSS
Updates
Copy the extracted filesto the Updates folder
31
Q A