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

Conﬁguring the Microsoft SQL Ser ver

You can conﬁgure any Data Protector Express feature by selecting the object from the Catalog view

and updating information on its proper ty pages.

1. Select the Admi

nistration desk bar and open the Catalog view .

2. Select Networ

k, then select the Microsoft SQL Server on your system.

3. Expand the object until you see a list of database instances.

TIP:

Switch to the F

olders view to display a hierarchical tree of the Data Protector Express

management domain.

4. Right-click the database instance and d isplay its property pages.

5. Select the Conﬁguration command to display the Conﬁguration page.

NOTE:

We recommend that you use the default values on the Conﬁguration page.

User name Data Protector Express sends this name to Microsoft SQL Ser ver whenever the SQL

administrator user name is required. Type the Microsoft SQL administrator name in this ﬁeld. The default

is sa.

Password Data Protector Express sends this SQL administrator password to Microsoft SQL Server with the

SQL administrator’s user name whenever required. There is no default value.

Force Modes As explained in the next section, the Backup mode setting of a b ackup job affects Microsoft

SQL Server database instances differently than ﬁle types. The Force modes settings control how Data

Protector Express backs up the database instances.

NOTE:

The settings here are only applicable to Micr o soft S QL Server database instances; all other ﬁle types are

backed up in the job’s default mode.

For example, if the Backup mode of a job is set to Incremental and the Force modes setting for incremental

jobs is set to Full , Data Protector Express will back up the SQL Server database instance in Full mode, but

all other ﬁ le types in Incremental mode

TIP:

You can use this feature to ensure that the databases in the instance are always backed up in full mode,

but that other ﬁles are only backed up when changed. This guarantees the greatest security for the most

crucial ﬁles that is, the SQL Server database instances, while not making jobs unnecessarily large by not

backing up the entire network that is, by backing up only the changed ﬁles.

Full When the

Backup mode of a job is set to Full,DataProtectorExpresschecksthissettingtoseehowthe

job should be run with SQL database instances. Full is the only possible setting, so the database instances

will be backed up in this mode. In this case, both the databases and the transaction logs are backe d up.

Differential When the Backup mode of a job is set to Differential, Data Protector Express checks this

setting to s

ee how the job should be run with SQL database instances. By default, Data Protector Express

runs the jobs as an incremental job and so only the transaction logs are backed up.

User’s Guide