HP StorageWorks P9000 Replication Manager Software 7.1.1 CLI User Guide (TB584-96032, September 2011)
Processing flow ................................................................................................................ 253
User script example .......................................................................................................... 254
Backup execution example ................................................................................................ 257
Backing up and restoring between local sites and remote sites ...................................................... 259
Backing up a file system to a remote site ............................................................................. 260
Operations at the local site ......................................................................................... 260
Operations at the remote site ...................................................................................... 261
Operations at the local site ......................................................................................... 262
Restoring a file system to the local site ................................................................................. 263
Operations at the remote site ...................................................................................... 263
Operations at the local site ......................................................................................... 264
Restoring a file system to a remote site ................................................................................ 265
Operations at the remote site ...................................................................................... 265
Recovering a file system from a remote site to the local site .................................................... 266
Operations at the local site ......................................................................................... 266
Operations at the remote site ...................................................................................... 266
Operations at the local site ......................................................................................... 266
Backing up and restoring a file system by using a tape backup management software that cannot link
with Application Agent ............................................................................................................ 266
Backing up and restoring a file system by using a file share .......................................................... 267
Preparing to back up or restore a file system by using a file share ........................................... 267
Example of backing up a file system by using a file share ...................................................... 268
Example of restoring a file system by using a file share .......................................................... 268
Deleting backup data .............................................................................................................. 269
6 Operation for SQL Server databases ................................................ 271
Backing up and restoring an SQL Server database ...................................................................... 271
Precautions when backing up and restoring a database ........................................................ 271
Precautions when restoring a database ............................................................................... 272
Precautions when recovering a database ............................................................................. 273
Precautions when backing up and restoring multiple databases .............................................. 273
When multiple databases are stored in the same volume ................................................ 273
When multiple databases are stored in multiple volumes ................................................. 274
Database status when restoring and recovering .................................................................... 275
Requirements for transaction log backup .............................................................................. 276
Precautions regarding backup of transaction logs ................................................................. 276
Precautions regarding sequences of transaction logs ............................................................. 277
Transaction log backups after roll-forward ..................................................................... 277
Precautions regarding application of transaction logs ............................................................ 279
Recovering the SQL Server database from the last backup data ....................................... 279
Recovering the SQL Server database from backup data existing prior to the last backup
data ......................................................................................................................... 280
SQL Server database requirements for executing commands .................................................. 280
Service status ............................................................................................................ 280
Database status ......................................................................................................... 281
Database type ........................................................................................................... 284
Backing up and restoring data between volumes ......................................................................... 285
System configuration ......................................................................................................... 285
Processing flow ................................................................................................................ 286
Backing up an SQL Server database to a secondary volume .................................................. 287
Restoring an SQL Server database to a primary volume ........................................................ 288
Restoring an SQL Server database ............................................................................... 288
Using the drmsqlrecover command to recover an SQL Server database ............................. 289
Using the drmsqlrecovertool dialog box to recover an SQL Server database ...................... 289
8