HP XP Array Manager Software User Manual
Page 17
![background image](/manuals/396954/17/background.png)
Procedure for restoring an SQL Server database to the primary volume ........................ 299
Procedure for restoring an SQL Server database from its backup tape .......................... 300
System configuration for backup of an SQL Server database to tape ............................ 307
Processing flow ..................................................................................................... 308
System configuration for operations using the SQL Server transaction log ..................... 311
Operation using transaction log backups ................................................................. 312
Operations using SQL Server transaction log backup (restoring a database to the state it
was immediately before failure) .............................................................................. 317
Backing up SQL Server transaction log backup files ................................................... 319
Example of operation in which a particular copy group is locked ................................ 324
System configuration for backing up and restoring an SQL Server database between a
local site and a remote site .................................................................................... 328
System configuration for backing up an SQL Server database to tape and restoring it from
tape in a multi-target configuration .......................................................................... 336
System configuration for restoring and recovering from a host not used for backup (when
backing up) ......................................................................................................... 342
System configuration for restoring and recovering from a host not used for backup (when
restoring) ............................................................................................................. 343
System configuration for log-shipping operations ....................................................... 347
System configuration for setting a distribution target server to be an operating server ..... 351
Sample configuration for backing up to a secondary volume at a remote site (cascade
configuration) ....................................................................................................... 352
Points in time at which a user script is executed ......................................................... 357
Sample cascade configuration ................................................................................ 358
Flow of script-specified operations performed when local backup is not involved ........... 360
Flow of script-specified operations performed when local backup is involved ................. 364
System configuration using file sharing to back up and restore an SQL Server
database ............................................................................................................. 378
System configuration for restoring data to an SQL Server instance different from the backup
source ................................................................................................................. 381
System configuration for restoring to an SQL Server instance that is different from the
backup source (using a user script) .......................................................................... 385
Configuration for using the SQL Server replication function ......................................... 389
Configuration of backup server for the publisher/distributor server .............................. 390
Operation when using Application Agent on an SQL Server in an AlwaysOn availability
group configuration ............................................................................................... 395
System configuration for backing up and restoring data between volumes by using VSS
(when an Exchange database is backed up) ............................................................. 404
Processing flow for backing up storage groups to a secondary volume ......................... 405
Processing flow for restoring storage groups on the primary volume ............................. 405
Application Agent CLI User Guide
17