Keeping Your Content Safe And Sound In Sharepoint Who is this Todd - PowerPoint PPT Presentation

Keeping Your Content Safe And Sound In Sharepoint

Who is this Todd Klindt guy? • WSS MVP since 2006 • Speaker, writer, consultant, Aquarius, proud Trans Am owner • Personal Blog www.toddklindt.com/blog • Company web site http://sharepoint.rackspace.com • E-mail todd.klindt@rackspace.com • Twitter me! @toddklindt • If you’re not already sick of him • http://www.toddklindt.com/netcast

Agenda • Discuss different situations where data is at risk • Demonstrate how to protect your data from each of these risks

What do we mean by DR? • Content Recovery • Oh crap, where’s my spreadsheet? • Disaster Recovery • Kaboom! • High Availability • Business continuity

Worlds Greatest Slide Farm – SPFarm Servers - SPServer Web Front End, APP Web Applications – SPWebApplication Central Admin, Content Databases – SPContentDatabase Content Database Site Collections – SPSite The Bag Webs – SPWeb Portal, Wikis, Blogs, Team, Doc, Workspaces, Search Center Lists Doc Libs, Pages, Events, Discussions, Surveys, Etc Items Files, Calendar items, Contacts, Customers, Images, Custom

Content Recovery • Bringing back content • Usually for users that need it IMMEDIATELY! • Four approaches • Versions • Recycle Bin • PowerShell / STSADM • Unattached Database Recovery

Content Recovery 1st Defense: Versions • Not necessarily a disaster recovery method • Easy to use • All end user activity, does not require IT or Development time at all • Can restrict number of versions kept • Take up space in site collection quota

Content Recovery 2nd Defense Recycle Bin • Must be enabled and configured at the Web Application level • Two stages • Captures site collections, webs, list items, documents, folders lists and document libraries

Content Recovery 3rd Defense Site Backups • Export-SPWeb – Content only – Scoped down to the list or library • Backup-SPSite – Full fidelity – Scoped at Site Collection • Can be scripted and scheduled with PowerShell • Portable

Fancy PowerShell script • Get-SPSite | ForEach-Object{$FilePath = "c:\backups\" + $_.Url.Replace("http://","") .Replace("https://","") .Replace(“ -","-- ").Replace(“:"," -").Replace("/","-") + ".bak" ; Backup-SPSite -Identity $_.Url -Path $FilePath} • http://www.toddklindt.com/Scripts

Central Administration Site Backups • Granular Backup – Site Collection – Web – List • Analogous to Export-SPWeb and Backup- SPSite • Unattached Database Restore • Pure Magic

Server Failure - Farm • What will you do if your server fails? • Need to decide what to back up – User Content (Content Databases) – Configuration database – Service Application databases • What happens if SQL fails?

Server Failure – Local Server • Files – SSL certs – Web.config – IIS Config (metabase) – Features (Should be Solutions) – Master Pages – Custom site definitions – Webtemp.xml – Docicon.xml and file icons

Server Failure – Farm Backup • Can do a Farm level backup from Central Administration • Gets all databases and configuration • Configuration only • Does database dumps • Script with Backup-SPFarm

Items not captured by Farm Backup • Application pool account passwords • HTTP compression settings • Time-out settings • Custom Internet Server Application Programming Interface (ISAPI) filters • Computer domain membership • Internet Protocol security (IPsec) settings • Network Load Balancing settings • Secure Sockets Layer (SSL) certificates • Dedicated IP address settings

Business Continuity • Mirroring support built in • Need to configure SQL manually – Transaction Log Shipping – Mirroring – Snapshots • Failover can be automatic or manual

Other Resources • Plan for Disaster recovery – http://technet.microsoft.com/en- us/library/ff628971.aspx • Plan for Backup and Recovery – http://technet.microsoft.com/en- us/library/cc261687.aspx