HP StorageWorks P9000 Replication Manager Software 7.1.1 CLI User Guide (TB584-96032, September 2011)

Before using the log-shipping function ................................................................................. 340
Setting a distribution target server as an operating server ...................................................... 344
Backing up and restoring in a cascade configuration or multi-target configuration ........................... 346
Preparations for performing backup or restoration in a cascade configuration or multi-target
configuration ................................................................................................................... 347
Creating a user script to perform a backup in a cascade configuration .................................... 351
Outline of user script files ............................................................................................ 351
Coding rules for user script files ................................................................................... 352
Sample user script files ............................................................................................... 352
Backing up an SQL Server database in a cascade configuration ............................................ 361
Backing up transaction logs in a cascade configuration without a backup catalog .................... 365
Restoring an SQL Server database in a cascade configuration ............................................... 365
Backing up and restoring using a tape backup management software that cannot link with Application
Agent .................................................................................................................................... 370
Backing up and restoring an SQL Server database by using a file share ........................................ 371
Preparing to back up or restore by using a file share ............................................................. 372
Backing up an SQL Server database by using a file share ..................................................... 373
Example of restoring a database by using a file share ........................................................... 373
Restoring data to an SQL Server instance that is different from the backup source ............................ 374
System configuration ......................................................................................................... 374
Operation flow ................................................................................................................ 375
Preparations for restoration (recovery) ........................................................................... 375
Operations for restoration (recovery) ............................................................................ 376
Operation example .......................................................................................................... 376
Example of restoring an SQL Server database from tape and recovering on the secondary
volume ..................................................................................................................... 376
Example of restoring (recovering) an SQL Server database on the log distribution
destination ................................................................................................................ 377
Example of restoring (recovering) an SQL Server database on the primary volume ............. 377
Deleting backup data .............................................................................................................. 377
Making an SQL Server database backed up to a secondary volume available for use ..................... 378
System configuration ......................................................................................................... 378
User script example .......................................................................................................... 380
script1.txt (used for data mining) .................................................................................. 380
script2.txt (used for backup) ........................................................................................ 381
Example ......................................................................................................................... 382
Backing up and restoring when using an SQL Server replication configuration ................................ 382
System configuration ......................................................................................................... 382
Requirements for the publication database and the distribution database .......................... 383
Requirements for the subscription database ................................................................... 384
Example ......................................................................................................................... 384
Back up the databases ............................................................................................... 384
Back up the transaction logs of the publication database ................................................ 385
Prepare for database restoration .................................................................................. 385
Restore the databases ................................................................................................. 386
Perform database recovery .......................................................................................... 387
Prepare to restart operations ....................................................................................... 387
Setting and checking the 'sync with backup' option .............................................................. 387
How to set the 'sync with backup' option ...................................................................... 387
How to check the 'sync with backup' option .................................................................. 388
7 Operation for Exchange databases .................................................. 389
Backing up and restoring a storage group ................................................................................. 389
Precautions when backing up an Exchange database ........................................................... 389
10