HP XP P9000 Replication Manager Software 7.6.1-00 Application Agent CLI User Guide
Backing up a file system to a remote site ............................................................................. 268
Operations at the local site ......................................................................................... 268
Operations at the remote site ...................................................................................... 269
Operations at the local site ......................................................................................... 270
Restoring a file system to the local site ................................................................................. 271
Operations at the remote site ...................................................................................... 271
Operations at the local site ......................................................................................... 272
Restoring a file system to a remote site ................................................................................ 273
Operations at the remote site ...................................................................................... 273
Recovering a file system from a remote site to the local site .................................................... 274
Operations at the local site ......................................................................................... 274
Operations at the remote site ...................................................................................... 274
Operations at the local site ......................................................................................... 274
Backing up and restoring a file system by using a tape backup management software that cannot link
with Application Agent ............................................................................................................ 274
Backing up and restoring a file system by using a file share .......................................................... 275
Preparing to back up or restore a file system by using a file share ........................................... 275
Example of backing up a file system by using a file share ...................................................... 276
Example of restoring a file system by using a file share .......................................................... 276
Deleting backup data .............................................................................................................. 277
6 Operation for SQL Server databases ................................................ 279
Backing up and restoring an SQL Server database ...................................................................... 279
Precautions when backing up and restoring a database ........................................................ 279
Precautions when restoring a database ............................................................................... 280
Precautions when recovering a database ............................................................................. 281
Precautions when backing up and restoring multiple databases .............................................. 281
When multiple databases are stored in the same volume ................................................ 281
When multiple databases are stored in multiple volumes ................................................. 282
Database status when restoring and recovering .................................................................... 283
Requirements for transaction log backup .............................................................................. 284
Precautions regarding backup of transaction logs ................................................................. 284
Precautions regarding sequences of transaction logs ............................................................. 285
Transaction log backups after roll-forward ..................................................................... 285
Precautions regarding application of transaction logs ............................................................ 287
Recovering the SQL Server database from the last backup data ....................................... 287
Recovering the SQL Server database from backup data existing prior to the last backup
data ......................................................................................................................... 288
SQL Server database requirements for executing commands .................................................. 288
Service status ............................................................................................................ 288
Database status ......................................................................................................... 289
Database type ........................................................................................................... 292
Backing up and restoring data between volumes ......................................................................... 293
System configuration ......................................................................................................... 293
Processing flow ................................................................................................................ 294
Backing up an SQL Server database to a secondary volume .................................................. 295
Restoring an SQL Server database to a primary volume ........................................................ 296
Restoring an SQL Server database ............................................................................... 296
Using the drmsqlrecover command to recover an SQL Server database ............................. 297
Using the drmsqlrecovertool dialog box to recover an SQL Server database ...................... 297
Backing up and restoring by using a tape device ........................................................................ 298
System configuration ......................................................................................................... 299
Processing flow ................................................................................................................ 300
Backing up an SQL Server database to tape ........................................................................ 302
8