HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 10)

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