HP XP Command View Advanced Edition Software - Manual (Page 8)

Backing up a file system to a remote site ............................................................................. 264
Operations at the local site ......................................................................................... 264
Operations at the remote site ...................................................................................... 265
Operations at the local site ......................................................................................... 266
Restoring a file system to the local site ................................................................................. 267
Operations at the remote site ...................................................................................... 267
Operations at the local site ......................................................................................... 268
Restoring a file system to a remote site ................................................................................ 269
Operations at the remote site ...................................................................................... 269
Recovering a file system from a remote site to the local site .................................................... 270
Operations at the local site ......................................................................................... 270
Operations at the remote site ...................................................................................... 270
Operations at the local site ......................................................................................... 270
Backing up and restoring a file system by using a tape backup management software that cannot link
with Application Agent ............................................................................................................ 270
Backing up and restoring a file system by using a file share .......................................................... 271
Preparing to back up or restore a file system by using a file share ........................................... 271
Example of backing up a file system by using a file share ...................................................... 272
Example of restoring a file system by using a file share .......................................................... 272
Deleting backup data .............................................................................................................. 273
6 Operation for SQL Server databases ................................................ 275
Backing up and restoring an SQL Server database ...................................................................... 275
Precautions when backing up and restoring a database ........................................................ 275
Precautions when restoring a database ............................................................................... 276
Precautions when recovering a database ............................................................................. 277
Precautions when backing up and restoring multiple databases .............................................. 277
When multiple databases are stored in the same volume ................................................ 277
When multiple databases are stored in multiple volumes ................................................. 278
Database status when restoring and recovering .................................................................... 279
Requirements for transaction log backup .............................................................................. 280
Precautions regarding backup of transaction logs ................................................................. 280
Precautions regarding sequences of transaction logs ............................................................. 281
Transaction log backups after roll-forward ..................................................................... 281
Precautions regarding application of transaction logs ............................................................ 283
Recovering the SQL Server database from the last backup data ....................................... 283
Recovering the SQL Server database from backup data existing prior to the last backup
data ......................................................................................................................... 284
SQL Server database requirements for executing commands .................................................. 284
Service status ............................................................................................................ 284
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 ........................................................ 292
Restoring an SQL Server database ............................................................................... 292
Using the drmsqlrecover command to recover an SQL Server database ............................. 293
Using the drmsqlrecovertool dialog box to recover an SQL Server database ...................... 293
Backing up and restoring by using a tape device ........................................................................ 294
System configuration ......................................................................................................... 295
Processing flow ................................................................................................................ 296
Backing up an SQL Server database to tape ........................................................................ 298
8