Blueprint For Microsoft SharePoint - Veritas

Transcription

Symantec Backup Exec BlueprintsBlueprint for Microsoft SharePointBackup Exec Technical ServicesBackup & Recovery Technical Education ServicesSymantec Backup Exec Blueprints1

Symantec Backup Exec BlueprintsPreface/disclaimerNoticeThis Backup Exec Blueprint presentation includes example diagrams that contain objectsthat represent applications and platforms from other companies such as Microsoft andVMware. These diagrams may or may not match or resemble actual implementationsfound in end user environments. Any likeness or similarity to actual end userenvironments is completely by coincidence.The goal of the diagrams included in this blueprint presentation is not to recommendspecific ways in which to implement applications and platforms from other companiessuch as Microsoft and VMware, but rather to illustrate Backup Exec best practices only.For guidelines and best practices on installing and configuring applications andplatforms from other companies, please refer to best practice documentation and otherresources provided by those companies.Symantec Backup Exec Blueprints2

Backup Exec Blueprints: How to UseGetting the most out of Backup Exec blueprints These Blueprints are designed to show customer challenges and how BackupExec solves these challenges. Each Blueprint consists of:‒ Pain Points: What challenges customers face‒ Whiteboard: Shows how Backup Exec solves the customer challenges‒ Recommended Configuration: Shows recommended installation‒ Dos: Gives detailed configurations suggested by Symantec‒ Don'ts: What configurations & pitfalls customers should avoid‒ Advantages: Summarizes the Backup Exec advantages Use these Blueprints to:‒ Understand the customer challenges and how Backup Exec solves them‒ Present the Backup Exec best practice solutionSymantec Backup Exec Blueprints3

Pain PointsSymantec Backup Exec Blueprints4

Backup Exec Blueprints: Microsoft SharePointSharePoint Data Protection challenges SharePoint is Getting More Complex to Manage/Protect––––– Multiple servers with different rolesDifferent databasesCustomizationsConfigurationsLogical architecture doesn’t translate into physical componentsSharePoint Data Growth–– Ever-increasing volume of documents in SharePoint repositoriesSharePoint backups taking longerNative SharePoint Tools Insufficient–SharePoint's native backup tools are inadequate for handling thecomplexity of SharePoint data growthSymantec Backup Exec Blueprints5

Backup Exec AdvantagesSymantec Backup Exec Blueprints6

Backup Exec Blueprints: AdvantagesSolution designed for Microsoft SharePoint Server One Solution Protects Your Entire Infrastructure– Comprehensive backup support for physical or virtualized SharePoint Servers– Centralized management of large or distributed environments Recovery Flexibility– Granular recovery of SharePoint components, such as individual documents ordocument versions from a single backup– Redirected restore of SharePoint databases to any SQL instance available on thenetwork– Redirected restore of web applications to a remote SharePoint farm– Redirected restore of individual items to a folder location– Redirected restore of granular SharePoint objects to a different site or farmNote: Redirected restore to file system not supported in 2013. This is due to unknown format of Shredded file.7

Backup Exec Blueprints: AdvantagesSolution designed for Microsoft SharePoint Server Robust Deduplication Technology– Integrated data reduction technologies using the Deduplication Option– Significantly reduces secondary (backup) storage requirements On-line SharePoint Protection– Scheduled, on-line backups of SharePoint servers maintain user accessduring the backup High-performance Backups– Backup and restore of SQL data over LAN or SAN transport modesSymantec Backup Exec Blueprints8

Backup Exec Blueprints: AdvantagesOptimized for SharePointComplete protection in a single solutionWFEWFEAPPSSQLWindowsAPPSSharePoint FarmSQLand/orVirtual HostPhysical ServerFreedom of Storage ChoiceBackup ExecDiskTapeApplianceBackup Exec provides unmatched physical and/or virtual protection for SharePoint farms on your choice of storageSymantec Backup Exec Blueprints9

Whiteboards and DiagramsSymantec Backup Exec Blueprints10

White Boards: Microsoft SharePointSupported SharePoint versionsBackup Exec3600 ApplianceSharePoint Server 2013SharePoint Server 2010SharePoint Foundation 2010Backup ExecStandard SoftwareSharePoint Server 2007Backup ExecWindows SharePoint Services 3.0For the latest detailed list of platforms and applications supported by Backup Exec, refer to the Backup Exec Software CompatibilityList: e content&id TECH205797.Symantec Backup Exec Blueprints11

White Boards: Microsoft SharePointSharePoint DeploymentsStandalone EnvironmentFarm EnvironmentWeb Front EndWeb Front EndApplication ServicesSQL DatabaseIndexQueryJobExcelSearchCentralAdminSQL 1Symantec Backup Exec BlueprintsMy SitesSQL 212

White Boards: Microsoft SharePointNative SharePoint Backup & RestoreFarmConfig DBFile ServerCentral AdminUI or ConsoleContent DBContent DBFull BackupSSP DBSearch IndexDifferential BackupSQL Backup/RestoreWhat’s missing?12345Does not Provide Scheduling Functionality in SharePointDoes not Backup any Configurations/Customizations to any files in the “12 Hive” or Web.config filesDoes not Backup IIS Settings/ConfigurationsDoes not Backup Alternate Access Mappings (AAM)Cannot Backup Directly to Tape (only to UNC)Symantec Backup Exec Blueprints13

Example Diagram: Microsoft SharePointRequirementsProduction Network (10 Gigabit)SQL ServerSharePoint Server21Agent forWindowsBackup Exec4Agent forWindows35Backup Network (10 Gigabit)12345Licensed Agent for Windows installation required on all SharePoint servers in the SharePoint farmLicensed Agent for Windows installation required on all SQL servers hosting SharePoint database in the SharePoint farmThe Backup Exec Logon Account requires the following permissions/rights: Must have local administrator rights on all servers in the farm An advantage if it is part of the SharePoint Farm Administrators Group Must be a Site Collection Administrator at the top-level site for GRT support Must have db owner/sql admin role on all SQL Content databases/SQL instancesLogon credentials for the Single Sign-on database must be either the account name or a member of the account’s groupauthorized to manage settingsThe logon account must be able to access the IIS sites (Enable Integrated Windows Security within the IIS rights)Symantec Backup Exec Blueprints14

Example Diagram: Microsoft SharePointBehind the scenes: Content DatabaseIt’s nearly all about the Content Database!DatabasesSitesWebsLists & LibrariesDocuments,List items, &PagesSymantec Backup Exec Blueprints15

Example Diagram: Microsoft SharePointBehind the scenes: Protecting Content DatabaseSQL ServerBackup ExecDiskSharePoint File SystemGranular (Tape)GRTGRT Staging AreaSharePoint File SystemMDF Reader (GRT)Content DatabaseGRT ProviderDisk basedsolutionGranular (Tape)Data TransferMDF Reader (GRT)GRT ProviderTape basedsolutionContent Database Likely the greatest concern for SharePoint Administrators for day-to-day opsHouses Webapps and Site CollectionsThe Content DB holds all of our GRT-related restore dataAlways a SQL backend; if no SQL chosen, a SQL Express version is installedSymantec Backup Exec BlueprintsDiskCatalogs16

Example Diagram: Microsoft SharePointSharePoint Standalone configurationProduction Network (10 Gigabit)SharePoint Server1Agent forWindowsBackup Exec2435Backup Network (10 Gigabit)Microsoft SharePoint Protection High-level Best Practices12345Install the Backup Exec Agent for Windows on the SharePoint ServerInstall one Agent for Applications and Databases for SharePoint per SharePoint ServerEnsure the Backup Exec logon account has local administrative privileges for the SharePoint server forSharePoint backup and restore jobsUse the Backup Exec SQL Agent, in addition to the SharePoint farm resources, to back up the default MicrosoftSQL Server databases for instances on which SharePoint data residesEnsure that Granular Recovery Technology (GRT) is enabled before you run backups if you intend to be able torestore individual itemsSymantec Backup Exec Blueprints17

Example Diagram: Microsoft SharePointSharePoint SQL database hosted on a separate machineProduction Network (10 Gigabit)SQL ServerSharePoint Server12Agent forWindowsAgent forWindowsBackup Exec3546Backup Network (10 Gigabit)Microsoft SharePoint Protection High-level Best Practices1Install the Backup Exec Agent for Windows on the SharePoint ServerInstall the Backup Exec Agent for Windows on the on all the separate server hosting the SharePoint SQL database2Install one Agent for Applications and Databases for SharePoint per SharePoint Server3Ensure the Backup Exec logon account has local administrative privileges for the SharePoint server for SharePoint backup4and restore jobsUse the Backup Exec SQL Agent, in addition to the SharePoint farm resources, to back up the default Microsoft SQL5Server databases for instances on which SharePoint data residesEnsure that Granular Recovery Technology (GRT) is enabled before you run backups if you intend to be able to restore6individual items.Symantec Backup Exec Blueprints18

Example Diagram: Microsoft SharePointClustered SQL databaseProduction Network (10 Gigabit)Active SQL DBSharePoint A12Agent forWindowsAgent forWindowsPassive SQL DBBackup Exec35Active SQL DB46Passive SQL DBBackup Network (10 Gigabit)Microsoft SharePoint Protection High-level Best Practices1Install the Backup Exec Agent for Windows on the SharePoint ServerInstall the Backup Exec Agent for Windows on the on all the separate server hosting the SharePoint SQL database2Install one Agent for Applications and Databases for SharePoint per SharePoint Server3Ensure the Backup Exec logon account has local administrative privileges for the SharePoint server for SharePoint backup4and restore jobsUse the Backup Exec SQL Agent, in addition to the SharePoint farm resources, to back up the default Microsoft SQL5Server databases for instances on which SharePoint data residesEnsure that Granular Recovery Technology (GRT) is enabled before you run backups if you intend to be able to restore6individual items.Symantec Backup Exec Blueprints19

White Boards: Microsoft SharePointFailover SQL Mirroring (2 Farms)Backup ExecMain OFFICEAgent forWindowsSharePoint Web/AppServerAgent forWindowsSQL PrincipalAgent forWindowsSharePoint Web/AppServerREMOTE OFFICEAgent forWindowsSharePoint Web/AppServerAgent forWindowsSQL MirrorWhen in a 2-node active/passive cluster server configuration, you need only license the active node.Symantec Backup Exec Blueprints20

White Boards: Microsoft SharePointFailover SQL Mirroring (within Farm)Backup ExecMain OFFICEREMOTE OFFICEAgent forWindowsAgent forWindowsSharePoint Web/AppAgent forServerWindowsLoadBalancerSharePoint Web/AppServerSQL WitnessAgent forWindowsSQL PrincipalAgent forWindowsSQL MirrorWhen in a 2-node active/passive cluster server configuration, you need only license the active node.Symantec Backup Exec Blueprints21

Example Diagram: Microsoft SharePointVirtualized SharePoint serverNetwork4Virtual Host5VirtualMachines3Backup Exec12Microsoft SQL Virtual Machine Protection High-level Best Practices12345Install Agent for Windows to the SharePoint virtual machineInstall one Agent for Applications and Databases for SharePoint per SharePoint ServerRecover what you need: full SharePoint Server, granular recovery of individual SharePoint objects anddocumentsFor VMware infrastructures, leverage server-side deduplicationFor Hyper-V infrastructures, leverage client-side deduplication (via Agent for Windows on Hyper-V host)Symantec Backup Exec Blueprints22

Example Diagram: Microsoft SharePointAdding a Server Farm to the backup selection list Add the SharePoint servers that you want to protect to the Server list before you createa backup definitionBackup Exec discovers SharePoint farms automaticallyIn case the farm is not displayed, you can manually add the farm to the Server listYou must back up the default Microsoft SQL databases for each Microsoft SQL instancethat hosts SharePoint databasesYou can also remove server farms from the Server listSymantec Backup Exec Blueprints23

Example Diagram: Microsoft SharePointBackup selections for SharePoint 2003 resourcesSymantec Backup Exec Blueprints24

Example Diagram: Microsoft SharePointBackup selections for MOSS 2007Symantec Backup Exec Blueprints25

Example Diagram: Microsoft SharePointBackup selections for SharePoint 2010 resourcesSymantec Backup Exec Blueprints26

Example Diagram: Microsoft SharePointBackup selections for SharePoint 2013 resourcesSymantec Backup Exec Blueprints27

Example Diagram: Microsoft SharePointBackup job options for SharePointNote: Full Copy is new backup method in Backup Exec 2014 The Agent for Microsoft SharePoint includes the new log backup method that backs up the data that is contained inthe transaction log Releases lock if another application has locked SharePoint resources before backup Performs DBCC on SQL databasesSymantec Backup Exec Blueprints28

Example Diagram: Microsoft SharePointRestore selections for SharePoint 2003Symantec Backup Exec Blueprints29

Example Diagram: Microsoft SharePointRestore selections for SharePoint 2007Symantec Backup Exec Blueprints30

Example Diagram: Microsoft SharePointRestore selections for SharePoint 2010Symantec Backup Exec Blueprints31

Example Diagram: Microsoft SharePointRestore selections for SharePoint 2013Symantec Backup Exec Blueprints32

Do Symantec Backup Exec Blueprints33

Best Practices: Microsoft SharePointDo the following Use an account with local administrative privileges for each member of theSharePoint farm for SharePoint backup and restore jobs Make SharePoint backup selections from the appropriate SharePoint farmresource container in the list of servers on the Backup and Restore tabinstead of selecting individual SharePoint servers– The SharePoint farm resource container represents the entire farm topology inyour environment, including all of the SharePoint resources that reside on a singlecomputer– When you select the SharePoint resources from the farm resource container, youensure that you select all available SharePoint resources for backup Use the Backup Exec SQL Agent, in addition to the SharePoint farmresources, to back up the default Microsoft SQL Server databases forinstances on which SharePoint data resides Back up the master, model, and msdb databases to fully protect each SQLinstance for disaster recovery purposesSymantec Backup Exec Blueprints34

Best Practices: Microsoft SharePointDo the following Keep Track of Applied Updates– Record all service packs/hot fixes installed on SharePoint server when you perform backups– Restore jobs may not complete successfully if databases were backed up with different patchlevels Full Backups Recommended– Perform full system backups of the SharePoint servers (system state, system volume, etc.)– When you make full system backups, you fully protect the entire SharePoint environment Turn On GRT– Ensure that Granular Recovery Technology (GRT) is enabled before you run backups– GRT is enabled by default for the SharePoint Agent– You can enable or disable GRT for SharePoint globally in the Backup Job Defaults dialog box Restore Databases Together– Symantec recommends that you restore all databases togetherSymantec Backup Exec Blueprints35

Do not Symantec Backup Exec Blueprints36

Best Practices: Microsoft SharePointDo not do the following Avoid Resource Conflicts– Avoid disk-intensive SharePoint operations during backups Restore Best Practices For Configuration DB and Content DB– Never restore the Configuration DB or the Admin Content DB to anoperational SharePoint environment– If a restore of either database is required when SharePoint is operational,the restore should not be combined with any other resourceSymantec Backup Exec Blueprints37

Additional Notes and Best PracticesSymantec Backup Exec Blueprints38

Best Practices: Microsoft SharePointGRANULAR RECOVERY TECHNOLOGY (GRT) BE 2010 R3 and Prior– Only full backups are supported with GRT– Incremental and Differential backups are possible in Backup Exec 2010 R3 andprior but GRT capability is not present– Incremental backups require the database to be in 'Full' recovery model. Theseare performed as traditional SQL Log-Truncate backups BE 2012 and above– Full/Differential/Incremental backups are supported with GRT– Differential and Incremental backups require that the backup job have AOFO/VSSenabled– Differential and Incremental backups require that the SharePoint SQL databasesbe set to 'Simple' Recovery model– The new method Incremental backups will back up the changed blocks for the DBplus the log file, filestream, and full text catalog files. Because of this, anincremental run immediately after a full may look like it backs up a lotSymantec Backup Exec Blueprints39

Best Practices: Microsoft SharePointGRANULAR RECOVERY TECHNOLOGY (GRT) Cross Farm/Site GRT is also supported as long as the SharePoint versionsmatch– Items ( Docs, Any kind of list items )– Containers – All kinds of Lists, Sub site, Site Collections– Security – Not Supported No GRT support for SharePoint 2013 AppsSymantec Backup Exec Blueprints40

Best Practices: Microsoft SharePointSharePoint best practices Small Environments– In small environments, consider running a daily full backup every evening in addition tohourly incremental/differential backups Mid-sized Environments– In mid-sized environments, consider running a weekly full backup and dailyincremental/differential backups Large Environments– In large environments, consider running daily incremental/differential backups, withfull backups occurring twice a month General––––Use the checksum feature to check database integrityPerform test restores periodicallyCombine different backup types to optimize the backup strategyLeverage compression and encryption features when creating a backup job to ensuredata securitySymantec Backup Exec Blueprints41

Best Practices: Microsoft SharePointSharePoint best practices General (Cont.)– Schedule backup jobs when activity on SharePoint servers is low– Consider a disk-to-disk-to-tape (D2D2T) backup strategy (backup/recovery performance)– Use a separate network for SharePoint backups– For physical SharePoint servers, consider using client-side Deduplication– Use daily differential or incremental backups in addition to periodic full backups– Upgrade your Backup Exec infrastructure to the latest available version– Use a disk maintenance utility to keep SharePoint disk defragmentation low– If multiple networks are available, use the Central Admin Server Option to alternate whatnetwork interfaces are used for backups– Perform Full and Differential backups to support DR at the SharePoint Portal server site level– Change the recovery mode for the SQL databases to Simple This only needs to be changed if you’re going to be running incremental backups– Restore all Shared Service Provider components togetherSymantec Backup Exec Blueprints42

Best Practices: Microsoft SharePointSharePoint best practices SharePoint 2013 has a new feature of Apps– Apps are downloadable from marketplace– Apps can be developed internally– Stored in an App Catalog and then installed in Site– Three modes of hosting an app SharePoint Hosted App Externally Hosted App Azure Hosted App Backup Exec 2014 does not support GRT for Apps at this point Support in planned for a future versionSymantec Backup Exec Blueprints43

Microsoft SharePoint: Final ThoughtsComplete SharePoint protection in a single solutionNetworkVirtual HostBackup ExecPhysical SPS ServerBackup Network (10 Gigabit)Backup Exec SharePoint Advantages User-friendly interfaceCentralized management of large or distributed environmentsIntegrated data reduction technologies using the Deduplication OptionScheduled, on-line backups of SharePoint serversComprehensive backup support for physical or virtualized SharePoint ServersGranular recovery of SharePoint components, such as individual documents or document versionsRedirected restore of SharePoint databases to any SQL instance available on the networkRedirected restore of web applications to a remote SharePoint farmRedirected restore of individual items to a folder locationRedirected restore of granular SharePoint objects to a different site or farmBackup and restore of SQL data over LAN or SAN transport modesSymantec Backup Exec Blueprints44

Thank You!Backup Exec Product ManagementSymantec Backup Exec Blueprints45

such as Microsoft and VMware, but rather to illustrate Backup Exec best practices only. For guidelines and best practices on installing and configuring applications and platforms from other companies, please refer to best practice documentation and other . SharePoint Server 2013 SharePoint Server 2010 SharePoint Foundation 2010 SharePoint .