Data Protector Express User's Guide (TC330-96002, October 2010)

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 m ode.

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

ﬁles as if it were running a job in Full backup mod e.

Backuping up Microsoft SQL Ser ver

Two add itional conc erns a re present when you back up SQL Server database instances: setting the

Backup mode of a job to either Full, Incremental

or Differential;andconﬁguring Data Pr otector Express

to work with SQL Server’s default backup routine.

NOTE:

Anytime Data Protector Express returns an error message that is gr eater 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 b ackup mode

The Backup mode on the Option s tab of a job that backs up SQL Ser ver database instances is especially

critical.

Backup modes When the Full set ting is selected, all ﬁles selected for backup are backed up, including

SQL Server database instances and databases. However, when either the Incremental or Differential

option is selected, Da ta Protector Express backs up only the transaction logs for each database.

CAUTION:

There is no differ ence 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 o p tion is automatically set to Full when backing up these databases.

IfyousetajobtorunineitherIncremental or Differential modeandthejobcanonlyrunasafullbackup

(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 ﬁnal pass.

Using Data Protector Express with SQL Server’s Backup Routine

Microsoft SQL Server has d efault 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 Ser ver utilities

and commands.

Working with Third-Party Applications