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

HP 3PAR Recovery Manager 4.3.0 Softwarefor Microsoft SQL ServerUser GuideAbstractThis document is designed for System Administrators and Microsoft SQL

How HP 3PAR VSS Software Works with Microsoft SQL ServerFigure 1 HP 3PAR VSS Provider Software for Microsoft Windows Operation Overview1. The requesto

Recovery Manager LayoutHP 3PAR Recovery Manager Software for SQL provides off-host backup and mounting capabilities.These features reduce the impact o

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

that step in the process. There are two options for using the installation wizard to load theprerequisite components:• You can perform the installatio

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

Upgrading the Production Server1. Uninstall HP 3PAR Recovery Manager for SQL. For more information, see “Uninstalling HPRecovery Manager for SQL” (pag

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

Procedure 11. Select an available port. The valid TCP/IP port range is 1024 to 65535.2. To set your desired port number, run the Recovery Manager CLI

Procedure 41. On the backup server:• In Windows 2008, click Start→Control Panel→User Accounts and click Manage yournetwork passwords.In the Stored Use

Procedure 51. Ensure you are running HP 3PAR InForm Operating System Software 2.3.1 or higher.2. Ensure you have access to all domains.3. Create a dom

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

Procedure 61. Log onto the backup server as the system administrator.2. Launch SQL Server Management Studio.3. In the Connect to Server window, enter

2. After you have fixed the SQL configuration on the production server, log onto the backupserver and run the SQL connectivity test again.:Your backup

4 Configuring Backup SoftwareOverviewHP 3PAR Recovery Manager Software for Microsoft SQL Server can be used with either SymantecNetBackup or HP Data P

Configuring HP Data ProtectorRequirements• HP Data Protector Software 6.2• Data Protector patch for omnidl (# DPWIN_00514)• Each data list name (also

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

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

Table management feature like Sorting will be available for each column in the tables.• Columns having timestamp values in date/time format (MM/dd/yy

2. Depending on whether the Recovery Manager for SQL Server Register window displays theSQL server you want to register, do the following:• If the lis

Updating Registration after Server ModificationIf you modify a registered instance's configuration (e.g., you create a new database under thatins

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

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

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

• Password - Password for the sender’s email address• Receiver Email Address - Email address of the person to be notified of task activity and/orerror

2. Optional: To adjust policy values for this virtual copy (or, if you are scheduling automaticcopies, this group of virtual copies):• To adjust the e

1. In the node tree pane, right-click the instance or database for which you want to create avirtual copy, and select one of the following:• Create Vi

8. From the Start Time drop-down list, select the hour at which you want Recovery Manager tostart creating automatic virtual copies.9. To specify the

3. To manage a scheduled task, select it and click one of the following buttons:• Edit - Opens the Task Scheduler, with which you can modify the task.

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

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

Creating a Backup of a Virtual CopyWhen you create a backup of one virtual copy, Recovery Manager copies the existing virtual copy,and the backup soft

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

Using Symantec NetBackup...24Using HP Data Protector...

c. If you want to restore the clone database to a location other than its parent location, enterthe directory path to the alternate database In the Al

Analyzing and Synchronizing the RepositoryYou can use Recovery Manager to compare and synchronize virtual copies in the Recovery Managerrepository wit

6 Using the Recovery Manager CLIRecovery Manager for SQL Server Command Line Interface (CLI)HP 3PAR Recovery Manager Software for Microsoft SQL Server

Recovery Manager CommandsThe following sections describe how to administer Recovery Manager for SQL from the CommandLine Interface.RMSql analyzeSYNTAX

RMSql backupSYNTAXRMSql backup -s <SQL server> [-i <SQL instance>] [-d <database>] [-t<timestamp> | -r ] [-ts <target serve

EXAMPLEThe following command performs a backup of virtual copy 020405162103 with the necessarySymantec NetBackup parameters.RMSql backup -s inst1 -d t

-exp <time>{h|H|d|D} Optional. Set the expiration time for this virtual copy to the specifiedtime and time unit. Valid values are:• To set the e

NOTE: HP 3PAR VSS Software waits up to 10 seconds for a virtual copy operation; this intervalis not configurable. In most cases, 10 seconds is a suffi

RMSql displaySYNTAXRMSql display -s <SQL server> [-rc <target server>] [-i <SQL instance>][-d <database>] [-t <timestamp>

RMSql listbackupSYNTAXRMSql listbackup -s <SQL server> [-i <SQL instance>] [-d <database>][-t <timestamp>]DESCRIPTIONThe RMSql

RMSql create...45RMSql deletebackup.

RMSql mountBefore you begin, verify the following conditions are complete before performing the mountoperation:• The SQL server must be in healthy sta

NOTE: When mounting in read-write mode, the system uses VDS API to make the volumeread-writeable. However if there is another operation on the disk an

RMSql policySYNTAXRMSql policy -s <SQL server> [-i <SQL instance>] [-q] [-exp<time>{h|H|d|D}] [-in <instance virtual copy limit&g

-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:RMSql policy –n 5 -s <SQL serv

RMSql removeSYNTAXRMSql remove -s <SQL server> -t <timestamp>DESCRIPTIONThe RMSql remove command removes a virtual copy from the system an

RMSql repositorySYNTAXRMSql repository [-a <alter location>] [-r]DESCRIPTIONAfter Recovery Manager for SQL is installed, by default the reposito

EXAMPLEThe following registers the SQLserverA with instanceB RMSql rescan -s SQLserverA -iinstanceB.RMSql restoreSYNTAXRMSql restore -s <SQL server

-M <masterServer> Optional. (Media Restore only) The Symantec NetBackupmaster server name. Valid only if the backup software inuse is Symantec N

RMSql restore -s server1 -i inst -d testdb -t 020405162103 -M server1-a J:\TestThe following command performs a restore to a point-of-failure of virtu

1 Overview of Recovery ManagerSystem RequirementsWindows Server RequirementsMicrosoft Windows Server 2008, or Windows Server 2008 R2Windows Server 200

RMSql setvcSYNTAXRMSql setvc-s <SQL server> [-i <instance>] [-d <database>] -t <timestamp> -exp<time>{h|H|d|D} [-retain

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

RMSql timeconfigSYNTAXRMSql timeconfig [-s <WindowsHost>] [-prt <promotetime>][-bkt<backuptime>] [-ai <analyzeinterval>]DESCRI

RMSql unmountBefore you begin, verify the following tasks are complete before performing the unmount operation:• The SQL server must be in healthy sta

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 your

Determining Whether You Can Perform a Point-of-Failure RecoveryYou can perform a point-of-failure recovery, in which a database is completely recovere

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

• Adding the database online to perform a file copy restore at the database level. To restore aSQL database that is detached, you can either mount a p

3. From an Instance level, select the applicable Database Name(s).Figure 3 Restore Using File Copy at an Instance LevelFrom a Database level, select a

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

8 Using HP 3PAR Peer Motion Manager Software withRecovery ManagerHP 3PAR Peer Motion Manager is a feature of the HP 3PAR InForm Software and manages t

9 Remote Copy for Recovery ManagerOverviewHP 3PAR Remote Copy Software helps you safeguard against disasters that might occur at onelocation by allowi

Setting Up Remote Copy1. Install and configure Remote Copy. For more information, see the HP 3PAR Remote CopySoftware User’s Guide.NOTE: Be sure to co

Support for GeoCluster for Microsoft WindowsRecovery Manager for SQL supports the use of both Remote Copy and HP 3PAR GeoClusterSoftware for Microsoft

Recovering a SQL Database from a Remote Copy Backup ServerIf a SQL database crashes at the site that holds the primary servers, you can recover the da

10 Support and Other ResourcesRelated DocumentsRead the…For Information About…HP 3PAR InForm OS CLI Administrator’s ManualUsing the HP 3PAR InForm OS

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

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

• Attach or detach a database to any SQL server during mounting or unmounting operations• Restore from virtual copies• Backups using HP Data Protector

B TroubleshootingThis appendix is designed to be used like a Frequently Asked Questions section. It will help youfind solutions to some of the common

If you install Recovery Manager via a remote desktop session, the newly added environmentvariables do not go into effect until you log out of the sess

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

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

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

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

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

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

• Customizing date format. Recovery Manager supports date format in month/day/year• Windows auto-mount featureMicrosoft Volume Shadow Copy ServiceMicr