Advanced Microsoft SharePoint 2010 Upgrade Troubleshooting

1. OSP339 Advanced Microsoft SharePoint 2010 Upgrade Troubleshooting Todd Klindt SharePoint Nerd Rackspace

2. Who is this Todd guy? • WSS MVP since 2006 • Speaker, writer, consultant, Aquarius, President of Shane Young fan club • Personal Blogwww.toddklindt.com/blog • Company web sitewww.sharepoint911.com • E-mailtodd.klindt@rackspace.com • Twitter me! @toddklindt • Glad Shane doesn’t sign my paychecks

3. Unsupported Scenarios 2010 Upgrade Scenarios and Methods Supported Scenarios In-Place Upgrade Database Attach Upgrade: Content Database Profile Service Database Project Service Database Single Click Install - SQL Migration Windows Internal Database (WID) -> SQL Express 2008 + File Stream RBS Upgrade from earlier than WSS v3 SP2/MOSS 2007 SP2 Direct upgrade from WSS v2/SPS 2003 or earlier Side by side installation Gradual upgrade

4. Patches are your friends • For both SharePoint 2007 and 2010 • Find your patch level • http://www.toddklindt.com/sp2010builds • Lots of the 2007 patches are to make upgrade easier • http://technet.microsoft.com/en-us/office/sharepointserver/bb735839 • Why if you are doing 2010 wouldn’t you start patched?  • http://technet.microsoft.com/en-US/sharepoint/ff800847.aspx • Slipstream install • http://www.toddklindt.com/SP2010Slipstream

5. SP2007 - Stsadm.exe –o preupgradecheck • Available in v3 SP2 and later • Updated in multiple v3 CUs • Read only • Provides key information for upgrade • Farm configuration • Possible issues • Orphans • Modified databases • Missing customizations • Large lists

6. Screenshot of report

7. Test-SPContentDatabase • Can be used on 2007 or 2010 database • Read only • Safe • Can be ran often

8. Logging • 14\logs • Upgrade log per sessionError log per session ( -error.log) • Separate log for just errors • Shows callstacks • Upgrade logs always have same columns of data making reporting easier to automate.

9. Correlation IDs

10. MSDN ULSViewer • Allows you to scroll ULS logs in real time. • While scrolling you can: • Filter • Color code • Open multiple locations • A must have! • http://archive.msdn.microsoft.com/ULSViewer

12. PowerShell and ULS logs • Start-Transcript • New-SPLogFile • Closes out current ULS log and creates new log • Get-SPLogEvent • Allows you to query log files for specific criteria • Merge-SPLogFile • Combine log files from across the farm into one log • Don’t forget help with examples

13. Common Issues Some of our favorite gotchas

14. The Fab 40 • http://technet.microsoft.com/en-us/windowsserver/sharepoint/bb407286.aspx • Commonly referred to as the devil. • If you have them in 2007 it is best to leave them there. • Delete all webs that are built using these templates • Avoid putting them on 2010 at all costs

15. Custom themes in 2007 • Branding is all new in SharePoint 2010 and you should plan accordingly • Custom themes will not upgrade but if you have them in 2007 you must install them on 2010 server or you may have problems converting to v4 UI

16. Tools Take a look at our favorite tools and some quick demos

17. FeatureAdmin • http://featureadmin.codeplex.com/ • Great tool for finding missing/problem Features and removing them • Has 2007 and 2010 version

18. Remove Features with PowerShell • http://get-spscripts.com/2011/06/removing-features-from-content-database.html • PowerShell finds all webs and/or site collections using a specific Feature. Can also forcibly deactivate the Feature.

19. Diagnose missing setup files • http://get-spscripts.com/2011/06/diagnosing-missingsetupfile-issues-from.html • This command will expose to you how to find missing setup files by looking at the SQL Database. • Remember querying and/or editing a SharePoint database is not supported. Only use this is a test environment to find webs/site collections that need corrected.

20. Diagnose missing web parts • http://get-spscripts.com/2011/08/diagnose-missingwebpart-and.html • This script helps you to discover missing web parts by looking at the SQL database. • Remember querying and/or editing a SharePoint database is not supported. Only use this is a test environment to find webs/site collections that need corrected.

21. The Business Collaboration Platform for the Enterprise and the Internet The Business Collaboration Platform for the Enterprise & the Internet • Deliver the Best Productivity Experience • Cut Costs with a Unified Infrastructure • Rapidly Respond to Business Needs The capabilities of SharePoint 2010 provide a powerful business collaboration platform

22. Project and SharePoint Better Together Manage Resources Improve efficiency and save money by better managing work and allocation of resources Maximize Portfolio Returns Make informed investment decisions and effectively communicate results across a portfolio of projects Keep Teams ProductiveSave time and improve project results by centralizing team collaboration on deliverables and tasks Improve SharePoint ROI Effectively manage requests to maximize the ROI of your SharePoint environment • www.sharepoint.microsoft.com • www.microsoft.com/project

23. Resources Learning TechNet • Connect. Share. Discuss. • Microsoft Certification & Training Resources http://europe.msteched.com www.microsoft.com/learning • Resources for IT Professionals • Resources for Developers • http://microsoft.com/technet http://microsoft.com/msdn

24. Evaluations Submit your evals online http://europe.msteched.com/sessions

25. © 2012 Microsoft Corporation. All rights reserved. Microsoft, Windows, Windows Vista and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.