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 methodZDB type
Standard restoreZDB to tape
Instant recoveryZDB to disk
Standard restore, instant recoveryZDB 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 integration244
To Next Page
Loading...
Need help?
General