7 operation for exchange databases – HP XP Command View Advanced Edition Software User 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

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