HP P9000 Replication Manager Software 7.3.1-00 CLI User Guide

Outline of user script files ............................................................................................ 353
Coding rules for user script files ................................................................................... 354
Sample user script files ............................................................................................... 354
Backing up an SQL Server database in a cascade configuration ............................................ 363
Backing up transaction logs in a cascade configuration without a backup catalog .................... 367
Restoring an SQL Server database in a cascade configuration ............................................... 367
Backing up and restoring using a tape backup management software that cannot link with Application
Agent .................................................................................................................................... 372
Backing up and restoring an SQL Server database by using a file share ........................................ 373
Preparing to back up or restore by using a file share ............................................................. 374
Backing up an SQL Server database by using a file share ..................................................... 375
Example of restoring a database by using a file share ........................................................... 375
Restoring data to an SQL Server instance that is different from the backup source ............................ 376
System configuration ......................................................................................................... 376
Operation flow ................................................................................................................ 377
Preparations for restoration (recovery) ........................................................................... 377
Operations for restoration (recovery) ............................................................................ 378
Operation example .......................................................................................................... 378
Example of restoring an SQL Server database from tape and recovering on the secondary
volume ..................................................................................................................... 378
Example of restoring (recovering) an SQL Server database on the log distribution
destination ................................................................................................................ 379
Example of restoring (recovering) an SQL Server database on the primary volume ............. 379
Deleting backup data .............................................................................................................. 379
Making an SQL Server database backed up to a secondary volume available for use ..................... 380
System configuration ......................................................................................................... 380
User script example .......................................................................................................... 382
script1.txt (used for data mining) .................................................................................. 382
script2.txt (used for backup) ........................................................................................ 383
Example ......................................................................................................................... 384
Backing up and restoring when using an SQL Server replication configuration ................................ 384
System configuration ......................................................................................................... 384
Requirements for the publication database and the distribution database .......................... 385
Requirements for the subscription database ................................................................... 386
Example ......................................................................................................................... 386
Back up the databases ............................................................................................... 386
Back up the transaction logs of the publication database ................................................ 387
Prepare for database restoration .................................................................................. 387
Restore the databases ................................................................................................. 388
Perform database recovery .......................................................................................... 389
Prepare to restart operations ....................................................................................... 389
Setting and checking the 'sync with backup' option .............................................................. 389
How to set the 'sync with backup' option ...................................................................... 389
How to check the 'sync with backup' option .................................................................. 390
7 Operation for Exchange databases .................................................. 391
Backing up and restoring a storage group ................................................................................. 391
Precautions when backing up an Exchange database ........................................................... 391
Precautions when restoring an Exchange database ............................................................... 392
Precautions when restoring from a tape ......................................................................... 392
Note on performing a recovery using roll forward .......................................................... 392
Procedure for handing the message (KAVX1510-E) ........................................................ 392
Notes on restoring data obtained with a VSS backup ..................................................... 393
Procedure for when the Information Store cannot be mounted .......................................... 393
10