HP XP P9000 Replication Manager Software 7.6.1-00 Application Agent CLI User Guide

Preparations for performing backup or restoration in a cascade configuration or multi-target
configuration ................................................................................................................... 355
Creating a user script to perform a backup in a cascade configuration .................................... 359
Outline of user script files ............................................................................................ 359
Coding rules for user script files ................................................................................... 360
Sample user script files ............................................................................................... 360
Backing up an SQL Server database in a cascade configuration ............................................ 369
Backing up transaction logs in a cascade configuration without a backup catalog .................... 373
Restoring an SQL Server database in a cascade configuration ............................................... 373
Backing up and restoring using a tape backup management software that cannot link with Application
Agent .................................................................................................................................... 378
Backing up and restoring an SQL Server database by using a file share ........................................ 379
Preparing to back up or restore by using a file share ............................................................. 380
Backing up an SQL Server database by using a file share ..................................................... 381
Example of restoring a database by using a file share ........................................................... 381
Restoring data to an SQL Server instance that is different from the backup source ............................ 382
System configuration ......................................................................................................... 382
Operation flow ................................................................................................................ 383
Preparations for restoration (recovery) ........................................................................... 383
Operations for restoration (recovery) ............................................................................ 384
Operation example .......................................................................................................... 384
Example of restoring an SQL Server database from tape and recovering on the secondary
volume ..................................................................................................................... 384
Example of restoring (recovering) an SQL Server database on the log distribution
destination ................................................................................................................ 385
Example of restoring (recovering) an SQL Server database on the primary volume ............. 385
Deleting backup data .............................................................................................................. 385
Making an SQL Server database backed up to a secondary volume available for use ..................... 386
System configuration ......................................................................................................... 386
User script example .......................................................................................................... 388
script1.txt (used for data mining) .................................................................................. 388
script2.txt (used for backup) ........................................................................................ 389
Example ......................................................................................................................... 390
Backing up and restoring when using an SQL Server replication configuration ................................ 390
System configuration ......................................................................................................... 390
Requirements for the publication database and the distribution database .......................... 391
Requirements for the subscription database ................................................................... 392
Example ......................................................................................................................... 392
Back up the databases ............................................................................................... 392
Back up the transaction logs of the publication database ................................................ 393
Prepare for database restoration .................................................................................. 393
Restore the databases ................................................................................................. 394
Perform database recovery .......................................................................................... 395
Prepare to restart operations ....................................................................................... 395
Setting and checking the 'sync with backup' option .............................................................. 395
How to set the 'sync with backup' option ...................................................................... 396
How to check the 'sync with backup' option .................................................................. 396
Backing up and restoring in an SQL Server AlwaysOn availability group configuration .................... 396
System configuration ......................................................................................................... 396
Backing up and restoring a user database to the active server ................................................ 397
Restoring a user database to the standby server from the active server ..................................... 398
Restoring a user database to the secondary-use server from the active server ............................ 400
7 Operation for Exchange databases .................................................. 403
10