Dell EMC Avamar for SQL Server User Guide

1 Dell EMC Avamar for SQL ServerVersion Guide302-005-838 REV 01 November 2019 Copyright 2001-2019 Dell Inc. or its subsidiaries. All rights believes the information in this publication is accurate as of its publication date. The information is subject to change without 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 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 EMCH opkinton.

2 Massachusetts 01748-91031-508-435-1000 In North America EMC Avamar for SQL Server User 12 Avamar 12 How Avamar connects to SQL Cluster availability 21 Data Domain system 21 Server 22 Backup 22 Backups in AlwaysOn availability 25 Mixed backup 26 Database log 26 Backups with other 27 Restore to the original 27 Restore to a new database in the original 27 Restore to a different instance on the original 27 Restore to an instance on a different 28 Restore to a to an AlwaysOn availability of a database with an intact log 30 Restore of system 30 Tail-log 31 Point-in-time 31 SQL Server recovery 32 Year level 33 Disaster 33 Installation35 Preparing to install the SQL Server 36 System 36 Preparing a stand-alone 41 Preparing a the the 43 Installing the Avamar Plug-in for SQL 44 Installing the Avamar client 45 Installation road 45 Installing the Avamar Client for 45 Installing the Avamar Plug-in for SQL 46 Silent installation of Itempoint for 1 Chapter 2 CONTENTSDell EMC Avamar for SQL Server User Guide3 Registering the 47 Configuring the cluster client in a failover 48 Configuring the cluster client for an AlwaysOn availability 49 Configuring the cluster client for an AlwaysOn availability group onAmazon Web Services and 51 Upgrading the Avamar client 53 Upgrading on a stand-alone in a 53 Uninstalling the Avamar client 54 Uninstall road 54 Uninstalling the cluster client in a failover 55 Uninstalling the cluster client for an AlwaysOn availability 55 Backup57 Perform an on-demand SQL backup by using AUI.

3 58 Configure the SQL Server 59 Scheduling backups using the AUI Policy a 61 Creating a backup 62 Enabling a scheduled backup for a backup 62 Monitoring 62 Cancel 63 Verifying 63 Enforcement of backups to Data 64 Application Consistent SQL Virtual Machine Image Backup65 Managing advanced an advanced group 66 Configure a 67 Configure the SQL Server 67 Configure a proxy for the image 69 Remove an advanced 69 Edit an advanced 69 View advanced policy 70 Migrate existing Backup Policy to an Advanced requirements for 74 Tail-log backup and point-in-time restore 75 Requirements to restore secondary database 75 Requirements to restore the Report Server 76 SQL Server write permission 76 Determine the restore size for an SQL Server 76 Determine the space required to restore the system the space required to restore a single SQL Server the space required to restore multiple SQL Server 77 Restore features available by using the 77 Restoring a database to the original 77 Chapter 3 Chapter 4 Chapter 5 Contents4 Dell EMC Avamar for SQL Server User GuideRestoring a database to a different client or 78 Restoring to a new database in the original 80 Restore SQL instance or database to a 82 Table Level features available by using Avamar 86 Finding a 86 Restoring to the original 89 Restoring to a 91 Restoring system to an AlwaysOn availability 103 Restoring a database with an intact log 106 Setting restore 107 Restore only on primary 116 Monitor 116 Cancel 117 Disaster Recovery119 Preparing for disaster 120 Performing disaster 120 SQL

4 Plug-in Options121 How to set plug-in plug-in backup 122 Backup 126 SQL plug-in restore 132 SQL TLR plug-in 137 SQL TLR plug-in browse TLR plug-in restore Line Interface139 Overview of the SQL Server plug-in 140 Command 142 Specifying command line 158 Password 159 Performing command line operations in a failover 159 Performing command line operations in an AlwaysOn 159 CLI 160 Example browse backup 161 Example restore 164avsqltlr command 170avsqltlr 170avsqltlr 170 Monitoring CLI problems and 172 Restore problems and 173 Upgrade problems and 173 Chapter 6 Appendix AAppendix BAppendix CContentsDell EMC Avamar for SQL Server User Guide5 Cluster Configuration Tool CLI175 Cluster Configuration Tool CLI 177 SQL plugin configure 177 SQL plugin remove 178 SQLA lwayson plugin configure 179 SQLA lwayson plugin remove 180 Cluster Configuration Tool CLI for Microsoft SQL Server Notes183 Supported environments for ItemPoint for Microsoft SQL for ItemPoint for Microsoft SQL 185187 Appendix DAppendix EGlossaryContents6 Dell EMC Avamar for SQL Server User GuidePrefaceAs part of an effort to improve the product lines, revisions of the software and hardware areperiodically released.

5 Therefore, some functions that are described in this document might not besupported by all versions of the software or hardware currently in use. The product release notesprovide the most up-to-date information on product the technical support professional when a product does not function correctly or does notfunction as described in this : This document was accurate at publication time. To find the latest version of thisdocument, go to Online Support ( ).PurposeThis Guide describes how to install Avamar in a Microsoft SQL Server database environment, andhow to back up and restore SQL Server information in this Guide is primarily intended for:lSystem administrators who are responsible for installing software and maintaining servers andclients on a networklMicrosoft SQL Server administrators who are responsible for backing up and maintainingMicrosoft SQL ServersPersons using this Guide should have current practical experience with the following topics.

6 LOperating system shell commands on the SQL Server platform (root permission required)lThe specific version of Microsoft SQL Server currently deployed at the siteRevision historyThe following table presents the revision history of this historyTable 1 Revision historyRevisionDateDescription01 November 15, 2019GA release of Avamar documentationThe following publications provide additional information:lE-LAB Navigator at Release NoteslAvamar Administration GuidelAvamar for Windows Server User GuidelAvamar and Data Domain System Integration GuidelAvamar Operational Best Practices GuidelAvamar for Hyper-V VSS User GuideDell EMC Avamar for SQL Server User Guide7lAvamar for VMware User GuideSpecial notice conventions used in this documentThese conventions are used for special Indicates a hazardous situation which, if not avoided, results in death or Indicates a hazardous situation which, if not avoided, could result in death orserious Indicates a hazardous situation which, if not avoided, could result in minor ormoderate Addresses practices that are not related to personal.

7 Presents information that is important, but not conventionsThese type style conventions are used in this 2 Typographical conventionsBoldUsed for names of interface elements, such as names of windows,dialog boxes, buttons, fields, tab names, key names, and menu paths(what the user specifically selects or clicks)ItalicUsed for full titles of publications that are referenced in textMonospaceUsed for:lSystem codelSystem output, such as an error message or scriptlPathnames, filenames, prompts, and syntaxlCommands and optionsMonospace italicUsed for variablesMonospace boldUsed for user input[ ]Square brackets enclose optional values|Vertical bar indicates alternate selections - the bar means or { }Braces enclose content that the user must specify, such as x or y indicate nonessential information that is omitted from theexampleWhere to get helpThe Avamar support page provides access to licensing information, product documentation,advisories, and downloads, as well as how-to and troubleshooting information.

8 This informationmay resolve a product issue before contacting Customer access the Avamar support page:1. Go to Type a product name in the Enter a Service Tag, Serial Number, Service Request, Model,or Keyword search EMC Avamar for SQL Server User Guide3. Select the product from the list that appears. When you select a product, the ProductSupport page loads (Optional) Add the product to the My Products list by clicking Add to My Saved Products inthe upper right corner of the Product Support Avamar product documentation provides a comprehensive set of feature overview, operationaltask, and technical reference information. To supplement the information in product administrationand user guides, review the following documents:lRelease notes provide an overview of new features and known limitations for a notes provide technical details about specific product features, including step-by-step tasks, where papers provide an in-depth technical perspective of a product or products as applied tocritical business issues or Knowledgebase contains applicable solutions that you can search for either by solutionnumber (for example, KB000xxxxxx) or by search the Knowledgebase:1.

9 Go to Under the Support tab, click Knowledge Type either the solution number or keywords in the search box. 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 communitiesGo to Community Network at for peer contacts, conversations, andcontent on product support and solutions. Interactively engage online with customers, partners,and certified professionals for all chatTo engage Customer Support by using live interactive chat, click Join Live Chat on the ServiceCenter panel of the Avamar support RequestsFor in-depth help from Customer Support, submit a service request by clicking Create ServiceRequests on the Service center panel of the Avamar support : To open a service request, you must have a valid support agreement.

10 Contact a salesrepresentative for details about obtaining a valid support agreement or with questions about review an open service request, click the Service center link on the Service center panel, andthen click View and manage service supportIt is recommended to enable ConnectEMC and Email Home on all Avamar systems:lConnectEMC automatically generates service requests for high priority Home sends configuration, capacity, and general system information to EMC Avamar for SQL Server User Guide9 Comments and suggestionsComments and suggestions help to continue to improve the accuracy, organization, and overallquality of the user publications. Send comments and suggestions about this document to include the following information:lProduct name and versionlDocument name, part number, and revision (for example, 01)lPage numberslOther details to help address documentation issuesPreface10 Dell EMC Avamar for SQL Server User GuideCHAPTER 1 IntroductionThis chapter includes the following level 33 Dell EMC Avamar for SQL Server User Guide11 ArchitectureYou can use Avamar to back up and restore data in a variety of Microsoft SQL componentsRequired Avamar software components in a SQL Server environment include the Avamar Client forWindows, the Avamar Plug-in for SQL Server , and the Avamar Management Web UI (AUI)