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

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