Transcript Slide 1
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
•
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
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
Upcoming Schedule
•
Next Meeting
•
March 9 th 9:00 AM to 11:00 AM
•
Microsoft’s Bloomington Office
•
Topic: To Be Announced
•
Ongoing Schedule
•
2 nd 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
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
Planning for and Managing Resources
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
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/_la youts/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
Monitoring Health
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 application event log Server™ 2003
•
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 backing up many sites www.sharepointmn.com
to utility script for
WSS – Backup / Restore – Stsadm for Windows
•
.NET Windows app
•
GUI interface for generating and submitting STSADM commands
•
3 rd 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
•
DON’T APPLY TEMPLATE
•
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 3 rd 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) http://msdn.microsoft.com/msdnmag/issues/05/02/RecycleBinforWSS/default.aspx
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
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