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

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