Configuring the microsoft sql server – HP Data Protector Express Basic-Software User Manual
Page 65

Configuring the Microsoft SQL Server
You can configure any Data Protector Express feature by selecting the object from the Catalog view
and updating information on its property pages.
1.
Select the Administration desk bar and open the Catalog view.
2.
Select Network, 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 Folders view to display a hierarchical tree of the Data Protector Express
management domain.
4.
Right-click the database instance and display its property pages.
5.
Select the Configuration command to display the Configuration page.
NOTE:
We recommend that you use the default values on the Configuration page.
User name Data Protector Express sends this name to Microsoft SQL Server whenever the SQL
administrator user name is required. Type the Microsoft SQL administrator name in this field. 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 backup job affects Microsoft
SQL Server database instances differently than file types. The Force modes settings control how Data
Protector Express backs up the database instances.
NOTE:
The settings here are only applicable to Microsoft SQL Server database instances; all other file 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 file 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 files are only backed up when changed. This guarantees the greatest security for the most
crucial files 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 files.
Full When the Backup mode of a job is set to Full, Data Protector Express checks this setting to see how the
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 backed up.
Differential When the Backup mode of a job is set to Differential, Data Protector Express checks this
setting to see 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
65