Transcript October 2008 - Administration

Welcome to the
Minnesota SharePoint
User Group
October 8th, 2008
SharePoint 2007 Administration
Brian Caauwe
http://www.sharepointmn.com
Meeting # 48
Agenda
•
•
•
•
•
•
•
Introductions
SharePoint Terminology
Backup and Recovery
Break
Disaster Recovery Scenarios
Moving SharePoint Content
Drawings !!
http://www.sharepointmn.com
User Group Goal / Objectives
Develop and support 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
http://www.sharepointmn.com
Introductions – MNSPUG Sponsors
Inetium (www.inetium.com)
• Technology consulting company
• Microsoft Gold Certified Partner
• Practice area focused on SharePoint
New Horizons – Minnesota (www.newhorizonsmn.com)
• Microsoft Gold Certified Partner
• Training on many technologies
Microsoft (www.microsoft.com)
http://www.sharepointmn.com
www.sharepointmn.com
•
•
•
•
•
•
Website for user group
SharePoint resource documents
SharePoint resource links
RSS Feeds
Meeting Schedule
Past User Group Presentations
www.sharepointmn.com
http://www.sharepointmn.com
Upcoming Schedule
•
Next Meeting
• November 12th 9:00 AM to 11:30 AM
• Topic: Social Networking
• Check www.sharepointmn.com for updates!
• Ongoing Schedule
• 2nd Wednesday of every month
• 9:00 to 11:30 am
• Microsoft’s Bloomington Office
http://www.sharepointmn.com
Conferences
• DevConnections – November 10-13, 2008
http://www.devconnections.com/shows/FALL2008SP/default.asp?s=123
Las Vegas, NV
Other Events
• Minneapolis Office Developer Interest Group (MODIG)
Code Access Security
Tuesday October 28th – 3500 American Blvd W, Bloomington, MN
More information at: http://www.sharepointmn.com/modig/default.aspx
http://www.sharepointmn.com
Blogs
•
Microsoft SharePoint Team Blog
August Cumulative Update for WSS 3.0 & MOSS 2007
http://blogs.msdn.com/sharepoint/archive/2008/09/29/announcing-august-cumulativeupdate-for-office-sharepoint-server-2007-and-windows-sharepoint-services-3-0.aspx
•
Microsoft SharePoint Designer Team Blog
Declarative Workflows and User Context
http://blogs.msdn.com/sharepointdesigner/archive/2008/09/28/declarative-workflows-anduser-context.aspx
•
Joel Oleson
SharePoint Performance Optimization Whitepaper Hits the Nail on the Head
http://www.sharepointjoel.com/Lists/Posts/Post.aspx?ID=92
http://www.sharepointmn.com
SharePoint Terminology
SharePoint Terminology
SharePoint Terminology – Administration
•
SharePoint is a platform that is both wide and deep. Not only do administrators
need to know the concepts of SharePoint, but also the surrounding technologies
that it utilizes.
•
SharePoint Administrators are more than just site administrators, they are ultimately
responsible for the health of the platform, so understanding of core concepts of the
platform is necessary.
•
Community Resources
•
Training, Training, Training
SharePoint Terminology
SharePoint Terminology
•
Lots of Terms!!
–
–
–
•
Architecture Building Blocks
–
–
•
Get everyone on the same page
How do objects relate to each other
Different versions have different terms
Microsoft.SharePoint.Administration
Microsoft.SharePoint
Much Much More
–
–
–
Microsoft.SharePoint.Deployment
Microsoft.SharePoint.Search
Microsoft.SharePoint.Workflow
SharePoint Terminology
SharePoint Terminology
•
Microsoft.SharePoint.Administration
Farm
Servers
Web Applications
Content Databases
•
SPFarm farm = SPFarm.Local;
SPServerCollection servers = farm.Servers;
SPWebService service = farm.Services.GetValue<SPWebService>("");
SPWebApplicationCollection webApps = service.WebApplications;
SPWebApplication webApp = site.WebApplication;
SPContentDatabaseCollection contentDBs = webApp.ContentDatabases;
Microsoft.SharePoint
Site Collections
Sites / Webs
Lists & Libraries
Items
SharePoint Terminology
SPSite site = new SPSite("http://localhost");
SPWeb web = site.OpenWeb();
SPListCollection lists = web.Lists;
SPListItemCollection items = list.Items;
Backup and Recovery
Backup and Recovery
Backup and Recovery
•
Disaster Recovery
–
–
•
Business Continuity
–
–
•
•
Small Disaster / Catastrophic
Planning / Testing
Service Level Agreements (SLA’s)
High Availability
Development / Staging / Production
Methods
–
–
–
–
–
–
Central Administration
STSADM
SharePoint Designer
SQL
3rd Party Utilities
MS IT Site Delete Capture (Site Recycle Bin)
Backup and Recovery
Backup and Recovery – Central Administration
•
What do you get
–
–
•
Where is it
–
•
Farm Administrators
Where should I backup to
–
•
Central Administration > Operations
Who can use it
–
•
Single backup / restore operations (NO SCHEDULE)
Entire Farm, Web Application, Content Database, Shared Services Provider (MOSS Only)
UNC path (i.e. \\server\backup) NOT local path (i.e. E:\backup)
What permissions are needed
–
–
Farm account and SQL account need write access to backup location
Remember both Security AND Share permissions
Backup and Recovery
Backup and Recovery – Central Administration
•
User Interface - Backup
Backup and Recovery
Backup and Recovery – Central Administration
•
User Interface - Recovery
Backup and Recovery
Backup and Recovery – STSADM
•
What do you get
–
–
•
Where is it
–
–
•
Farm Administrators
Where should I backup to
–
•
SharePoint Server
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\bin
Who can use it
–
•
Backup / restore operations (SCRIPTABLE)
Entire Farm, Web Application, Content Database, Shared Services Provider (MOSS Only)
UNC path (i.e. \\server\backup) NOT local path (i.e. E:\backup)
What permissions are needed
–
Farm account and SQL account need write access to backup location
Backup and Recovery
Backup and Recovery – STSADM
•
Backup
–
–
–
•
stsadm -o backup
Site Collection
Catastrophic
Restore
–
–
–
stsadm -o restore
Site Collection
Catastrophic
Backup and Recovery
Backup and Recovery – STSADM
•
Backup Location
–
Site Collection
–
Catastrophic
Backup and Recovery
Backup and Recovery – STSADM
•
Scheduled Tasks
Backup and Recovery
Backup and Recovery – SharePoint Designer
•
User Interface - Backup
Backup and Recovery
Backup and Recovery – SharePoint Designer
•
User Interface - Restore
Backup and Recovery
Backup and Recovery – SQL Backups
•
Which databases
–
–
–
•
Backup Methods
–
•
Truncate Transaction Logs
Don’t rebuild indexes
Compress Backups
–
•
Simple vs. Full
Maintenance Plans
–
–
•
Content Databases
Shared Service Provider Databases
Configuration Database
New option in SQL 2008
What do I NOT get with SQL backups
–
–
–
SharePoint Features
Manual file modifications
IIS modifications / bindings / certificates
Backup and Recovery
Backup and Recovery – 3rd Party Tools
•
AvePoint – DocAve
–
•
CommVault
–
•
http://www.microsoft.com/systemcenter/dataprotectionmanager/en/us/protect-sharepoint.aspx
Neverfail
–
•
http://www.commvault.com/solutions/sharepoint/
Microsoft – Data Protection Manager
–
•
http://www.avepoint.com/products/sharepoint-backup
http://www.neverfailgroup.com/products/app-modules/sharepoint.aspx
Quest – Recovery Manager
–
http://www.quest.com/recovery-manager-for-sharepoint/
Backup and Recovery
Backup and Recovery – MS IT Site Delete Capture
•
•
Site Recycle Bin
How does it work
–
–
–
–
Uses Feature Stapling
Stapled to all out-of-the-box site definitions
When user deletes a site, processes a backup/export before deleted
Stores site in a flat file
•
When installed, NOT activated on existing sites
•
CodePlex
–
http://www.codeplex.com/governance/Release/ProjectReleases.aspx?ReleaseId=14351
Backup and Recovery
Break
5 – 10 minutes
Disaster Recovery Scenarios
Disaster Recovery Scenarios
Disaster Recovery Scenarios – Catastrophic
•
•
•
•
•
•
•
•
•
All Servers (WFE’s, APP and SQL are gone)
Communication is KEY
Determine what backups you have
Get SQL back online and start restoring databases if you have them
Get your box that will run Central Administration installed with the SharePoint bits
Get the remaining SharePoint boxes online and install all SharePoint updates to
match your backups
If you have the configuration database, connect… if not, start recreating your farm
Start all services needed
Restore content
•
•
•
STSADM -o restore (from SharePoint backup)
STSADM -o restoressp (from SQL backups)
STSADM -o addcontentdb (from SQL backups)
Disaster Recovery Scenarios
Disaster Recovery Scenarios – Site Collection
•
•
•
Individual site collection was deleted by site administrator
Determine what backups you have
Restore content database containing site collection into a temporary location (SP)
–
•
Restore content database containing site collection into a temporary location (SQL)
–
•
STSADM -o addcontentdb
Backup site collection from temporary location
–
•
STSADM -o restore
STSADM -o backup
Restore site collection to permanent location
–
STSADM -o restore
Disaster Recovery Scenarios
Disaster Recovery Scenarios – Dev / Stage / Prod
•
•
•
•
Moving content between environments
Backup content databases in SQL
Restore content database to separate environment in SQL
Attach content databases to separate environment in SharePoint
–
STSADM -o addcontentdb
Disaster Recovery Scenarios
Moving SharePoint Content
Moving SharePoint Content
Moving SharePoint Content
•
What
–
–
–
•
When
–
–
–
•
Migrations
Maintenance
Organization modifications
Why
–
–
–
•
Sites & Webs
Lists & Libraries
Items & Files
Re-parent Lists & Libraries
Remove tie to custom site definitions
Managing Content Databases
How
–
–
–
STSADM (Export / Import & MergeContentDBs
SharePoint Designer
Content Deployment Wizard
Moving SharePoint Content
Moving SharePoint Content – STSADM (Export / Import)
•
What do you get
–
–
–
•
What do you NOT get
–
–
–
–
–
•
Webs
Lists & Libraries
Items & Files
Workflow Associations
Workflow History
Alerts
Recycle Bin
Audit Trail
Other issues
–
–
Content Type Workflow Associations become broken
Difference in importing list items rather than documents
Moving SharePoint Content
Moving SharePoint Content – STSADM (Export / Import)
•
Export
•
Import
Moving SharePoint Content
Moving SharePoint Content – STSADM (MergeContentDbs)
•
•
•
New Command included in Service Pack 1
Allows administrators to move site collections between content databases
Also utilizes stsadm -o enumsites
Moving SharePoint Content
Moving SharePoint Content – SharePoint Designer
•
What do you get
–
–
•
Lists & Libraries
Site structure
What do you NOT get
–
–
–
–
–
–
–
–
Alerts
Audit Trail
List or Library Data
Recycle Bin
Security Permissions
Subwebs
Workflow Associations
Workflow History
Moving SharePoint Content
Moving SharePoint Content – SharePoint Designer
•
Export
•
Import
Moving SharePoint Content
Moving SharePoint Content – Content Deployment Wizard
•
A tool for SharePoint 2007 which provides the means to deploy the following
content:
- site collections
- webs
- lists
- folders
- list items (including files)
•
Uses the Content Deployment API
•
Must be installed and run on the SharePoint server
Version 1.1 released September 22nd
http://www.codeplex.com/SPDeploymentWizard
Moving SharePoint Content
Moving SharePoint Content – Content Deployment Wizard
Moving SharePoint Content
Demo
Moving SharePoint Content
References
• Back up, Restore, or move a SharePoint site
http://office.microsoft.com/en-us/sharepointdesigner/HA100699391033.aspx
• CodePlex – MS IT Site Delete (Site Recycle Bin)
http://www.codeplex.com/governance/Release/ProjectReleases.aspx?ReleaseId=14351
• CodePlex – SharePoint Content Deployment Wizard
http://www.codeplex.com/SPDeploymentWizard
• SQL Maintenance Plans for SharePoint databases
http://support.microsoft.com/kb/932744
• My Blog
http://blogs.inetium.com/blogs/bcaauwe
• This slideshow!
http://www.sharepointmn.com
http://www.sharepointmn.com
Q & A / Drawings
http://www.sharepointmn.com
Thanks for coming!
http://www.sharepointmn.com