Dell EMC NetWorker Module For Microsoft For SQL VDI User Guide
Dell EMC NetWorker Module for Microsoftfor SQL VDIVersion 19.2User GuideREV 01November 2019
Copyright 2007-2019 Dell Inc. or its subsidiaries. All rights reserved.Dell 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 Technologies, Dell, EMC, Dell EMC and other trademarks are trademarks of Dell Inc. or its subsidiaries. Other trademarks may be the propertyof their respective owners. Published in the USA.Dell EMCHopkinton, Massachusetts 01748-91031-508-435-1000 In North America 1-866-464-7381www.DellEMC.com2Dell EMC NetWorker Module for Microsoft for SQL VDI User Guide
CONTENTSFigures7Tables9Preface11Chapter 1Overview15Using NMM with Virtual Device Interface API. 16SQL Server backup and restore workflow. 18Traditional backup workflow (stand-alone backup over a storage node).18Federated backup workflow (AlwaysOn Availability Groupconfiguration).19Recovery workflow. 20SQL Server cluster environments. 22SQL Server backups. 23Types of supported backups. 23Setting backup levels. 24Backup promotion. 27SQL Server recovery. 29Types of supported recovery. 29Recovery modes. 30Recovery time. 31Recovery window restrictions. 32The recovery process.32SQL Server instance and database names for backup and recovery. 33Named and default instances of SQL Server. 33Supported special characters in database names for NMM backup andrecovery .34Chapter 2Configuration37Configuring NMM in a SQL VDI environment. 38Supported Windows Server and SQL Server versions. 38Migrating from VSS solution to VDI solution for SQL Server dataprotection. 38Multi-stream Data Domain Boost. 38Microsoft SQL Server Always On Availability Group feature . 38Availability group listeners.39Clusterless availability group listeners. 39SQL Client Direct to AFTD or DD devices. 40Microsoft SQL Server named log marks.40Database consistency checks. 41Microsoft hybrid cloud environments. 42Transparent data encryption. 42Setting the MAXTRANSFERSIZE environment variable. 43Dell EMC NetWorker Module for Microsoft for SQL VDI User Guide3
ContentsConfiguring permissions to perform NMM backup and recovery of MicrosoftSQL Server. 44Access privileges for backup and recovery.44Assign SQL server roles for backup and recovery operations. 44Assigning Windows user privileges for backup and recovery operations.45Chapter 3Graphical User Interfaces49User interfaces for backup and restore.50NMM Microsoft SQL Server Management Studio plug-in GUI.50Views of the NMM SQL Server Management Studio plug-in GUI. 51Chapter 4Manual Backups53Manual backup overview.54Federated backup preferences for Availability Group databases. 54Specifying a retention policy for manual backups. 55Performing manual backups by using the NMM SSMS plug-in GUI. 56Performing manual backups from the command prompt. 61Command syntax for nsrsqlsv. 62Command options for nsrsqlsv. 63Backup and recovery command syntax for SQL Server data.68Example backup command syntax. 72Chapter 5Scheduled Backups75Overview of scheduled backup.76Prerequisites. 76Federated backup preferences for Availability Group databases. 76Excluding incompatible databases in backups. 78Configuring scheduled backups.78Setting up backup levels. 79Configuring a client resource. 80Setting data protection policies. 93Monitoring scheduled backups .98Chapter 6Data Restore101Overview. 102Prerequisites. 102Restoring data by using the NMM SSMS plug-in GUI.103Restoring data by using the CLI. 110Command syntax for nsrsqlrc. 111Command options for nsrsqlrc.112Backup and recovery command syntax for SQL Server data. 121Example recovery command syntax .125Chapter 7Granular Level Recovery127Overview. 128Considerations.128Performing Granular Level Recovery. 133Dismounting backups after performing GLR. 136Using the Mount system tray icon. 1374Dell EMC NetWorker Module for Microsoft for SQL VDI User Guide
ContentsChapter 8Striped Backup and Recovery139Overview of striped backups. 140Performance considerations. 140Performing striped backups. 141Performing striped recovery.142Optimal striped recovery operations. 142Fail-safe striped recovery operations.142Chapter 9Disaster Recovery145Overview of disaster recovery. 146Disaster recovery features. 146Performing disaster recovery.147When not to reinstall the SQL Server. 147Restoring a damaged primary disk. 148Restoring a damaged binary disk. 149Restoring SQL Server and NetWorker server. 150Restoring the SQL Server without reinstallation. 151Restoring the SQL Server.152Chapter 10Bare Metal Recovery155Planning bare-metal recovery.156Overview. 156System requirements.156Protecting an environment before a disaster. 158BMR by using NetWorker and NMM. 159SQL Server in a cluster environment. 159Backing up a SQL Server for BMR.159Performing BMR of a SQL Server cluster.161SQL Server in a stand-alone environment.163Backing up a SQL Server for BMR.163Performing BMR of a stand-alone SQL Server. 165Chapter 11Troubleshooting167Error logs for backup and recovery.168SQL savegroup notifications.168Troubleshooting general issues.169Troubleshooting GLR.169Dell EMC NetWorker Module for Microsoft for SQL VDI User Guide5
Contents6Dell EMC NetWorker Module for Microsoft for SQL VDI User Guide
27282930313233343536VDI backup process between NMM and SQL Server. 17VDI recovery process between NMM and SQL Server.18Traditional backup workflow. 19Federated backup workflow.20Traditional recovery workflow. 21Message showing DBCC was successful.42Assigning SQL Server privileges.45Adding a user to Windows User Groups. 47The NetWorker window in the NMM SMSS plug-in GUI .51NetWorker Backup General page. 57NetWorker Backup Options page.58NetWorker Backup Monitor page. 61Starting the Client Configuration wizard. 81Specify Client Information page. 82Specify Backup Configuration Type page.83Specify the Backup Options page. 85Viewing clients in the Protection tab.86Create Policy window. 94Creating a workflow for the policy. 95Specifying action information in the Policy Action wizard. 96Adding a group to a policy from the Protection pane. 97Specifying workflow and client in the Create Group window.98Successful backup messages. 99Failed backup messages.99NetWorker dialog box—Database Restore tab General page. 104NetWorker dialog box—Database Restore tab General page for copy restore. 105NetWorker dialog box—Database Restore Files/Filegroups page. 106NetWorker dialog box—Database Restore Options page.107NetWorker dialog box—Database Restore Monitor page.110NetWorker dialog box—Table Restore General page.134NetWorker dialog box—Table Restore Options page. 135NetWorker dialog box—Table Restore Monitor page. 136Mount system tray menu. 137Mount Details window.137SQL Server Properties dialog box. 163Example of SQL savegroup notification. 169Dell EMC NetWorker Module for Microsoft for SQL VDI User Guide7
Figures8Dell EMC NetWorker Module for Microsoft for SQL VDI User Guide
728293031323334353637383940414243Revision history. 12Style conventions. 12Backup levels for SQL Server data.25Full backup every 1 to 2 weeks. 25Logs-only backup after a full backup.26Backup level advantages and disadvantages. 26Creating additional backup levels with data objects. 26Backup level promotion process . 27Types of recovery for SQL Server VDI . 29Recovery modes . 31Supported special characters in database names. 34Access privileges required for backup and recovery operations. 44Where to start backup operations.50Where to start restore operations.50Command options for nsrsqlsv . 63Command syntax for SQL Server data. 68Command syntax for names containing a period. 71Command syntax for names containing a backslash.71Command syntax for names containing a colon. 71Tasks for configuring SQL Server VDI backups . 79Backup levels for SQL Server data.80Save sets in a standalone environment.87Save sets in a cluster environment. 87Application Information field values.88Save sets.91Application Information field values. 91Advanced restore options.108Command options for nsrsqlrc .112Command syntax for SQL Server data.122Command syntax for names containing a period. 124Command syntax for names containing a backslash. 124Command syntax for names containing a colon. 124ItemPoint for SQL Server requirements. 128Guidelines for fail-safe striped recovery. 142Disaster recovery features.146Rebuilding SQL Server system databases.148Rebuilding SQL Server system databases.149Rebuilding SQL Server system databases.150Rebuilding SQL Server system databases. 151Rebuilding SQL Server system databases.162Rebuilding SQL Server system databases.165Program and log file names without debug logging enabled.168Program and log file names with debug logging enabled. 168Dell EMC NetWorker Module for Microsoft for SQL VDI User Guide9
Tables10Dell EMC NetWorker Module for Microsoft for SQL VDI User Guide
PrefaceAs part of an effort to improve product lines, periodic revisions of software and hardware arereleased. Therefore, all versions of the software or hardware currently in use might not supportsome functions that are described in this document. The product release notes provide the mostup-to-date information on product features.If a product does not function correctly or does not function as described in this document,contact a technical support professional.Note: This document was accurate at publication time. To ensure that you are using the latestversion 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.2software to back up and recover SQL Server using the Virtual Device Interface (VDI) technology.Note: The NetWorker Module for Microsoft Administration Guide supplements the backup andrecovery procedures described in this guide and must be referred to when performingapplication-specific tasks. Ensure to download a copy of the NetWorker Module for MicrosoftAdministration Guide from the Support website at https://support.emc.com before using thisguide.AudienceThis guide is part of the NetWorker Module for Microsoft documentation set and is intended foruse by system administrators during the setup and maintenance of the product. Readers should befamiliar with the following technologies used in backup and recovery:lNetWorker softwarelMicrosoft Virtual Device Interface (VDI) technologyDell EMC NetWorker Module for Microsoft for SQL VDI User Guide11
PrefaceRevision historyThe following table presents the revision history of this document.Table 1 Revision historyRevisionDateDescription01November, 2019First release of this document for the NetWorkerModule for Microsoft 19.2 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 that are used in this documentThe following conventions are used for special notices:NOTICE Identifies content that warns of potential business or data loss.Note: Contains information that is incidental, but not essential, to the topic.Typographical conventionsThe following type style conventions are used in this document:Table 2 Style conventions12BoldUsed for interface elements that a user specifically selects or clicks,for example, names of buttons, fields, tab names, and menu paths.Also used for the name of a dialog box, page, pane, screen area withtitle, table label, and window.ItalicUsed for full titles of publications that are referenced in text.MonospaceUsed for:lSystem codelSystem output, such as an error message or scriptlPathnames, file names, file name extensions, prompts, andsyntaxlCommands and optionsDell EMC NetWorker Module for Microsoft for SQL VDI User Guide
PrefaceTable 2 Style conventions (continued)Monospace italicUsed for variables.Monospace boldUsed for user input.[]Square brackets enclose optional values. Vertical line indicates alternate selections. The vertical line means orfor the alternate selections.{}Braces enclose content that the user must specify, such as x, y, or z.Ellipses indicate non-essential information that is omitted from theexample.You can use the following resources to find more information about this product, obtain support,and provide feedback.Where to find product /community.emc.comWhere to get supportThe Support website https://www.dell.com/support provides access to product licensing,documentation, advisories, downloads, and how-to and troubleshooting information. Theinformation can enable you to resolve a product issue before you contact Support.To access a product-specific page:1. Go to https://www.dell.com/support.2. In the search box, type a product name, and then from the list that appears, select theproduct.KnowledgebaseThe Knowledgebase contains applicable solutions that you can search for either by solutionnumber (for example, KB000xxxxxx) or by keyword.To search the Knowledgebase:1. Go to https://www.dell.com/support.2. On the Support tab, click Knowledge Base.3. In the search box, type either the solution number or keywords. Optionally, you can limit thesearch to specific products by typing a product name in the search box, and then selecting theproduct from the list that appears.Live chatTo participate in a live interactive chat with a support agent:1. Go to https://www.dell.com/support.2. On the Support tab, click Contact Support.3. On the Contact Information page, click the relevant support, and then proceed.Service requestsTo obtain in-depth help from Licensing, submit a service request. To submit a service request:1. Go to https://www.dell.com/support.Dell EMC NetWorker Module for Microsoft for SQL VDI User Guide13
Preface2. On the Support tab, click Service Requests.Note: To create a service request, you must have a valid support agreement. For details abouteither an account or obtaining a valid support agreement, contact a sales representative. Tofind the details of a service request, in the Service Request Number field, type theservice request number, and then click the right arrow.To review an open service request:1. Go to https://www.dell.com/support.2. On the Support tab, click Service Requests.3. On the Service Requests page, under Manage Your Service Requests, click View All DellService Requests.Online communitiesFor peer contacts, conversations, and content on product support and solutions, go to theCommunity Network https://community.emc.com. Interactively engage with customers, partners,and certified professionals online.How to provide feedbackFeedback helps to improve the accuracy, organization, and overall quality of publications. You cansend feedback to DPAD.Doc.Feedback@emc.com.14Dell EMC NetWorker Module for Microsoft for SQL VDI User Guide
CHAPTER 1OverviewThis chapter includes the following sections:llllllUsing NMM with Virtual Device Interface API.16SQL Server backup and restore workflow. 18SQL Server cluster environments.22SQL Server backups.23SQL Server recovery. 29SQL Server instance and database names for backup and recovery. 33Dell EMC NetWorker Module for Microsoft for SQL VDI User Guide15
OverviewUsing NMM with Virtual Device Interface APIYou can use the NetWorker Module for Microsoft (NMM) software to back up and recoverMicrosoft SQL Server data. NMM uses Virtual Device Interface (VDI), an API that Microsoft SQLServer provides, to integrate with the SQL Server and enable the NetWorker software to back upand recover SQL Server data.Note: Any references to the Data Domain systems and the Data Domain devices in the productalso apply to the PowerProtect Data Domain systems.When you install NMM, you can run the System Configuration Checker from the Installationwizard. It is recommended that you run the System Configuration Checker to ensure that thesetup is correctly configured for backup and recovery. The NetWorker Module for MicrosoftInstallation Guide provides details.Note: If you are a NetWorker Module for SQL Server (NMSQL) user and are migrating toNMM VDI, perform a full backup of the SQL Server data after you install NMM VDI. NMM VDIcannot recover SQL snapshot data backed up with NMSQL.The following figure describes the backup process that takes place between NMM and the SQLServer using VDI:1. The user starts the backup process with NMM.2. The backup command is sent to the SQL Server. This interaction is performed through the VDIAPI.3. NMM reads the data from SQL Server and stores it on the NetWorker server.4. NMM sends the backup status to the NetWorker Server and notifies the user when the backupis complete.16Dell EMC NetWorker Module for Microsoft for SQL VDI User Guide
OverviewFigure 1 VDI backup process between NMM and SQL ServerThe following figure describes the recovery process that takes place between NMM and the SQLSer
Dell EMC NetWorker Module for Microsoft for SQL VDI Version 19.2 User Guide REV 01 November 2019
Dell EMC NetWorker Version 18.2 Licensing Guide 302-005-329 . NetWorker 9.x upgrade to NetWorker 18.2 with served license.39 NetWorker 9.x upgrade to NetWorker 18.2 with unserved license. 40 Figures Tables Preface Chapter 1 Chapter 2 CONTENTS NetWorker 18.2 Licensing Guide 3.
Dell EMC NetWorker software Dell EMC NetWorker modules (e.g. NMM, NMDA) Exam Topics Topics likely to be covered on this exam include: Dell EMC NetWorker Overview (10%) Describe a NetWorker solution and its advantages Identify and describe the NetWorker software components and their roles,
Implementing persistent binding through EMC NetWorker Integrating EMC Avamar for deduplication Implementing EMC NetWorker in case of a bidirectional as well as unidirectional hardware firewall including various scenarios for e.g. when some of the clients are in DMZ Working with the EMC NetWorker ports Implementing EMC NetWorker in a cluster
EMC NetWorker is an enterprise class Backup and Recovery solution. It is three-tiered software: 1. NetWorker Client (that hosts the data to be backed up) 2. NetWorker Server (co-ordinates the entire backup/recover process and tracks the metadata) 3. NetWorker Storage Node (that connects to diverse storage devices and writes/reads data).
EMC DiskXtender for Windows – International Support. EMC DiskXtender for Windows International Support: Search Module. EMC Backup Advisor. EMC Co-StandbyServer High Availability Solutions. EMC AutoStart. EMC RepliStor. NetWorker Fast Start. NetWorker Server and Client Software. NetWorker Data Deduplicatio
Series, DXi8000-Series, and DXi V-Series), and who also use NetWorker from EMC, to get the most out of their investment. It is also intended to help Quantum field sales teams by providing guidance to . NetWorker 9.2 administration guide NetWorker Command Documentation NetWorker 7.6 command reference guide
Dell EMC Unity: Investment Protection Grow with Dell EMC Unity All-Flash Dell EMC Unity 350F Dell EMC Unity 450F Dell EMC Unity 550F Dell EMC Unity 650F ONLINE DATA-IN PLACE UPGRADE PROCESSOR 6c / 1.7GHz 96 GB Memory 10c / 2.2GHz 128 GB Memory 14c / 2.0GHz 256 GB Memory 14c / 2.4GHz 512 GB Memory CAPACITY 150 Drives 2.4 PB 250 Drives 4 PB 500 .
(https://support.emc.com) to ensure that you are using the latest version of this document. Purpose This document describes how to configure and use NetWorker REST API. Audience This guide is part of the NetWorker documentation set, and is intended for use by developers who are creating programmatic interfaces to NetWorker systems. Revision history
