HP StorageWorks P9000 Replication Manager Software 7.1 CLI User Guide (TB584-96026, May 2011)

Operation at the remote site ........................................................................................ 332
Recovering data from the remote site to the local site ............................................................ 333
Operation at the local site .......................................................................................... 333
Operation at the remote site ........................................................................................ 333
Operation at the local site .......................................................................................... 334
Backing up and restoring in a multi-target configuration ............................................................... 334
Example of backing up an SQL Server database .................................................................. 337
Example of restoring an SQL Server database ...................................................................... 338
Performing restoration and recovery on a host other than the backup host ...................................... 340
Using the SQL Server log-shipping function ................................................................................ 345
Before using the log-shipping function ................................................................................. 345
Setting a distribution target server as an operating server ...................................................... 349
Backing up and restoring in a cascade configuration or multi-target configuration ........................... 351
Preparations for performing backup or restoration in a cascade configuration or multi-target
configuration ................................................................................................................... 352
Creating a User Script to Perform a Backup in a Cascade Configuration .................................. 356
Outline of user script files ............................................................................................ 356
Coding rules for user script files ................................................................................... 357
Sample user script files ............................................................................................... 357
Backing up an SQL Server database in a cascade configuration ............................................ 366
Backing up transaction logs in a cascade configuration without a backup catalog .................... 370
Restoring an SQL Server database in a cascade configuration ............................................... 370
Backing up and restoring using a backup management product that cannot link with Application
Agent .................................................................................................................................... 375
Backing up and restoring an SQL Server database by using a file share ........................................ 376
Preparing to Back Up or Restore by Using a File Share .......................................................... 377
Backing up an SQL Server database by using a file share ..................................................... 378
Example of Restoring a Database by Using a File Share ........................................................ 378
Restoring data to an SQL Server instance that is different from the backup source ............................ 379
System configuration ......................................................................................................... 379
Operation flow ................................................................................................................ 380
Preparations for restoration (recovery) ........................................................................... 380
Operations for restoration (recovery) ............................................................................ 381
Operation example .......................................................................................................... 381
Example of restoring an SQL Server database from tape and recovering on the secondary
volume ..................................................................................................................... 381
Example of restoring (recovering) an SQL Server database on the log distribution
destination ................................................................................................................ 382
Example of restoring (recovering) an SQL Server database on the primary volume ............. 382
Deleting backup data .............................................................................................................. 382
Making an SQL Server database backed up to a secondary volume available for use ..................... 383
System configuration ......................................................................................................... 383
User script example .......................................................................................................... 385
script1.txt (used for data mining) .................................................................................. 385
script2.txt (used for backup) ........................................................................................ 386
Example ......................................................................................................................... 387
Backing up and restoring when using an SQL Server replication configuration ................................ 387
System configuration ......................................................................................................... 387
Requirements for the publication database and the distribution database .......................... 388
Requirements for the subscription database ................................................................... 389
Example ......................................................................................................................... 389
Back up the databases ............................................................................................... 389
Back up the transaction logs of the publication database ................................................ 390
Prepare for database restoration .................................................................................. 390
Restore the databases ................................................................................................. 391
10