Hp 3PAR Application Software Suite for Microsoft SQL Manuale Utente Pagina 1

HP 3PAR Recovery Manager 4.2.0 Softwarefor Microsoft SQL ServerUser’s GuideAbstractThis guide is designed for System Administrators and Microsoft SQL

NOTE: The Japanese OS does not support scheduling virtual copies using Task Scheduler. (Inother words, the functionality described in “Automating Task

NOTE: Due to an SQL instance limitation, the recommended maximum number of databases forwhich you can create snapshot backups at the same time is 35.F

The HP 3PAR VSS Provider Software coordinates between Requestors (backup applications suchas Recovery Manager), Writers (applications in windows servi

2. Volume Shadow Copy service communicates with SQL Writer on the Microsoft SQL Server toflush the current log files to disk and suspend any writes to

HP 3PAR Recovery Manager Software for SQL provides off-host backup and mounting capabilities.These features reduce the impact on the production server

3 Installation and DeinstallationUpgrading to Recovery Manager 4.2.0 for SQLYou can upgrade to HP 3PAR Recovery Manager 4.2.0 Software for Microsoft S

Installing Recovery ManagerTo install HP 3PAR Recovery Manager Software on Windows:CAUTION: Do not install Recovery Manager on a clustered drive. If y

13. If you are using a remote desktop session to install Recovery Manager, log off all connectedremote sessions after the installation is complete. Th

NOTE: The DataFilePath field is created in the registry database only after you launch theRecovery Manager GUI for the first time.Deinstalling Recover

4 Configuring Recovery ManagerConfiguring the SQL DatabaseWhen you configure the SQL database:• Be sure to use database files and transaction logs cre

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

NOTE: The TCP/IP port used by Recovery Manager for SQL must be the same on all servers.Changing a Production Server Port from the Backup Server1. On t

HP 3PAR Storage System domain set. This configuration allows you to use just one RecoveryManager backup server to manage all your database servers.• A

Server name: Enter the server and instance name as follows:• For the default instance, enter the name of your SQL server. For example:Server name: Bot

NOTE: The HP 3PAR Storage System source volumes used by Recovery Manager must be basevolumes. Recovery Manager cannot use physical copies or virtual c

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

NOTE: If the backup server is running the NetBackup client interface, NetBackup cannot validatethe policy.NOTE: If you add the NetBackup path to the s

For more information on installing HP Data Protector, see HP Data Protector documentation.Using Your Backup Software• The default mount point for virt

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

1. Right-click the MS SQL Server node and select Register Server.NOTE: If your backup server and SQL production servers reside on different networks,

Unregistering a SQL Server InstanceTo remove a server instance from the list of registered servers:1. Right-click the MS SQL Server node.2. Select Reg

Contents1 Introduction...6Related Documents...

Retention Time RestrictionsIf you have a Virtual Lock license, you can set a retention time for virtual copies. The instance ordatabase and the associ

4. Click Finish.The virtual copy policy is effective immediately for all future virtual copies.NOTE: You can also use the Recovery Manager CLI command

5. In the Operations pane, check the desired checkboxes in the tab for each type of task (CreateVirtual Copy, Backup, and/or Restore) for which you wa

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

• 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

NOTE: Recovery Manager does not support mounting a virtual copy to a drive letter.4. Click OK.Recovery Manager:• Adds the mounted virtual copy to the

2. From the Select Vendor drop-down list, select the backup software you are using:• Symantec NetBackup• HP Data Protector3. In the Parameters area, e

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

5 Configuring Backup Software...24Overview...

you enter an alternate location, you must enter an alternate name in the Database Nametext box.If you leave this text box blank, the clone database is

3. Click Yes.Depending on whether you are both analyzing and synchronizing the repository or justanalyzing the repository, Recovery Manager does the f

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

RMSql analyzeSYNTAXRMSql analyze -s <SQL server> [-sync] [-f]DESCRIPTIONThe RMSql analyze command validates all virtual copy records by matching

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

RMSql createSYNTAXRMSql create -s <SQL server> [-rc <target server> [-w <waittime>]][-i<SQL instance>] [-d <database>] [

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: Use quotes ("") when an option value includes spaces.NOTE: HP 3PAR VSS Software waits up to 10 seconds for a virtual copy operation; t

RMSql deletebackupSYNTAXRMSql deletebackup -s <SQL server> [-i <SQL instance>] [-d <database>]-t <timestamp>DESCRIPTIONThe RMS

Viewing Event Message Descriptions...417 Using the Recovery Mana

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 mountSYNTAXRMSql mount -s <SQL server> -t <timestamp> [-m <mount point>] [-ts <hostname>]DESCRIPTIONThe RMSql mount comm

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

NOTE: By default, the Recovery Manager for SQL policy is set to a maximum of 10 virtual copieseach for the instance level and the database level. In a

RMSql portconfigSYNTAXRMSql portconfig [-n <number>] [-s <WindowsHost>]DESCRIPTIONAfter Recovery Manager for SQL is installed, by default

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

RMSql reportSYNTAXRMSql report -s <WindowsHost> -output <OutputDirectory>DESCRIPTIONThe RMSql report command collects the environmental in

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

1 IntroductionRelated DocumentsRead the…For Information About…HP 3PAR InForm OS CLI Administrator’s ManualUsing the HP 3PAR InForm OS Command Line Int

RMSql restoreSYNTAXRMSql restore -s <SQL server> [-i <instance>] [-d <database>]-t<timestamp> [-ts <target server>] [-M

-snap Optional. (Volume Restore only) Promotes the virtual copyback to the base volume for a faster restore. You can onlypromote a base volume that is

NOTE: Use quotes ("") when an option value includes spaces.62 Using the Recovery Manager CLI

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 unmountSYNTAXRMSql unmount -s <SQL server> -t <timestamp>DESCRIPTIONThe RMSql unmount command unmounts a currently mounted virtual c

For example:“C:\Program Files\3par\RM\SQL\RMSql.exe” create –i inst01–d test -sSQLserver15. On the Schedule tab, further refine the scheduled task by

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

1. Schedule downtime before performing the restore.2. If you are performing a restore on a standalone SQL production server in a non-clusteredenvironm

NOTE: The InServ Storage Server has been rebranded as HP 3PAR Storage System. There areinstances in this document where screenshots and/or menu items

NOTE: Point-of-failure recovery only supports a file copy restore at the database level.Determining Whether You Can Perform a Point-of-Failure Recover

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

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

NOTE: For the Recovery Manager GUI to manage virtual copies on the Remote Copy backupserver, you must configure Recovery Manager with the precise serv

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

Setting Up a Remote Copy Volume Group for Instances1. Identify the virtual volumes that contain all database(s) and log files to be copied.2. Create o

A Server Virtualization EnvironmentsVMWare and EgeneraVMWare and Egenera environments are supported under specific conditions. For VMWare andEgenera s

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

2 Overview of Recovery ManagerSystem RequirementsWindows Server RequirementsMicrosoft Windows Server 2003 with SP2 or above, Windows Server 2008, or W

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

• Virtual copy (snapshot) space must be available on virtual volumes where the SQL Serverdatabase resides.• To create virtual copies on the base volum