Hp 3PAR Recovery Manager Software for Microsoft SQL S Manuel d'utilisateur

HP 3PAR Recovery Manager 4.4.2 Softwarefor Microsoft SQL ServerUser GuideThis document is designed for System Administrators and Microsoft SQL Server

• Support for backup server and production server running in VMware VM Direct Environment• Support for concurrent virtual copy or remote virtual copy

UDP 16.154.142.171: 9932 *:* 1252UDP 127.0.0.1: 9932 *:* 1252This will list the process id of the application that is using the default port. (The pro

After volume promote, on few occasions, the volume involved in the restore operation might notcome online.Suggestion:From the Disk Management utility

Suggestion:Use the provcfg.exe utility provided with HP 3PAR VSS Provider to recreate an expired, aninvalid, or a new certificate.Problem:If you have

C Event MessagesThis appendix provides information for the event messages generated by HP 3PAR RecoveryManager Software for Microsoft SQL Server.Table

Table 4 HP 3PAR Recovery Manager Software for Microsoft SQL Server Event Messages (continued)Description/ActionEvent MessageEvent IDWhen you created t

Table 4 HP 3PAR Recovery Manager Software for Microsoft SQL Server Event Messages (continued)Description/ActionEvent MessageEvent IDFailed to parse th

Table 4 HP 3PAR Recovery Manager Software for Microsoft SQL Server Event Messages (continued)Description/ActionEvent MessageEvent IDRecovery Manager c

Table 4 HP 3PAR Recovery Manager Software for Microsoft SQL Server Event Messages (continued)Description/ActionEvent MessageEvent IDHP 3PAR Recovery M

Table 4 HP 3PAR Recovery Manager Software for Microsoft SQL Server Event Messages (continued)Description/ActionEvent MessageEvent IDData Protector fai

• Performing a restore on a Windows Fibre channel based host that resides in virtual environment• Customizing date formatRecovery Manager supports dat

Writer:• Microsoft SQL Server 2005, 2008, 2008 R2, and 2012 with SQL Server VSS WriterNOTE: For platform-specific release levels, refer the latest Sin

Recovery Manager LayoutFigure 2 Centralized Backup ConfigurationHP 3PAR Recovery Manager Software for SQL provides off-host backup and mounting capabi

2 Installing and Uninstalling HP 3PAR Recovery Managerfor SQLDuring the installation, an automated installer verifies the correct user authority befor

necessary installation and the overall progress is shown for completing that step in the process.There are two options for using the installation wiza

2. Click Start→Control Panel→Programs→Programs and Features.3. Verify Recovery Manager appears in the Currently installed programs column.4. Verify th

Upgrading from Recovery Manager 4.4.0 for SQL or Recovery Manager 4.4.1 forSQL to Recovery Manager 4.4.2 for SQLYou can upgrade to HP 3PAR Recovery Ma

Upgrading from Recovery Manager 4.2.0 for SQL to Recovery Manager 4.4.2 forSQLWhen upgrading, you need to uninstall the existing HP 3PAR Recovery Mana

4. Click Uninstall.NOTE: After uninstalling Recovery Manager, virtual copies and scheduled tasks still residelocally in the Data folder as well as on

© Copyright 2013 Hewlett-Packard Development Company, L.P.Confidential computer software. Valid license from HP required for possession, use or copyin

3 Configuring Recovery ManagerConfiguring the SQL DatabaseWhen you configure the SQL database:• Use database files and transaction logs created on bas

Changing a Production Server Port from the Backup Server1. On the backup server, run the following Recovery Manager CLI command:HpRmCli Sql portconfig

Figure 3 HP 3PAR Recovery Manager for SQL with Two Availability Replica NodesIn Figure 3 (page 22), HP 3PAR Recovery Manager for SQL is configured wit

Before you start configuring Recovery Manager for Availability Group:• Make sure all the prerequisites for Availability Group are met before discoveri

9. Ensure the HP 3PAR StoreServ Storage System connection is good.NOTE: For more information on HP 3PAR CLI commands, see the HP 3PAR Command LineInte

4. Click Connect. A window appears as follows:If you are able to connect, the installation and configuration is complete.If the connection cannot be m

4 Configuring Backup SoftwareOverviewHP 3PAR Recovery Manager Software for Microsoft SQL Server can be used with either HP DataProtector, Symantec Net

To configure Symantec NetBackup to function with Recovery Manager for SQL, set the followingparameters during the configuration process:SettingBackup

5. Select the device that Data Protector is to use for backups.6. Click Next until the Manual add... appears.7. Click Manual add...8. Select Windows f

Backup Exec is installed on C:\Program Files\Symantec\Backup Exec then\\hostname\c$\ Program Files\Symantec\Backup Exec must be accessible4. To suppor

Contents1 Overview of Recovery Manager...7System Requirements...

Figure 5 HP 3PAR Recovery Manager for SQL Propertiesd. Select This account. Enter the domain administrator username and password.30 Configuring Backup

Figure 6 HP 3PAR Recovery Manager for SQL Properties Accounte. Click Apply and then select OK. You must restart the service when asked for.NOTE: These

Using Your Backup Software• The default mount point for virtual copy backups is:<system drive>:\3parSnapshot• You must manually synchronize back

NOTE: While performing concurrent backup operations:• Backup of different databases with different policies is allowed while using SymantecNetBackup.•

5 Using the Recovery Manager GUIOverview of the Recovery Manager GUIHP 3PAR Recovery Manager Software for SQL Server provides a Graphical User Interfa

Status and Summary InformationAfter launching HP 3PAR Recovery Manager for SQL, you can click the MS SQL Server node tosee a detailed status and summa

a. Select the Register checkbox for the server instance.b. Click OK.• If the list does not display the SQL server to be registered, you must manually

1. Right-click the MS SQL Server node.2. Select Rescan Server Configuration.If Availability Group databases are configured on Microsoft SQL Server 201

If you specify an expiration time for a remote virtual copy:• If Remote Copy is set up in asynchronous periodic mode, Recovery Manager sets the expira

3. To modify the default retention time for the instance and its virtual copies, enter the numberof hours or days you want to keep the instance and it

Requirements ...27Setting Up the HP D

• Sender Email Address - Email address of the sender• Password - Password for the sender’s email address• Receiver Email Address - Email address of th

If you have Remote Copy set up, you can also create a virtual copy to be saved on the RemoteCopy backup server; this type of copy is called a remote v

4. To immediately create one virtual copy, click Finish in the Create Virtual Copy dialog box. Toschedule virtual copies, see “Scheduling Automatic Vi

Displaying Remote Virtual CopiesThe Recovery Manager GUI on the backup server does not automatically display remote virtualcopies. To display a remote

displayed depends on the frequency of the automatic virtual copies selected in the left paneof the Schedule Pattern area.• Once - Schedules one automa

• Run Now - Performs the selected task immediately (in addition to its scheduled run time).• Refresh - Updates the list and status of scheduled tasks.

Unmounting a Virtual Copy1. In the node tree pane, right-click the timestamp for the virtual copy you want to unmount, andselect Unmount.2. Recovery M

2. From the Select Vendor drop-down list, select the backup software you are using:• Symantec NetBackup• HP Data Protector• Symantec Backup Exec3. In

1. In the node tree pane, right-click the instance or the database you want to back up, and selectBackup to Media.2. In the Backup to Media dialog box

Restoring Instances, Databases, and VolumesYou can use either the volume restore feature or the file copy feature of Recovery Manager torestore an ins

Removing a Virtual Copy...51Viewing Event Messag

2. Under the Virtual Copy Management node in the node tree pane, right-click the timestamp ofthe virtual copy you want to use for the restore, and sel

Restoring an Instance or a Database from BackupYou can restore backups to their original location (that is, to the instance or the database locationof

2. Select About→Event Messages.Recovery Manager uses your default browser to display the Event Messages file. The filecontains all the events for HP 3

6 Using the Recovery Manager CLIHP 3PAR Recovery Manager for Microsoft SQL Server Command LineInterface (CLI)HP 3PAR Recovery Manager Software for Mic

Recovery Manager CommandsThe following sections describe how to administer HP 3PAR Recovery Manager for SQL from theCommand Line Interface.HpRmCli Sql

HpRmCli Sql backupSYNTAXHpRmCli Sql backup -s <SQL server> [-i <SQL instance>] [-d <database>][-t <timestamp> | -r ] [-ts <

Optional: If not specified, Recovery Manager proceeds as if thebackup software used is Symantec NetBackup.-be Backup software specified is Symantec Ba

-w <waittime> Optional. Wait time in seconds. Recovery Manager uses this waittime to poll the status of the remote copy before creating a virtua

NOTE: Retention time restrictions are:• You must have a Virtual Lock license to use the -retain option.• The minimum retention period is 1 hour; the m

NOTE: HP 3PAR VSS Software waits up to 10 seconds for a virtual copy operation; and thisinterval can not be configured. In most of the cases, 10 secon

Setting Up a Remote Copy Volume Group for Instances...92Recovering an SQL Database from a Remot

HpRmCli Sql displaySYNTAXHpRmCli Sql display -s <SQL server> [-rc <target server>] [-i <SQLinstance>] [-d <database>] [-t <

HpRmCli Sql listbackupSYNTAXHpRmCli Sql listbackup -s <SQL server> [-i <SQL instance>] [-d<database>] [-t <timestamp>]DESCRIPT

HpRmCli Sql mountVerify that the following conditions are complete before performing the mount operation:• The SQL server must be in healthy state for

NOTE: When mounting in read-write mode, the system uses VDS API to make the volume readand write enabled. However, if there is another operation on th

HpRmCli Sql policySYNTAXHpRmCli Sql policy -s <SQL server> [-i <SQL instance>] [-q] [-exp<time>{h|H|d|D}] [-in <instance virtual

-retain <time>{h|H|d|D} Optional. Set or extend the retention time forthe specified virtual copy to the specified time.The virtual copy cannot b

EXAMPLEThe following command sets the maximum number of virtual copies to 5 at all times for the defaultSQL instance:HpRmCli Sql policy –n 5 -s <SQ

HpRmCli Sql removeSYNTAXHpRmCli Sql remove -s <SQL server> -t <timestamp>DESCRIPTIONThe HpRmCli Sql remove command removes a virtual copy

HpRmCli Sql repositorySYNTAXHpRmCli Sql repository [-a <alter destination>] [-r]DESCRIPTIONAfter HP 3PAR Recovery Manager for SQL is installed,

EXAMPLEThe following rescans the SQLserverA with instanceBHpRmCli Sql rescan -s SQLserverA -i instanceB.NOTE: In SQL 2012, by default, sysadmin role i

1 Overview of Recovery ManagerSystem RequirementsWindows Server RequirementsMicrosoft Windows Server 2008, Windows Server 2008 R2 or Windows Server 20

-t <timestamp> The timestamp for the virtual copy to restore.-ts <target server> Optional. (Symantec NetBackup Media Restore only) Thetarg

The following command performs a media restore of a virtual copy 020405162103 using DataProtector.HpRmCli Sql restore -s server1 -i inst -d testdb -t

HpRmCli Sql setvcSYNTAXHpRmCli Sql setvc-s <SQL server> [-i <instance>] [-d <database>] -t <timestamp> -exp<time>{h|H|d|

NOTE: Retention time restrictions are:• You must have a Virtual Lock license to use the -retain option.• The minimum retention period is 1 hour; the m

HpRmCli Sql timeconfigSYNTAXHpRmCli Sql timeconfig [-s <WindowsHost>] [-prt <promotetime>][-bkt<backuptime>] [-ai <analyzeinterva

HpRmCli Sql unmountVerify that the following tasks are complete before performing the unmount operation:• The SQL server must be in healthy state for

10. In the New Action dialog box, click Browse.11. Navigate to the Recovery Manager install location. The default location is:C:\Program Files\3PAR\RM

7 Recovery for Microsoft SQL ServerMicrosoft SQL Server Recovery ModelsMicrosoft SQL Server offers three disaster-recovery models:• Simple Recovery Mo

To perform a point-in-time recovery, use Recovery Manager to perform a file copy restore or avolume restore. The restore steps depend on whether SQL s

Determining Whether You Can Perform a Point-of-Failure RecoveryIn point-of-failure recovery, a database is completely recovered up to the point of the

NOTE: If any of the components mentioned in the additional system requirements are not installed,HP 3PAR Recovery Manager might not function properly.

3. To apply the transaction logs as well as to recover the database to the point in time desired,enter the following restore commands at the command p

Performing a File Copy RestoreIf you are performing a Point of Failure file copy restore, be sure to complete the followingprerequisite tasks before i

3. From an Instance level, select the applicable Database Names.Figure 9 Restore Using File Copy at an Instance LevelFrom a Database level, select a r

NOTE: SQL services remains active during a Point of Failure restoration operation.NOTE: When multiple database restore option is selected, SQL service

secondary databases will be in restoring state. All secondary databases must be restored manuallyafter the restore operation is completed on primary n

8 Coexistence of HP 3PAR Recovery Manager for SQL andHP 3PAR Recovery Manager for ExchangePrerequisites• Only backup server component of HP 3PAR Recov

9 Using HP 3PAR Peer Motion Manager Software withRecovery ManagerHP 3PAR Peer Motion Manager is a feature of the HP 3PAR Software and manages the migr

10 Using HP 3PAR CLX with Recovery ManagerSQL Server Failover Clustering is a shared storage failover cluster solution which consists of twoor more no

NOTE: Ensure that only one array is configured on each backup server.• The Create Remote virtual copy operation should use “Remote Virtual Copy” optio

11 Remote Copy for Recovery ManagerOverviewHP 3PAR Remote Copy Software helps you to safeguard against disasters that might occur at onelocation, by a

• Recovery Manager for SQL supports English, Japanese, and Chinese version of Microsoft SQLServerFor more information on localization support, see Sin

Figure 13 Remote copy configurationSetting Up Remote Copy1. Install and configure Remote Copy. For more information, see the HP 3PAR Remote CopySoftwa

Support for Remote Copy Modes and PoliciesRecovery Manager supports Remote Copy in synchronous and asynchronous periodic mode.• If you are using synch

3. Add the virtual volumes belonging to the database and log files to the primary Remote Copyvolume group, and add the associated secondary virtual vo

12 Support and Other ResourcesRelated DocumentsRead the…For Information About…HP 3PAR Command Line Interface Administrator’s ManualUsing the HP 3PAR O

AdvisoriesTo avoid losing or damaging data, be sure to observe the cautions and warnings in this document.WARNING! Warnings alert you to actions that

13 Documentation feedbackHP is committed to providing documentation that meets your needs. To help us improve thedocumentation, send any errors, sugge

A Server Virtualization EnvironmentsVMware and Microsoft Hyper-V EnvironmentsVMware and Microsoft Hyper-V environments are supported under specific co

B TroubleshootingKnown Issues• When HP 3PAR CLI is not installed using HP 3PAR Recovery Manager Software for SQL setup:◦ If the certificate is not sav

Validation might fail without proper notification. Restart the HpRmCli Sql agent service on thebackup and production servers.Problem:A restore of a ba

5. Select the COM Security tab.6. Under Access Permissions, click Edit Default.7. Add a Cluster Service account and select Local Access and Remote Acc