HP XP7 Replication Manager Application Agent CLI User Guide (TK981-96015, May 2014)

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