HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 8)

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