HP Data Protector Express Basic-Software - Manual (Page 66)

NOTE:
There is no distinct Differential job mode for SQL Sever database instances.
If you want jobs with a Differential backup mode to back up both the database and the transaction
logs, change this setting to Full. In this case, Data Protector Express will treat the SQL Server database
instances as if it were running a job in Full backup mode.
Incremental When the Backup mode of a job is set to Incremental , Data Protector Express checks this
setting to see how the job should be run with SQL databases. By default, Data Protector Express runs the
jobs as an incremental job and so only the transaction logs are backed up.
If you want jobs with an Incremental backup mode to back up both the database and the transaction
logs, change this setting to Full. In this case, Data Protector Express will treat the SQL Server database
files as if it were running a job in Full backup mode.
Backuping up Microsoft SQL Server
Two additional concerns are present when you back up SQL Server database instances: setting the
Backup mode of a job to either Full, Incremental , or Differential; and configuring Data Protector Express
to work with SQL Server’s default backup routine.
NOTE:
Anytime Data Protector Express returns an error message that is greater than 10000, a Microsoft SQL or
Exchange error has occurred. Refer to your Microsoft documentation for more information as this is a
Microsoft error code.
Microsoft SQL Server Databases and the backup mode
The Backup mode on the Option s tab of a job that backs up SQL Server database instances is especially
critical.
Backup modes When the Full setting is selected, all files selected for backup are backed up, including
SQL Server database instances and databases. However, when either the Incremental or Differential
option is selected, Data Protector Express backs up only the transaction logs for each database.
CAUTION:
There is no difference between Incremental and Differential jobs for SQL Server databases.
When the Backup mode is set to Copy, Data Protector Express a creates a full backup of the database
but does not truncate the logs.
Additional Conditions Master, Model, MSDB and Pubs databases support only full backups. The
Backup mode option is automatically set to Full when backing up these databases.
If you set a job to run in either Incremental or Differential mode and the job can only run as a full backup
(as a result of the provision above), the job will fail to run on each of its initial passes, but will run
in Full backup mode on its final pass.
Using Data Protector Express with SQL Server’s Backup Routine
Microsoft SQL Server has default utilities and commands for backing up data. When you use Data
Protector Express to back up SQL Server databases, you can still use these default SQL Server utilities
and commands.
66 Working with Third-Party Applications