HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 353)

• The primary volume at the local site and the primary volume at the remote site must be defined as
a pair in Continuous Access Software. The primary and secondary volumes at each site must be
defined as a pair in Business Copy.
• The same RAID Manager instance number is defined at both the local and remote sites.
• The SQL Server data files and transaction log files must have the same directory structure at both
the local and remote sites.
• The SQL Server database for which backup operations are to be performed and the database ID
must have the same name at both the local and remote sites.
• Both the SQL Server database data files and the VDI metafile storage directory must be stored in
the same volume.
• The Continuous Access Software pair status must be
PAIR
when the target volume contains any
SQL server data file, transaction log file, and transaction log backup file.
• When the cluster configuration is used at a remote site or local site, the Continuous Access Software
pair volume must not contain a quorum disk.
• The SQL Server service at the remote site must be stopped in advance when the Continuous Access
Software pair contains data files or transaction log files for the system databases (master, model,
and msdb).
• The disk at the remote site must be unmounted in advance when the status of the Continuous Access
Software pair disk is
PAIR .
Preparations for performing backup or restoration in a cascade configuration
or multi-target configuration
To perform backup or restoration in a cascade or multi-target configuration, the following preparation
is required.
To prepare for backup or restore operations in a cascade or multi-target configuration:
1. Confirm that the pair status of the Continuous Access Software pair volume is SMPL or PSUS .
To confirm the pair status of the Continuous Access Software pair volume, execute the RAID
Manager
pairdisplay command at the local site.
PROMPT> pairdisplay -g TC01 -CLI
2. Check the database ID of the database for which backup operations are to be performed.
Check the database ID at the local site:
PROMPT> osql -E
1> SELECT DB_ID("UserDB1")
2> go
3. Stop the SQL Server service and unmount the Continuous Access Software pair volume.
Perform operations in step 3 at the local site.
Application Agent CLI User Guide 353