Welcome to the Minnesota SharePoint User Group

1. Welcome to the Minnesota SharePoint User Group

2. Agenda • Introductions / Overview • SharePoint News • SharePoint Administration • CommVault Demonstration • Q & A

3. Introductions – MNSPUG Sponsors • Inetium (www.inetium.com) • Twin Cites based Microsoft consulting company • Microsoft Gold Certified Partner • Practice Area focused on Information Worker Technologies • New Horizons – Minnesota (www.newhorizonsmn.com) • Microsoft Gold Certified Partner • Training on many technologies • Microsoft (www.microsoft.com) • I’m guessing you’ve heard of them

4. User Group Goal / Objectives • Build a local community focused on Microsoft SharePoint Technologies • Educate user group members about SharePoint Technologies • Transfer knowledge within the community • Communicate best practices • Introduce new products / solutions

5. www.sharepointmn.com • Website for user group • SharePoint resource documents • SharePoint resource websites links • RSS Feeds • Meeting Schedule • Past User Group Presentations www.sharepointmn.com

6. Upcoming Schedule • Next Meeting • March 9th 9:00 AM to 11:00 AM • Microsoft’s Bloomington Office • Topic: To Be Announced • Ongoing Schedule • 2nd Wednesday of every month • 9:00 to 11:00 am • Microsoft’s Bloomington Office

7. SharePoint News • New SDK’s for SharePoint are available online (WSS / SPS) • Windows SharePoint Services Software Development Kit (SDK) • http://www.microsoft.com/downloads/details.aspx?familyid=1C64AF62-C2E9-4CA3-A2A0-7D4319980011&displaylang=en • Released 2/3/2005 • Web Part Framework • Server-side object model • Web services • Collaborative Application Markup Language (CAML) • RPC protocol • Client-side APIs

8. SharePoint News • New SDK’s for SharePoint are available online (WSS / SPS) • SharePoint Portal Server 2003 Software Development Kit (SDK) • http://www.microsoft.com/downloads/details.aspx?familyid=aa3e7fe5-daee-4d10-980f-789b827967b0&displaylang=en • Released 2/3/2005 • An expanded introduction to SharePoint Portal Server • New Code Snippets section • New FAQ section • Expanded Concepts and Architecture section

9. SharePoint News • Microsoft Security Bulletin MS05-006 • Vulnerability in Windows SharePoint Services and SharePoint Team Services Could Allow Cross-Site Scripting and Spoofing Attacks (887981) • http://www.microsoft.com/technet/security/bulletin/MS05-006.mspx • This update resolves a newly-discovered, privately-reported vulnerability. A cross-site scripting and spoofing vulnerability exists in the affected software that could allow an attacker to convince a user to run a malicious script.

10. Administering SharePoint

11. Administering SharePoint • Many different types of operations • Today we are going to: • Review high level SPS / WSS administrative interfaces • Focus on core day to day operations of SharePoint Administrators • Focus on frequently asked about items • Planning / Managing Resources • Tracking Statistics • Monitoring health • Planning / Managing Backup / Restore

12. Administering SPS and WSS • Both have web based central administration consoles • SPS Backup / restore is desktop tool • Many admin tasks are command line based

13. SharePoint Portal Server Central Admin • Server Configuration • Configure server topology • Configure configuration database server • Specify component settings database server • Specify content database server • Configure e-mail server settings • Configure Server Farm Account Settings • Portal and Virtual Server Configuration • Create a portal site • List and manage portal sites • Extend an existing virtual server • Configure virtual server settings • Configure site quotas and locks • Configure alternate portal site URLs for intranet, extranet, and custom access

14. SharePoint Portal Server Central Admin • Security Configuration • Set SharePoint administrative group account • Manage site collection owners • Manage Web site users • Manage blocked file types • Configure anti-virus settings • Component Configuration • Manage the Search Service • Manage settings for single sign-on • Manage shared services for the server farm • Configure usage analysis processing • Configure HTML viewer • Configure diagnostic settings

15. Windows SharePoint Services Central Admin • Virtual Server Configuration • Top level web sites • Delete site collections • Extend / Upgrade Virtual Server • Configure Virtual Server Settings • Security Configuration • Set administration group • Manage site collection owners • Manage web site users • Manage blocked file types • Configure antivirus settings

16. Windows SharePoint Services Central Admin • Server Configuration • Set content database server • Set config database server • Manage web server list • Config email settings • Config HTML Viewer • Change IIS App Pool • Component Configuration • Config full-text search • Config usage analysis • Manage quotas / locks • Config data retrieval service

17. Planning for and Managing Resources

18. WSS – Creating Top Level Sites • Important to plan sites • Determine site collections • ex HR, IT, Sales etc. • Create multiple top level sites • Different security • Different quotas • Different templates • Workspaces / Department type sites in different collection • Workspaces are temporary

19. WSS – Top Level Site Quotas • By default no quota is selected • Set default quota template at virtual • Set up quota template(s) to manage growth • Max site size in MB • Reminder email (size in MB) • Once max is reached, no new content can be added • Applies to new sites once created • If removed, existing sites still have quotas

20. WSS – Top Level Site Locks • Helps to prevent runaway sites • Prevent sites from being accessed • Prevent users from adding additional content • Prevent access to entire site • Only administrator can unlock the site

21. WSS – Cleaning up Unused Sites • How to address proliferation of WSS sites • SharePoint provides mechanism for managing unused sites • Specific to each virtual • Configurable properties • After n days • Can automatically delete site • Delete is entire collection • Configure schedule of notices • Possibly use stsadm.exe to archive site to file

22. Tracking Statistics

23. Tracking Statistics in SharePoint • Site usage • Site collection usage • Site size • Site alerts • Storage space • Document libraries • Lists • Documents

24. WSS – Usage Analysis Configuration • Not configured by default • Log files are created daily if configured to use usage analysis • When processing is done, it is merged into the content database • Must be administrator on machine to setup for WSS • Viewing can only be done via site or subsite not for entire collection

25. WSS – Usage Analysis Results • Go to site to analyze • View by • Day • Month • View by: • Page • User • OS • Browser • Referrer URL • Good for Business Analysts to track effectiveness of sites

26. Usage Analysis Results in SPS! • Undocumented Tip! • Works in areas • Add “/_layouts/1033/usageDetails.aspx” to URL • Example: • http://intranet.necorp.com/sales/_layouts/1033/usageDetails.aspx

27. WSS – Site Collection Usage Summary • Tracks storage of disk used • Tracks users • Tracks activity • Total hits • bandwidth use (MB/Day)

28. WSS / SPS – Storage Space Allocation • Tracks • Document Libraries • Documents • Lists • Tracks • Size used • # of items • Quota provides different view

29. Monitoring Health

30. WSS Health Monitoring • Windows SharePoint Services Management Pack for MOM • Monitors events placed in the Microsoft Windows Server™ 2003 application event log by Windows SharePoint Services • Monitors performance of Windows SharePoint Services components • Status of database connection. • Monitoring the NT events such as web parts, Virus Scan, and HTML Viewer service • Collecting NT performance counters related to SharePoint Service • Providing custom views for Windows SharePoint Service monitoring info • Sending notification when issues occur

31. SPS Health Monitoring • SharePoint Portal Server 2003 Management Pack for MOM • Monitors events placed in the Microsoft Windows Server™ 2003 application event log • Data backup or restore fails • Core services such as search, alert notifications and administration are not running • Content source crawl fails • Search propagation of one or more content indexes fails • Audience compilation or profile import fails • Sending notification when issues occur

32. Planning and Managing Backup / Restore

33. Planning for SharePoint Backup / Restore • Many different types of backup / restore methods available for WSS / SPS • Different types provide different levels of granularity • It is important for an organization to determine what levels of service are going to be provided • Portal level restore • Site level restore • Document / Item level restore • Time frame of restore (ex. < 8 hours, etc.)

34. WSS – Backup / Restore • A variety of tools available for backing up / restoring WSS • Pro’s and Cons of each method • SQL Server 2000 Backup and Restore • Command line stsadm.exe tool • Command line smigrate.exe tool / Front Page 2003

35. WSS – Backup / Restore – SQL Server 2000 • Utilizes SQL Server 2000 native database backup / restore utilities • Backs up entire database • Easy to setup / schedule • Backup / restore entire configuration database and each content database

36. WSS – Backup / Restore – Stsadm.exe • Command line tool, needs to be programmed or scripted in batch file • Works for both MSDE and SQL Server 2000 • Does site collection level backup / restore • Need to be administrator on local server • The backup for a top level site includes any subsites of the top level site. • Site backup and restore affects performance

37. WSS – Stsadm.exe Usage Scenarios • Can overwrite an existing site, all completely overwritten (i.e. no merge) • If trying to recover data from an existing site, restore to a new site and then copy data over to the existing site • Example: Use stsadm.exe if you want to recover a list or list item • Manual process requiring cut and paste • Link will be provided on www.sharepointmn.com to utility script for backing up many sites

38. WSS – Backup / Restore – Stsadm for Windows • .NET Windows app • GUI interface for generating and submitting STSADM commands • 3rd Party Freeware • Configurable via XML

39. WSS – Backup / Restore – Smigrate.exe • Command line tool designed for migrating sites • Does not necessarily preserve customization settings or security • Can be run by administrators of the site, don’t need to be administrator on local server • Need to create an empty website to restore to • DON’T APPLY TEMPLATE • Features are identical to Front Page 2003 • Graphical User Interface • FrontPage 2003 is based on smigrate.exe

40. SPS – Backup / Restore • Primary utility is SharePoint Portal Server Backup and Restore application • Comes with SPS • Client tool (not web based) • SQL Server 2000 client tools must be installed where utility runs • Several accounts need write access to backup directory • SQL Service Account • Search service • Search database access • Configuring user

41. SPS – Backup / Restore • Only backup and restore entire portal • Simple, but lacks flexibility • Does not backup / restore custom web parts • Restoring a lost file from a document library requires restoring the entire portal • Backup files in “C:\Program Files\Common Files\Microsoft Shared\web server extensions\60” • Depending on needs, may want to look at 3rd party tools

42. Add a Recycle Bin to WSS • Article aimed at developers • Discusses utilization of document library event model • Creates mirror document library • Effectively two copies of the document (may be unsuitable for large implementations) http://msdn.microsoft.com/msdnmag/issues/05/02/RecycleBinforWSS/default.aspx

43. Resources • Administrator Guide for Windows SharePoint Services • http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsf20.mspx • SharePoint Portal Server 2003 Administrators Guide • http://www.microsoft.com/technet/prodtechnol/office/sps2003/downloads/admdwnld.mspx • SharePoint Portal Server 2003 Management Pack for MOM • http://www.microsoft.com/downloads/details.aspx?FamilyId=2F541479-3B85-4831-9247-0145AB2AC655&displaylang=en • Windows SharePoint Services Management Pack for MOM • http://www.microsoft.com/downloads/details.aspx?FamilyId=F61B423C-5BAD-46AE-AB67-33B4BAAA3721&displaylang=en

44. Resources • STSADM for Windows • http://www.microsoft.com/sharepoint/downloads/components/detail.asp?a=443 • Backing up and restoring web sites created with WSS • http://www.microsoft.com/technet/prodtechnol/office/office2003/maintain/bureswss.mspx • SharePoint Products and Technologies Resource Kit • ISBN: 073561881X

45. Q & A