Welcome to the minnesota sharepoint user group
1 / 45

Welcome to the Minnesota SharePoint User Group - PowerPoint PPT Presentation

  • Updated On :

Welcome to the Minnesota SharePoint User Group. Agenda. Introductions / Overview SharePoint News SharePoint Administration CommVault Demonstration Q & A. Introductions – MNSPUG Sponsors. Inetium ( www.inetium.com ) Twin Cites based Microsoft consulting company

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about 'Welcome to the Minnesota SharePoint User Group' - kirima

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Welcome to the minnesota sharepoint user group

Welcome to the Minnesota SharePoint User Group


  • Introductions / Overview

  • SharePoint News

  • SharePoint Administration

  • CommVault Demonstration

  • Q & A

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

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


  • Website for user group

  • SharePoint resource documents

  • SharePoint resource websites links

  • RSS Feeds

  • Meeting Schedule

  • Past User Group Presentations


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

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

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

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.



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

Administering SPS and WSS

  • Both have web based central administration consoles

  • SPS Backup / restore is desktop tool

  • Many admin tasks are command line based

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

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

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

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

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

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

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

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

Tracking Statistics in SharePoint

  • Site usage

  • Site collection usage

  • Site size

  • Site alerts

  • Storage space

    • Document libraries

    • Lists

    • Documents

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

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

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

WSS – Site Collection Usage Summary

  • Tracks storage of disk used

  • Tracks users

  • Tracks activity

    • Total hits

    • bandwidth use (MB/Day)

WSS / SPS – Storage Space Allocation

  • Tracks

    • Document Libraries

    • Documents

    • Lists

  • Tracks

    • Size used

    • # of items

  • Quota provides different view

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

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

Planning and Managing

Backup / Restore

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.)

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

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

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

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

WSS – Backup / Restore – Stsadm for Windows

  • .NET Windows app

  • GUI interface for generating and submitting STSADM commands

  • 3rd Party Freeware

  • Configurable via XML

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


  • Features are identical to Front Page 2003

    • Graphical User Interface

    • FrontPage 2003 is based on smigrate.exe

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

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

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)



  • 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


  • 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