HP Data Protector A.06.11, Integration Manual

Page: 244 / 500

All ZDB types (ZDB to tape, ZDB to disk, and ZDB to disk+tape) are supported by
this integration. For ZDB types description, see the HP Data Protector zero downtime
backup concepts guide and the online Help.
Using Data Protector, you can restore your SQL Server data:
• From backup media to the application system on LAN (standard restore).
• Using the instant recovery functionality.
The following table gives an overview of SQL Server recovery methods:
Recovery method ZDB type
Standard restore ZDB to tape
Instant recovery ZDB to disk
Standard restore, instant recovery ZDB to disk+tape
For a description of ZDB and instant recovery concepts, see the HP Data Protector
zero downtime backup concepts guide.
Integration concepts
Data Protector integrates with SQL Server through the Data Protector
sql_bar.exe
executable, installed on SQL Server. During backup,
sql_bar.exe
, started on the
application system, connects to SQL Server to find the locations of the database files.
The integration then backs up SQL Server database(s), which are replicated within
a disk array.
During restore,
sql_bar.exe
connects to SQL Server to receive the restore data,
which is then written to disks.
ZDB process depends on whether you replicate your data in a split mirror or snapshot
replication and on the selected ZDB type. Restore process depends on the restore
type - standard restore or instant recovery. See the HP Data Protector zero downtime
backup concepts guide for a detailed description of replication techniques and ZDB
and restore processes.
Data Protector Microsoft SQL Server ZDB integration 244