HP XP Command View Advanced Edition Software - Manual (Page 384)

Additionally, execute the drmsqlinit command on database server 2 to create a database
configuration definition file. In this case, do not specify the VDI metafile storage directory.
Operations for restoration (recovery)
To check the backup ID of the backup data before performing restoration, specify the name of the
backed up SQL Server instance name
isntA
as an argument of the
drmsqlcat
command.
At the time of restoration, the database is restored to SQL Server instance instB on database server
2. Specify the following options for the drmsqlrestore command.
•
-instance
Since you want the database to be restored to an SQL Server instance other than the backup
source, specify the restoration destination instance name (in this case,
instB ) using the -instance
option.
• -no_resync
If the volume does not need to be resynchronized, specify the -no_resync option.
• -nochk_host
When restoring data to a server other than the backup source, specify the -nochk_host option,
which specifies not to perform a host name integrity check for the backup catalog.
At the time of recovery, SQL Server instance instB is recovered on database server 2. Specify instB
as an argument of the drmsqlrecover command or drmsqlrecovertool command.
Operation example
Examples of operations for performing restoration (recovery) under the following three conditions are
described below.
• Example of restoring an SQL Server database from tape and recovering on the secondary volume:
This example is applicable to the operations described in “
Backing up and restoring between
local sites and remote sites ” on page 329.
• Example of restoring (recovering) an SQL Server database on the log distribution destination:
This example is applicable to the operations described in “
Using the SQL Server log-shipping
function ” on page 348.
• Example of restoring (recovering) an SQL Server database on the primary volume:
This example is applicable to the operations described in “
Performing restoration and recovery
on a host other than the backup host ” on page 343 and “ Backing up and restoring in a cascade
configuration or multi-target configuration ” on page 354.
Each operation example assumes that the SQL Server instance for backup is instA and the SQL
Server instance for restoration (recovery) is instB .
This section describes how to specify the commands and options used for each operation. For details
on the examples and procedures for executing these commands, see the HP P9000 Replication
Manager Software Application Agent CLI Reference Guide.
Example of restoring an SQL Server database from tape and recovering on the secondary
volume
An example of restoring an SQL Server database from tape and recovering on the secondary volume
is described below.
Operation for SQL Server databases 384