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

Resynchronizing copy groups ...................................................................................... 302
Backing up an SQL Server database ............................................................................ 303
Restoring an SQL Server database from tape ....................................................................... 305
Restoring an SQL Server database ............................................................................... 305
Recovering an SQL Server database with the drmsqlrecover command ............................. 307
Recovering an SQL Server database using the drmsqlrecovertool dialog box ..................... 307
Backing up an SQL Server database by using a user script .......................................................... 308
System configuration ......................................................................................................... 309
Processing flow ................................................................................................................ 309
User script example .......................................................................................................... 310
Backup execution example ................................................................................................ 312
Operation using SQL Server transaction logs .............................................................................. 313
System configuration ......................................................................................................... 313
Example of operation using a transaction log backup ........................................................... 314
Backing up an SQL Server database ................................................................................... 315
Resynchronizing copy groups ...................................................................................... 315
Backing up an SQL Server database ............................................................................ 316
Backing up transaction logs ............................................................................................... 316
Restoring SQL Server databases ......................................................................................... 317
Applying the drmsqlrecovertool dialog box to restore an SQL Server database ......................... 317
Using the drmsqlrecovertool dialog box to recover an SQL Server database ...................... 317
Using the drmsqlrecover command to recover an SQL Server database (using a transaction
log list file) ................................................................................................................ 318
Example of operation using transaction log backup .............................................................. 319
Backing up and restoring transaction log backup files .................................................................. 320
System configuration ......................................................................................................... 321
Backing up the transaction log backup file ........................................................................... 322
Restoring the transaction log backup file .............................................................................. 324
Backing up and restoring multiple generations by locking a copy group ......................................... 325
Example of operation using lock functionality and generation management ............................. 326
Locking a copy group ....................................................................................................... 326
Unlocking a copy group .................................................................................................... 328
Backing up and restoring between local sites and remote sites ...................................................... 329
Backing up an SQL Server database to a remote site ............................................................ 331
Operation at the local site .......................................................................................... 331
Operation at the remote site ........................................................................................ 332
Operation at the local site .......................................................................................... 333
Restoring an SQL Server database to the local site ................................................................ 333
Operation at the remote site ........................................................................................ 333
Operation at the local site .......................................................................................... 334
Restoring an SQL Server database to a remote site ............................................................... 335
Operation at the remote site ........................................................................................ 335
Recovering data from the remote site to the local site ............................................................ 336
Operation at the local site .......................................................................................... 337
Operation at the remote site ........................................................................................ 337
Operation at the local site .......................................................................................... 337
Backing up and restoring in a multi-target configuration ............................................................... 337
Example of backing up an SQL Server database .................................................................. 340
Example of restoring an SQL Server database ...................................................................... 341
Performing restoration and recovery on a host other than the backup host ...................................... 343
Using the SQL Server log-shipping function ................................................................................ 348
Before using the log-shipping function ................................................................................. 348
Setting a distribution target server as an operating server ...................................................... 352
Backing up and restoring in a cascade configuration or multi-target configuration ........................... 354
Application Agent CLI User Guide 9