HP StorageWorks P9000 Replication Manager Software 7.1 CLI User Guide (TB584-96026, May 2011)

Database status ......................................................................................................... 285
Database type ........................................................................................................... 288
Backing up and restoring data between volumes ......................................................................... 289
System configuration ......................................................................................................... 289
Processing flow ................................................................................................................ 290
Backing up an SQL Server database to a secondary volume .................................................. 291
Restoring an SQL Server database to a primary volume ........................................................ 291
Restoring an SQL Server database ............................................................................... 291
Using the drmsqlrecover command to recover an SQL Server database ............................. 292
Using the drmsqlrecovertool dialog box to recover an SQL Server database ...................... 293
Backing up and restoring by using a tape device ........................................................................ 294
System configuration ......................................................................................................... 294
Processing flow ................................................................................................................ 296
Backing up an SQL Server database to tape ........................................................................ 298
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 ................................................................ 330
Operation at the remote site ........................................................................................ 330
Operation at the local site .......................................................................................... 331
Restoring an SQL Server database to a remote site ............................................................... 332
CLI User Guide 9