Dell EMC Avamar for SQL Server User Guide

Dell EMC Avamar for SQL Server

Version 19.2

User Guide

302-005-838 REV 01 November 2019

Copyright ? 2001-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 KIND WITH RESPECT TO THE INFORMATION IN THIS PUBLICATION, AND SPECIFICALLY DISCLAIMS IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. USE, COPYING, AND DISTRIBUTION OF ANY DELL SOFTWARE DESCRIBED IN 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 property of their respective owners. Published in the USA.

Dell EMC Hopkinton, Massachusetts 01748-9103 1-508-435-1000 In North America 1-866-464-7381

2

Dell EMC Avamar for SQL Server User Guide

CONTENTS

Preface Chapter 1

Chapter 2

7

Introduction

11

Architecture...................................................................................................... 12

Avamar components............................................................................. 12

How Avamar connects to SQL Server...................................................13

Failover Cluster Instances.....................................................................13

AlwaysOn availability groups.................................................................16

Database mirroring............................................................................... 21

Data Domain system support................................................................ 21

Server virtualization............................................................................. 22

Backup.............................................................................................................. 22

Backup types....................................................................................... 22

Backups in AlwaysOn availability groups.............................................. 25

Mixed backup storage.......................................................................... 25

Multistreaming..................................................................................... 26

Database log truncation....................................................................... 26

Backups with other tools......................................................................26

Restore............................................................................................................. 27

Restore to the original location............................................................ 27

Restore to a new database in the original instance............................... 27

Restore to a different instance on the original server...........................27

Restore to an instance on a different server........................................ 28

Restore to a file....................................................................................28

Restore to an AlwaysOn availability group............................................28

Restore of a database with an intact log file........................................ 30

Restore of system databases............................................................... 30

Tail-log backup..................................................................................... 31

Point-in-time restore............................................................................ 31

SQL Server recovery operations.......................................................... 32

Year 2038.............................................................................................33

Table level recovery.......................................................................................... 33

Disaster recovery.............................................................................................. 33

Installation

35

Preparing to install the SQL Server plug-in....................................................... 36

System requirements........................................................................... 36

Preparing a stand-alone server............................................................. 41

Preparing a cluster................................................................................41

Downloading the software....................................................................42

Verifying the environment....................................................................43

Installing the Avamar Plug-in for SQL Server.................................................... 44

Installing the Avamar client software................................................................ 45

Installation road maps.......................................................................... 45

Installing the Avamar Client for Windows.............................................45

Installing the Avamar Plug-in for SQL Server....................................... 46

Silent installation of Itempoint for SQL.................................................47

Dell EMC Avamar for SQL Server User Guide

3

Contents

Registering the client........................................................................... 47 Configuring the cluster client in a failover cluster................................ 48 Configuring the cluster client for an AlwaysOn availability group......... 49 Configuring the cluster client for an AlwaysOn availability group on Amazon Web Services and Azure......................................................... 51 Upgrading the Avamar client software.............................................................. 53 Upgrading on a stand-alone server.......................................................53 Upgrading in a cluster.......................................................................... 53 Uninstalling the Avamar client software............................................................ 54 Uninstall road map............................................................................... 54 Uninstalling the cluster client in a failover cluster................................ 55 Uninstalling the cluster client for an AlwaysOn availability group......... 55

Chapter 3

Backup

57

Perform an on-demand SQL backup by using AUI ............................................58

Configure the SQL server policy....................................................................... 59

Scheduling backups using the AUI Policy wizard...............................................60

Creating a dataset................................................................................ 61

Creating a backup policy...................................................................... 62

Enabling a scheduled backup for a backup policy................................. 62

Monitoring backups.......................................................................................... 62

Cancel backups.................................................................................................63

Verifying backups............................................................................................. 63

Enforcement of backups to Data Domain..........................................................64

Chapter 4

Application Consistent SQL Virtual Machine Image Backup

65

Managing advanced policies............................................................................. 66

Prerequisites.....................................................................................................66

Add an advanced group policy.......................................................................... 66

Configure a source............................................................................... 67

Configure the SQL server policy.......................................................... 67

Configure members..............................................................................68

Configure a proxy for the image backup.............................................. 69

Remove an advanced policy.............................................................................. 69

Edit an advanced policy.................................................................................... 69

View advanced policy details.............................................................................70

Migrate existing Backup Policy to an Advanced Policy......................................70

View logs...........................................................................................................70

Chapter 5

Restore

73

Restore requirements........................................................................................74

Software requirements for restore....................................................... 74

Tail-log backup and point-in-time restore requirements....................... 75

Requirements to restore secondary database files............................... 75

Requirements to restore the Report Server database.......................... 76

SQL Server write permission requirements.......................................... 76

Determine the restore size for an SQL server database.................................... 76

Determine the space required to restore the system database.............76

Determine the space required to restore a single SQL server database....

76

Determine the space required to restore multiple SQL server databases

............................................................................................................. 77

Restore features available by using the AUI...................................................... 77

Restoring a database to the original client............................................77

4

Dell EMC Avamar for SQL Server User Guide

Contents

Restoring a database to a different client or instance.......................... 78 Restoring to a new database in the original instance............................80 Restore SQL instance or database to a file.......................................... 82 Table Level restore...............................................................................84 Restore features available by using Avamar Administrator................................86 Finding a backup.................................................................................. 86 Restoring to the original location......................................................... 89 Restoring to a file................................................................................. 91 Restoring system databases.................................................................97 Restoring to an AlwaysOn availability group....................................... 103 Restoring a database with an intact log file........................................ 106 Setting restore options....................................................................... 107 Restore only on primary replica........................................................... 116 Monitor restores.............................................................................................. 116 Cancel restores................................................................................................ 117

Chapter 6

Disaster Recovery

119

Preparing for disaster recovery....................................................................... 120

Performing disaster recovery.......................................................................... 120

Appendix A

SQL Plug-in Options

121

How to set plug-in options...............................................................................122

SQL plug-in backup options.............................................................................122

Backup options................................................................................................ 126

SQL plug-in restore options.............................................................................132

SQL TLR plug-in options..................................................................................137

SQL TLR plug-in browse options.........................................................137

SQL TLR plug-in restore options.........................................................137

Appendix B

Command Line Interface

139

Overview of the SQL Server plug-in CLI..........................................................140

Command reference........................................................................................ 140

Synopsis............................................................................................. 140

Operations.......................................................................................... 140

Options............................................................................................... 142

Specifying command line options.................................................................... 158

Password encoding......................................................................................... 159

Performing command line operations in a failover cluster................................159

Performing command line operations in an AlwaysOn environment................. 159

CLI examples................................................................................................... 160

Example browse commands................................................................160

Example backup commands................................................................ 161

Example restore commands................................................................ 164

avsqltlr command reference............................................................................ 170

avsqltlr synopsis................................................................................. 170

avsqltlr options................................................................................... 170

Monitoring CLI activities..................................................................................170

Appendix C

Troubleshooting

171

Backup problems and solutions........................................................................ 172

Restore problems and solutions....................................................................... 173

Upgrade problems and solutions...................................................................... 173

Dell EMC Avamar for SQL Server User Guide

5

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download