Hp 3PAR Recovery Manager Software Instrukcja Użytkownika

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

• Support for HP 3PAR Cluster Extension (CLX) configuration• Support for coexistence with HP 3PAR Recovery Manager for Exchange software• Support for

When you create a virtual copy on a SAN boot disk, the virtual copy creation fails with error“Error-VSS_E_HOLD_WRITES_TIMEOUT.” The in-box system writ

1. Create an altnames directory on the NetBackup master server in the directory containing thebackup policy for other clients:Install_path\NetBackup\d

To find out the application name for the process id which is using the port:◦ Run tasklist | find "<port number>"Example:c:\ >taskl

to the same host again through HP 3PAR Management Console (MC) using a LUN ID differentfrom the original LUN ID.Problem:After Repository location chan

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

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

• Performing a restore on a Windows Fibre channel based host that resides in virtual environment• Performing a mount, an unmount, or a restore functio

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

• HP Data Protector for Microsoft Windows• Symantec Backup Exec for Microsoft WindowsWriter:• Microsoft SQL Server 2005, 2008, 2008 R2, and 2012 with

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

NOTE: When upgrading to Recovery Manager 4.5.0 from any of its earlier versions, SQL Server2012 availability database properties are not updated. It r

• Ensure that no other user is logged on to the system and managing the HP 3PAR RecoveryManager for Microsoft SQL application.• Uninstall HP 3PAR VSS

EXAMPLES• The following command merges duplicate database names in SQL repository for all the knownSQL servers which the backup server was managing.Hp

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

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

7. Click Manual add...8. Select Windows filesystem and click Next.9. Enter the appropriate client system, mount point, and description. HP recommends:

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

5. Register the SQL server again with HP 3PAR Recovery Manager Software for SQL.To register an SQL instance:1. Right-click the MS SQL Server node and

For example: Aztec\Bld2.◦ Multiple server names can be added simultaneously by separating server nameor instance name with a comma (,).NOTE: Do not us

4. Click OK.Setting the Recovery Manager PolicyRecovery Manager applies policy settings at the instance level; therefore, each instance can haveits ow

When setting a retention time:• You must have a Virtual Lock license to set retention times.• The minimum retention time is 1 hour; the maximum is 43,

Requirements ...27Setting Up the HP D

1. In the node tree pane, right-click the virtual copy you want to modify, and select Edit TimeConstraints.2. To set a new retention time, select the

Both informational and error emails contain the result of the operation and the related CLIoutput.6. Click Finish.Recovery Manager encrypts the passwo

Figure 7 Database Sources3. Optional: To adjust policy values for this virtual copy (or, if you are scheduling automaticcopies, this group of virtual

Creating Remote Virtual CopiesHow Remote Virtual Copy WorksWhen you create remote virtual copies, Recovery Manager uses HP 3PAR Remote Copy Softwareto

Automating TasksYou can use the Task Scheduler to schedule Recovery Manager to automatically create virtualcopies, remote virtual copies, and one-clic

• Weekly - Schedules automated virtual copies by the day of the week.In the right pane, enter the number of weeks you want to pass between automated c

Mounting a Virtual CopyYou can use Recovery Manager to mount a virtual copy at the instance or the Database level.1. In the node tree pane, right-clic

You can create a backup of an instance or a database on the instance or the database level orat the timestamp level.• When you create a backup on eith

3. In the Parameters area, enter the required information, depending on your backup software:Enter these parameters:If you are using:SymantecNetBackup

4. In the Task Scheduler, schedule backups as desired. For more information, see “SchedulingAutomated Tasks with Task Scheduler” (page 44).Creating a

Removing a Virtual Copy...52Viewing Event Messag

NOTE: If the servers are configured in a shared volume environment such as a Microsoft clusterenvironment, see the following sections for more informa

By default, Recovery Manager restores the virtual copy to its parent instance or database(specified in the Target Server field).3. To restore a virtua

1. Under the Backup Management node in the node tree pane, right-click the timestamp for thebackup you want to use for the restore, and select Restore

Viewing Online HelpTo view online help for Recovery Manager for Microsoft SQL Server, select Help→Help.Online Help for HP 3PAR Recovery Manager for Mi

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 <

-be Backup software specified is Symantec Backup Exec.Optional: If not specified, HP 3PAR Recovery Manager for SQLproceeds as if the backup software u

copy at the secondary site. If not specified, the wait time is 120seconds by default.-rc <target server> Remote Copy target server. To use this

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

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

NOTE: The snapshot volume set is limited to up to 64 volumes. In other words, each database(under database-level operation) or each instance (under in

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,

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

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

-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

Recovering from Logical Errors with Point-in-Time RecoveryPoint-in-time recovery is useful for recovering from logical errors. For example, if you acc

NOTE: For platform-specific information and release levels, refer to “Related Documents” (page94).NOTE: If any of the components mentioned in the addi

Recovering All Data with Point-of-Failure RecoveryPoint-of-failure recovery is useful if you cannot afford to lose any data in the event of a systemfa

HpRmCli.exe Sql restore -s SQLserver01 -i SQLInstan01 -d northwind-t 010106000000 -norecovery3. To apply the transaction logs as well as to recover th

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

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

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

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 mode and asynchronous periodic mode.• If you are using

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 saved

• When restore operation is performed using HP Data Protector or Symantec BackupExec,snapshot files are restored to <Alternate_Location>/<Mou