HP P9000 Replication Manager Software 7.3.1-00 CLI User Guide

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