Chapter 3. Installation and configuration
3.2 Detailed installation and configuration procedure
3.2.10 Specifying Data Protection for SQL preferences
Data Protection for SQL configuration parameters are defined in the Data Protection for SQL configuration file (tdpsql.cfg by default). These configuration parameters determine such preferences as the location of your log file, how date and time stamps display, and the number
of buffers to use. You can set the values of the Data Protection for SQL configuration parameters in two ways:
Using the Configuration task in the Edit Menu of the Data Protection for SQL GUI.
Using the tdpsqlc set command in the Data Protection for SQL Command Line Interface.
Note the following characteristics of Data Protection for SQL configuration parameters:
The value of a configuration parameter specified on a command line invocation overrides (but does not change) the value of the configuration parameter specified in the Data Protection for SQL configuration file.
During a command line invocation that does not specify an overriding value for a configuration file parameter, the values in the default Data Protection for SQL configuration file (tdpsql.cfg) are used.
Set the policy for VSS backups by specifying the VSSPOLICY statement in your Data Protection for SQL configuration file. Note this parameter can only be set in the configuration file - it cannot be specified using the tdpsqlc set command or the Configuration task in the Edit Menu of the Data Protection for SQL GUI.
VSSPOLICY statements are processed from the bottom up and processing stops at the first match. To ensure that more specific specifications are processed at all, the more general specification should be listed before the more specific ones, so as to be processed after the more specific specifications. Otherwise, the more general specification will match the target before the more specific specifications are seen.
By default, SQL Server accepts connections on TCP/IP port 1433. If SQL Server is
configured to listen on a TCP/IP port different than 1433, you must specify the TCP/IP port for the parameters SQLSERVer and FROMSQLserver. Example 3-16 shows how to configure Tivoli Data Protection for SQL Server to access the instance SQL_STDBY on server COPPER using port 5555.
Example 3-16 TDPSQL.cfg parameter file to access a SQL Server on a port different than 1433 SQLSERVer COPPER\SQL_STDBY,5555
FROMSQLserver COPPER\SQL_STDBY,5555
If you do not specify the TCP/IP port when accessing a SQL Server instance listening on a non default port, you will receive an error messages similar to Example 3-28.
Figure 3-28 Tivoli Data Protection for SQL connection error
Configure Data Protection preferences on a standalone environment
In a non-clustered environment you can configure the preferences in the default preferences files located on C:\Program Files\Tivoli\TSM\TDPSQL\tdpsql.cfg. If you have more than one
backup policy, you can create different preferences files. See Example 3-17 on page 88 and Example 3-18 on page 88.
Example 3-17 Data Protection for SQL configuration file for Daily Backups (tdpsql_daily.cfg) SQLSERVer COPPER
FROMSQLserver COPPER
SQLAUTHentication INTegrated nodename copper_sql
MOUNTWaitfordata Yes BACKUPMethod LEGACY DIFFESTimate 20
BACKUPDestination Both LOCALDSMAgentnode copper_vss REMOTEDSMAgentnode
********** Server Storage Group Name BU Type BU Dest. Mgmt Class
********** --- --- --- --- ---VSSPOLICY * * FULL TSM VSS_FULL_TSM VSSPOLICY * * LOCAL LOCAL VSS_LOCAL
Example 3-18 Data Protection for SQL configuration file for Monthly Backups (tdpsql_long.cfg) SQLSERVer COPPER
FROMSQLserver COPPER
SQLAUTHentication INTegrated nodename copper_lng
MOUNTWaitfordata Yes BACKUPMethod LEGACY DIFFESTimate 20
BACKUPDestination TSM
LOCALDSMAgentnode copper_vss REMOTEDSMAgentnode
********** Server Storage Group Name BU Type BU Dest. Mgmt Class
********** --- --- --- --- ---VSSPOLICY * * FULL TSM VSS_LONG_TSM
We recommend creating a shortcut for the TDP for SQL GUI pointing to each options file. You can follow the steps 1-3 described on page 81 to create the shortcuts.
To create shortcuts for daily and monthly backups you need to specify the options and
Example 3-19 Shortcut definition for Daily SQL Backup
"C:\Program Files\Tivoli\TSM\TDPSql\tdpsql.exe" /tsmoptfile="C:\Program Files\Tivoli\TSM\TDPSql\dsm_daily.opt" /configfile="C:\Program
Files\Tivoli\TSM\TDPSql\tdpsql_daily.cfg"
Example 3-20 Shortcut definition for Monthly SQL Backup
"C:\Program Files\Tivoli\TSM\TDPSql\tdpsql.exe" /tsmoptfile="C:\Program Files\Tivoli\TSM\TDPSql\dsm_long.opt" /configfile="C:\Program
Files\Tivoli\TSM\TDPSql\tdpsql_long.cfg"
Configure Data Protection preferences in a clustered environment
In a clustered environment the DSMAgent options file for each node in a cluster was created.
Now, it is necessary to configure Data Protection for SQL preferences for each node in the cluster. You can use a directory in an external disk, and configure both files, one for each node in the cluster. You need to match the correspondent LOCALDSMAgentnode according to the specific machine in the cluster.
If you are using an offloaded backup server, it is necessary to configure the
REMOTEDSMAgent node, pointing to your offloaded node. This parameter is only required if you are using an offloaded backup server.
This configuration also contains the VSSPOLICY statements, so if you have more than backup policy it is necessary to specify more than one configuration. See Example 3-21 on page 89, Example 3-21 on page 89, Example 3-23 on page 90 and Example 3-24 on page 90.
Example 3-21 Data Protection for SQL configuration file for Daily Backups (tdpsql_libra_daily.cfg) SQLSERVer CLUSQL01\SQL01
FROMSQLserver CLUSQL01\SQL01 SQLAUTHentication INTegrated nodename CLUSQL01_Daily
MOUNTWaitfordata Yes BACKUPMethod LEGACY DIFFESTimate 20
BACKUPDestination Both LOCALDSMAgentnode libra_vss REMOTEDSMAgentnode leo_offload
********** Server Storage Group Name BU Type BU Dest. Mgmt Class
********** --- --- --- ---
********** --- --- --- --- ---VSSPOLICY * * FULL TSM VSS_FULL_TSM VSSPOLICY * * LOCAL LOCAL VSS_LOCAL
Example 3-22 Data Protection for SQL configuration file for Monthly Backups (tdpsql_libra_long.cfg) SQLSERVer CLUSQL01\SQL01
FROMSQLserver CLUSQL01\SQL01 SQLAUTHentication INTegrated nodename clusql01_lng
MOUNTWaitfordata Yes BACKUPMethod LEGACY DIFFESTimate 20
BACKUPDestination TSM LOCALDSMAgentnode libra_vss REMOTEDSMAgentnode leo_offload
********** Server Storage Group Name BU Type BU Dest. Mgmt Class
********** --- --- --- --- ---VSSPOLICY * * FULL TSM VSS_LONG_TSM
Example 3-23 Data Protection for SQL configuration file for Daily Backups (tdpsql_leo_daily.cfg) SQLSERVer CLUSQL01\SQL01
FROMSQLserver CLUSQL01\SQL01 SQLAUTHentication INTegrated nodename CLUSQL01_Daily
MOUNTWaitfordata Yes BACKUPMethod LEGACY DIFFESTimate 20
BACKUPDestination Both LOCALDSMAgentnode leo_vss REMOTEDSMAgentnode libra_offload
********** Server Storage Group Name BU Type BU Dest. Mgmt Class
********** --- --- --- ---
********** --- --- --- --- ---VSSPOLICY * * FULL TSM VSS_FULL_TSM VSSPOLICY * * LOCAL LOCAL VSS_LOCAL
Example 3-24 Data Protection for SQL configuration file for Monthly Backups (tdpsql_leo_long.cfg) SQLSERVer CLUSQL01\SQL01
FROMSQLserver CLUSQL01\SQL01 SQLAUTHentication INTegrated nodename clusql01_lng
DIFFESTimate 20
BACKUPDestination TSM LOCALDSMAgentnode leo_vss REMOTEDSMAgentnode libra_offload
********** Server Storage Group Name BU Type BU Dest. Mgmt Class
********** --- --- --- --- ---VSSPOLICY * * FULL TSM VSS_LONG_TSM
We recommend creating a shortcut for the TDP for SQL GUI pointing to each options file. You can follow the steps 1-3 described on page 81 to create the shortcuts.
To create shortcuts for daily and monthly backups you need to specify the options and configuration file. See Example 3-25 on page 91, Example 3-26 on page 91, Example 3-27 on page 91 and Example 3-28 on page 91.
Example 3-25 Shortcut definition for Daily SQL Backup for server Libra
"C:\Program Files\Tivoli\TSM\TDPSql\tdpsql.exe"
/tsmoptfile="E:\tsmdata\dsm_mssqldb_daily.opt"
/configfile="E:\tsmdata\tdpsql_libra\tdpsql_libra_daily.cfg"
Example 3-26 Shortcut definition for Daily SQL Backup for server Leo
"C:\Program Files\Tivoli\TSM\TDPSql\tdpsql.exe"
/tsmoptfile="E:\tsmdata\dsm_mssqldb_daily.opt"
/configfile="E:\tsmdata\tdpsql_libra\tdpsql_leo_daily.cfg"
Example 3-27 Shortcut definition for Monthly SQL Backup for server Libra
"C:\Program Files\Tivoli\TSM\TDPSql\tdpsql.exe"
/tsmoptfile="E:\tsmdata\dsm_mssqldb_long.opt"
/configfile="E:\tsmdata\tdpsql_libra\tdpsql_libra_long.cfg"
Example 3-28 Shortcut definition for Monthly SQL Backup for server Leo
"C:\Program Files\Tivoli\TSM\TDPSql\tdpsql.exe"
/tsmoptfile="E:\tsmdata\dsm_mssqldb_daily.opt"
/configfile="E:\tsmdata\tdpsql_libra\tdpsql_leo_long.cfg"