IBM Spectrum Protect for Databases: Data Protection for ...

IBM Spectrum Protect for Databases

Version 8.1.4

Data Protection for Microsoft SQL Server Installation and User's Guide

IBM

IBM Spectrum Protect for Databases

Version 8.1.4

Data Protection for Microsoft SQL Server Installation and User's Guide

IBM

Note: Before you use this information and the product it supports, read the information in "Notices" on page 297.

This edition applies to version 8, release 1, modification 4 of IBM Spectrum Protect for Databases (product number 5725-X01) and to all subsequent releases and modifications until otherwise indicated in new editions. ? Copyright IBM Corporation 1997, 2017. US Government Users Restricted Rights ? Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

Contents

Tables . . . . . . . . . . . . . . . vii

About this publication . . . . . . . . ix

Who should read this guide . . . . . . . . . ix Publications . . . . . . . . . . . . . . ix Reading syntax diagrams . . . . . . . . . . ix

Data Protection for Microsoft SQL Server updates V8.1.4 . . . . . . . . xiii

Chapter 1. Getting Started . . . . . . . 1

Environment overview . . . . . . . . . . . 1 Failover clustering and AlwaysOn Availability . . . 2

Availability database backup operations . . . . 3 Availability database restore operations . . . . 4 Data Protection for AlwaysOn Availability Groups 5 Automated IBM Spectrum Protect server failover for data recovery . . . . . . . . . . . . 6 Data backup overview . . . . . . . . . . . 8 VSS data backups. . . . . . . . . . . . 8 Offloaded VSS backups . . . . . . . . . 13 SQL Server legacy backups . . . . . . . . 14 Database backup types . . . . . . . . . 14 Policy management for backups . . . . . . 16 Data restore overview . . . . . . . . . . . 28 VSS fast restore processing . . . . . . . . 28 VSS instant restore processing . . . . . . . 29

Chapter 2. Installing, upgrading, and migrating. . . . . . . . . . . . . . 31

Prerequisites . . . . . . . . . . . . . . 31 Installing and configuring Data Protection for SQL Server . . . . . . . . . . . . . . . . 32

Installing Data Protection for SQL Server . . . 33 Completing the installation configuration . . . 33 Verifying the configuration . . . . . . . . 34 Customizing the configuration . . . . . . . 35 Installing on a local system . . . . . . . . . 35 Installing on Windows Server Core . . . . . . 37 Installing in a cluster environment. . . . . . . 37 Silently installing Data Protection for SQL Server . . 38 Silently installing the IBM Spectrum Protect client . . . . . . . . . . . . . . . 38 Silently installing Data Protection for SQL Server with the setup program . . . . . . . . . 39 Silently installing with the Microsoft Installer program . . . . . . . . . . . . . . 40 Options in silent installations . . . . . . . 41 Creating and testing a silent installation package on a DVD or a file server . . . . . . . . . 43 Silent installation error messages . . . . . . 44 Upgrading Data Protection for SQL Server . . . . 44 Migrating Data Protection for SQL Server . . . . 44

? Copyright IBM Corp. 1997, 2017

Chapter 3. Configuring . . . . . . . . 47

Specifying configuration parameters for IBM Spectrum Protect . . . . . . . . . . . . 47 Specifying Data Protection for SQL Server node name parameters . . . . . . . . . . . . 49 Specifying configuration and options files in non-default locations . . . . . . . . . . . 50 Configuring proxy relationships for VSS backups . . 51

Required node names for basic VSS operations 52 Required node names for basic VSS offloaded backups . . . . . . . . . . . . . . 52 Setting user preferences . . . . . . . . . . 54 Data Protection properties . . . . . . . . 54 Configuring by using the IBM Spectrum Protect Configuration Wizard . . . . . . . . . . . 65 Configuring a remote system with an IBM Spectrum Protect configuration . . . . . . . . . . . 67 Configuring IBM Spectrum Protect policy to set automatic expiration and version control (VSS and legacy backups) . . . . . . . . . . . . . 68 Setting automatic expiration for VSS backups . . 68 Setting automatic expiration for legacy backups 69 Configuring in a clustered environment . . . . . 70 Configuring Data Protection for SQL Server with IBM Spectrum Protect in a clustered environment 70 Configuring VSS operations in a clustered environment . . . . . . . . . . . . . 72 Configuring availability replicas to run scheduled data backups . . . . . . . . . . . . . 73 Manually configuring Data Protection for SQL Server . . . . . . . . . . . . . . . . 74 Configuring the computer that runs the SQL Server . . . . . . . . . . . . . . . 74 Configuring the IBM Spectrum Protect server . . 75 Configuring the system that runs the offloaded backups . . . . . . . . . . . . . . 76 Verifying the configuration of Data Protection for SQL Server . . . . . . . . . . . . . 77 Manually configuring Data Protection for SQL Server on Windows Server Core . . . . . . . 79 Creating a node on the IBM Spectrum Protect server . . . . . . . . . . . . . . . 79 Setting up a proxy node for offloaded VSS backups in the Windows Server Core environment . . . . . . . . . . . . . 80 Configuring the client in the Windows Server Core environment . . . . . . . . . . . 81 Configuring Data Protection for SQL Server on Windows Server Core . . . . . . . . . . 83 Changing Data Protection for SQL Server configuration values on Windows Server Core. . 85 Transitioning SQL Server backups from IBM Spectrum Protect Snapshot to IBM Spectrum Protect. 85 Configuring the IBM Spectrum Protect server . . 86 Configuring the workstation that runs the SQL Server . . . . . . . . . . . . . . . 86

iii

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

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

Google Online Preview   Download