Transcription
Dell EMC NetWorker Module for Microsoftfor SQL and SharePoint VSSVersion 19.1User Guide302-005-512REV 01
Copyright 2007-2019 Dell Inc. or its subsidiaries. All rights reserved.Published May 2019Dell believes the information in this publication is accurate as of its publication date. The information is subject to change without notice.THE INFORMATION IN THIS PUBLICATION IS PROVIDED “AS-IS.“ DELL MAKES NO REPRESENTATIONS OR WARRANTIES OF ANY KINDWITH RESPECT TO THE INFORMATION IN THIS PUBLICATION, AND SPECIFICALLY DISCLAIMS IMPLIED WARRANTIES OFMERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. USE, COPYING, AND DISTRIBUTION OF ANY DELL SOFTWARE DESCRIBEDIN THIS PUBLICATION REQUIRES AN APPLICABLE SOFTWARE LICENSE.Dell, EMC, and other trademarks are trademarks of Dell Inc. or its subsidiaries. Other trademarks may be the property of their respective owners.Published in the USA.Dell EMCHopkinton, Massachusetts 01748-91031-508-435-1000 In North America 1-866-464-7381www.DellEMC.com2NetWorker Module for Microsoft for SQL and SharePoint VSS 19.1 User Guide
CONTENTSFigures7Tables9Preface11Chapter 1Introduction15SharePoint Server overview.16Microsoft SharePoint environments.16Supported SharePoint Server VSS Writers. 18Supported special characters. 18SharePoint Server backups. 18SharePoint Server recovery. 18SQL Server overview. 19SQL Server backup and recovery. 19NMM 19.1 compatibility with NetWorker 8.2.3 or 8.2.4 servers . 20Using NetWorker server 8.2.3 or later and NMM 19.1.20Chapter 2Microsoft SharePoint Server Scheduled Backups in a FederatedWorkflow21Overview . 22Prerequisites for SharePoint Server backups. 22Creating SharePoint Server client resources. 26Creating a client resource by using the Client Backup Configurationwizard .26Manually creating client resources by using the Client Propertiesdialog box. 28Special backup scenarios.29Chapter 3Microsoft SharePoint Server Recovery31SharePoint Server restore recommendations. 32Restoring a SharePoint full farm.32Restoring content databases. 33Restoring single web application and content databases. 33Restoring SQL Server AlwaysOn Availability Group databases. 35Restoring SharePoint Server and SQL Server VSS backups that areperformed by using NMM 8.2.3 and 8.2.4. 36Chapter 4Microsoft SharePoint Server Granular Level Recovery37Overview. 38Performing GLR of SharePoint farms. 38Prerequisites. 38Mounting backups by using the NetWorker User for Microsoft GUI.41NetWorker Module for Microsoft for SQL and SharePoint VSS 19.1 User Guide3
CONTENTSViewing mount details.42Performing GLR by using the EMC ItemPoint for MicrosoftSharePoint Server GUI. 43Extending timeout of a mounted backup.44Dismounting backups.45Performing a GLR of a Remote BLOB Storage. 45Chapter 5Microsoft SQL Server Scheduled Backups47Prerequisites. 48Supported backup settings for SQL Server 2012 and later Availability Group. 48Configuring scheduled backups. 48Configuring client resources. 49Performing federated backups on SQL setups that have AlwaysOnAvailability Group configured.50Chapter 6Microsoft SQL Server Recovery53Restoring SQL Server data in a stand-alone environment. 54Restoring SQL Server Always-On Availability Group databases.54Chapter 7Microsoft SQL Server Directed Recovery57Overview of SQL Server directed recovery. 58Performing SQL Server directed recovery. 58Examples of log messages in the NMM log file and the Monitor page. 60Chapter 8Windows Bare Metal Recovery Solution63SQL Server in a stand-alone environment. 64Backing up a SQL Server for BMR.64Performing BMR of a standalone SQL Server.65SQL Server in a cluster environment. 66Backing up a SQL Server for BMR.66Performing BMR of a SQL Server cluster. 68SharePoint Server BMR. 70Sample SharePoint farm configuration. 70Backing up SharePoint Server. 71Performing BMR of SharePoint Server. 73Appendix AExample Procedure for SharePoint Server Backup and Recovery75Example save sets for SharePoint farm backups. 76Recovery examples for SharePoint Server 2013. 77Configuring SQL Server 2014 AlwaysOn Availability Groups. 78Restoring deleted individual items from document library.79Restoring deleted search service application. 79Restoring deleted web application.80Deleting a web application. 80Restoring a deleted web application. 81Appendix BExample Procedure for SharePoint Web Application DirectedRecovery83Introduction.844NetWorker Module for Microsoft for SQL and SharePoint VSS 19.1 User Guide
CONTENTSPerforming a directed recovery of a web application.84Appendix CSharePoint BLOB Backup and Recovery by using NMM andMetalogix StoragePoint89Overview of using NMM for SharePoint RBS externalized by MetalogixStoragePoint software. 90RBS deployed SharePoint disaster restore solution by using NetWorker andNMM.90Configuring client resources. 90Performing backups.92Restoring RBS Metalogix BLOB store. 92Performing SharePoint GLR with Metalogix RBS deployed and configuredfor externalizing BLOB store by using the EMC ItemPoint for MicrosoftSharePoint Server GUI. 92Restoring SharePoint content databases. 96Restoring a SharePoint farm with RBS Metalogix deployed and externalizedBLOB store.97Troubleshooting tips. 97Appendix DSharePoint Content Database Log Truncation99Issue with truncating SharePoint content database logs.100Solution to truncate SharePoint content database logs. 100Limitation. 100Restoring SharePoint content databases from SQL VDI backups. 101Limitation. 102Sample configuration and test steps to truncate SharePoint contentdatabase logs. 102Appendix ETroubleshooting103Generic troubleshooting issues. 104SharePoint Server issues. 105Client Backup Configuration wizard issues. 106If crawling content produces more traffic on the web front-endservers than user requests. 106Perform manual steps to associate a web application to the originalSSP after recovery.107Missing SQL tab during SharePoint GLR. 107Locating the content database for directed recovery duringSharePoint Server GLR. 108Agent for Content Transfer Service error during SharePoint GLR.109The nsrnmmsv -P command does not list the save set. 110Sometimes save sets are not listed correctly when a SharePointclient resource is created by using the Client Backup Configurationwizard. 110Slow SharePoint Server GLR performance when using a DD device.110SharePoint backups fail, and display an error that is similar to"Unable to connect to the SQL Server" or "Failed to login to SQLServer". 110SQL Server issues.112Recovery of SQL Server database fails when the database isrenamed after backup. 112NetWorker Module for Microsoft for SQL and SharePoint VSS 19.1 User Guide5
CONTENTSSQL Server services stop during recovery of SQL Server masterdatabase. 112Back up the SQL Server resource database during file systembackup by using the NetWorker client. 112Freeing up disk space by shrinking the SQL log files. 1126NetWorker Module for Microsoft for SQL and SharePoint VSS 19.1 User Guide
272829303132SharePoint Server distributed farm configuration. 16Expected output after using the Add-SPShellAdmin and Get-SPShellAdmin commands. 23View SYSTEM account in the Object Explorer.23Granting permissions to view subcomponents in SSMS.24Select SharePoint Configuration Data and SharePoint Farm. 32Mount Service system tray icon. 42Add Database to Availability Group dialog box. 55Secondary replica copy in restoring mode. 56Content database added back to the AlwaysOn Availability Group. 56SQL Server Properties dialog box.69Add database. 78Delete search service application. 80Delete web application. 81The backed up content database.85Three backups for SharePoint - 3 web application. 85Three backups for SharePoint - 4 web application. 86Web application is not accessible. 86IIS site for SharePoint - 4 is not available. 87Content database is available.87New web application created.87SharePoint documents. 88Select viewable clients. 93Source path selection. 93Target server selection.94Remote BLOB store configuration. 94Viewing the target. 95Copying items from the source.95Pasting items to the target.96Error during a granular restore .97Copy operation time out. 98Missing SQL tab. 107Available SQL tab. 108NetWorker Module for Microsoft for SQL and SharePoint VSS 19.1 User Guide7
FIGURES8NetWorker Module for Microsoft for SQL and SharePoint VSS 19.1 User Guide
TABLES123456789101112Revision history.12Style conventions.12Services and servers in a SharePoint Server farm . 17Supported SharePoint Server VSS Writers. 18User roles, groups, and permissions.23Supported high availability and disaster recovery options for SharePoint Server. 30ItemPoint for SharePoint Server requirements.39Backup type and save set name.49Rebuilding SQL Server system databases.66Rebuilding SQL Server system databases.69Sample SharePoint Server 2013 configuration.70Example: Required save sets to be backed up.76NetWorker Module for Microsoft for SQL and SharePoint VSS 19.1 User Guide9
TABLES10NetWorker Module for Microsoft for SQL and SharePoint VSS 19.1 User Guide
PrefaceAs part of an effort to improve product lines, periodic revisions of software andhardware are released. Therefore, all versions of the software or hardware currently inuse might not support some functions that are described in this document. Theproduct release notes provide the most up-to-date information on product features.If a product does not function correctly or does not function as described in thisdocument, contact a technical support professional.NoteThis document was accurate at publication time. To ensure that you are using thelatest version of this document, go to the Support website https://www.dell.com/support.PurposeThis guide contains information about using the NetWorker Module for Microsoft(NMM) 19.1 software to back up and recover SQL Server and SharePoint Server usingthe Volume Shadow Copy Service (VSS) technology.NoteThe NetWorker Module for Microsoft Administration Guide supplements the backup andrecovery procedures described in this guide and must be referred to when performingapplication-specific tasks. Download a copy of the NetWorker Module for MicrosoftAdministration Guide from the Support website (https://support.emc.com) beforeusing this guide.AudienceThis guide is part of the NMM documentation set, and is intended for use by systemadministrators during the setup and maintenance of the product. Readers should befamiliar with the following technologies used in backup and recovery:lNetWorker softwarelMicrosoft Volume Shadow Copy Service (VSS) technologyNetWorker Module for Microsoft for SQL and SharePoint VSS 19.1 User Guide11
PrefaceRevision historyThe following table presents the revision history of this document.Table 1 Revision historyRevisionDateDescription01May 20, 2019First release of this document for the NetWorkerModule for Microsoft 19.1 Beta release.Related documentationThe NMM documentation set includes the following publications:lNetWorker Module for Microsoft Release NoteslNetWorker Module for Microsoft Administration GuidelNetWorker Module for Microsoft Installation GuidelNetWorker Module for Microsoft for SQL and SharePoint VSS User GuidelNetWorker Module for Microsoft for SQL VDI User GuidelNetWorker Module for Microsoft for Exchange VSS User GuidelNetWorker Module for Microsoft for Hyper-V User GuidelItemPoint for Microsoft SQL Server User GuidelItemPoint for Microsoft Exchange Server User GuidelItemPoint for Microsoft SharePoint Server User GuidelNetWorker documentation setSpecial notice conventions th
Dell EMC NetWorker Module for Microsoft for SQL and SharePoin
