HP StorageWorks P9000 Replication Manager Software 7.1.1 CLI User Guide (TB584-96032, September 2011)

Backing up and restoring by using a tape device ........................................................................ 290
System configuration ......................................................................................................... 291
Processing flow ................................................................................................................ 292
Backing up an SQL Server database to tape ........................................................................ 294
Resynchronizing copy groups ...................................................................................... 294
Backing up an SQL Server database ............................................................................ 295
Restoring an SQL Server database from tape ....................................................................... 297
Restoring an SQL Server database ............................................................................... 297
Recovering an SQL Server database with the drmsqlrecover command ............................. 299
Recovering an SQL Server database using the drmsqlrecovertool dialog box ..................... 299
Backing up an SQL Server database by using a user script .......................................................... 300
System configuration ......................................................................................................... 301
Processing flow ................................................................................................................ 301
User script example .......................................................................................................... 302
Backup execution example ................................................................................................ 304
Operation using SQL Server transaction logs .............................................................................. 305
System configuration ......................................................................................................... 305
Example of operation using a transaction log backup ........................................................... 306
Backing up an SQL Server database ................................................................................... 307
Resynchronizing copy groups ...................................................................................... 307
Backing up an SQL Server database ............................................................................ 308
Backing up transaction logs ............................................................................................... 308
Restoring SQL Server databases ......................................................................................... 309
Applying the drmsqlrecovertool dialog box to restore an SQL Server database ......................... 309
Using the drmsqlrecovertool dialog box to recover an SQL Server database ...................... 309
Using the drmsqlrecover command to recover an SQL Server database (using a transaction
log list file) ................................................................................................................ 310
Example of operation using transaction log backup .............................................................. 311
Backing up and restoring transaction log backup files .................................................................. 312
System configuration ......................................................................................................... 313
Backing up the transaction log backup file ........................................................................... 314
Restoring the transaction log backup file .............................................................................. 316
Backing up and restoring multiple generations by locking a copy group ......................................... 317
Example of operation using lock functionality and generation management ............................. 318
Locking a copy group ....................................................................................................... 318
Unlocking a copy group .................................................................................................... 320
Backing up and restoring between local sites and remote sites ...................................................... 321
Backing up an SQL Server database to a remote site ............................................................ 323
Operation at the local site .......................................................................................... 323
Operation at the remote site ........................................................................................ 324
Operation at the local site .......................................................................................... 325
Restoring an SQL Server database to the local site ................................................................ 325
Operation at the remote site ........................................................................................ 325
Operation at the local site .......................................................................................... 326
Restoring an SQL Server database to a remote site ............................................................... 327
Operation at the remote site ........................................................................................ 327
Recovering data from the remote site to the local site ............................................................ 328
Operation at the local site .......................................................................................... 329
Operation at the remote site ........................................................................................ 329
Operation at the local site .......................................................................................... 329
Backing up and restoring in a multi-target configuration ............................................................... 329
Example of backing up an SQL Server database .................................................................. 332
Example of restoring an SQL Server database ...................................................................... 333
Performing restoration and recovery on a host other than the backup host ...................................... 335
Using the SQL Server log-shipping function ................................................................................ 340
Application Agent CLI User Guide 9