440 likes | 567 Views
Welcome to the Minnesota SharePoint User Group. October 8 th , 2008 SharePoint 2007 Administration Brian Caauwe. Meeting # 48. http://www.sharepointmn.com. Agenda. Introductions SharePoint Terminology Backup and Recovery Break Disaster Recovery Scenarios Moving SharePoint Content
E N D
Welcome to the Minnesota SharePoint User Group October 8th, 2008 SharePoint 2007 Administration Brian Caauwe Meeting # 48 http://www.sharepointmn.com
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
Other Events Minneapolis Office Developer Interest Group (MODIG)Code Access SecurityTuesday October 28th – 3500 American Blvd W, Bloomington, MNMore information at: http://www.sharepointmn.com/modig/default.aspx Conferences • DevConnections – November 10-13, 2008http://www.devconnections.com/shows/FALL2008SP/default.asp?s=123Las Vegas, NV http://www.sharepointmn.com
Blogs Microsoft SharePoint Team BlogAugust Cumulative Update for WSS 3.0 & MOSS 2007http://blogs.msdn.com/sharepoint/archive/2008/09/29/announcing-august-cumulative-update-for-office-sharepoint-server-2007-and-windows-sharepoint-services-3-0.aspx Microsoft SharePoint Designer Team BlogDeclarative Workflows and User Contexthttp://blogs.msdn.com/sharepointdesigner/archive/2008/09/28/declarative-workflows-and-user-context.aspx Joel OlesonSharePoint Performance Optimization Whitepaper Hits the Nail on the Headhttp://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!! Get everyone on the same page How do objects relate to each other Different versions have different terms Architecture Building Blocks 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 SPFarm farm = SPFarm.Local; Servers SPServerCollection servers = farm.Servers; SPWebService service = farm.Services.GetValue<SPWebService>(""); SPWebApplicationCollectionwebApps = service.WebApplications; Web Applications SPWebApplicationwebApp = site.WebApplication; Content Databases SPContentDatabaseCollectioncontentDBs = webApp.ContentDatabases; • Microsoft.SharePoint Site Collections SPSitesite = newSPSite("http://localhost"); Sites / Webs SPWebweb = site.OpenWeb(); Lists & Libraries SPListCollectionlists = web.Lists; Items SPListItemCollectionitems = list.Items; SharePoint Terminology
Backup and Recovery Backup and Recovery
Backup and Recovery Disaster Recovery Small Disaster / Catastrophic Planning / Testing Business Continuity 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 Single backup / restore operations (NO SCHEDULE) Entire Farm, Web Application, Content Database, Shared Services Provider (MOSS Only) Where is it Central Administration > Operations Who can use it Farm Administrators Where should I backup to 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 Backup / restore operations (SCRIPTABLE) Entire Farm, Web Application, Content Database, Shared Services Provider (MOSS Only) Where is it SharePoint Server C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\bin Who can use it Farm Administrators Where should I backup to 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 Content Databases Shared Service Provider Databases Configuration Database Backup Methods Simple vs. Full Maintenance Plans Truncate Transaction Logs Don’t rebuild indexes Compress Backups 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 http://www.avepoint.com/products/sharepoint-backup • CommVault • http://www.commvault.com/solutions/sharepoint/ • Microsoft – Data Protection Manager • http://www.microsoft.com/systemcenter/dataprotectionmanager/en/us/protect-sharepoint.aspx • Neverfail • 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) STSADM -o restore Restore content database containing site collection into a temporary location (SQL) STSADM -o addcontentdb Backup site collection from temporary location 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 • Sites & Webs • Lists & Libraries • Items & Files • When • Migrations • Maintenance • Organization modifications • Why • 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 Webs Lists & Libraries Items & Files What do you NOT get 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