IBM Tivoli Storage FlashCopy Manager for Windows, Version 4.1

Configuring Tivoli Storage FlashCopy Manager for SQL for Windows Server Core

You must configure Tivoli® Storage FlashCopy® Manager before you can protect your Microsoft SQL Server 2012 data in the Windows Server Core environment.

About this task

You must configure the client options file (dsm.opt) and configuration file (tdpsql.cfg).

Procedure

Edit the client options file (dsm.opt).
1. In the Tivoli Storage FlashCopy Manager installation directory, open the client options file (dsm.opt) with a text editor.
2. Add the following statements to the client options file:
```
NODename        sql_nodename
PASSWORDAccess  Generate
COMMMethod      TCPip
TCPServeradress tsm_server
TCPPort         1500
TCPWindowsize   63
TCPBuffSize     32
```
  Where nodename is the Tivoli Storage FlashCopy Manager node name, and TCPServeraddess is the name of the Tivoli Storage Manager server. You can enter the server IP address or the fully qualified domain name.
  For example:
```
NODename DOOMVM3_SQL
PASSWORDAccess generate
TCPServeraddress gijoe
TCPPort  1500
```
Edit the tdpsql.cfg file.
1. In the Tivoli Storage FlashCopy Manager installation directory, open the configuration file (tdpsql.cfg) with a text editor.
2. Add the following statements in the tdpsql.cfg file:
```
SQLSERVer          sql_server
FROMSQLserver      sql_server
SQLAUTHentication  INTegrated
MOUNTWaitfordata   Yes
BACKUPMethod       [Legacy|VSS]
DIFFESTimate       20
BUFFers            3
BUFFERSIze         1024
STRIPes            1
SQLBUFFers         0
SQLBUFFERSIze      1024
LOGPrune           60
LANGuage           ENU
BACKUPDestination  [LOCAL|TSM|BOTH]
LOCALDSMAgentnode  local_node
REMOTEDSMAgentnode remote_node
ALWAYSONNode       alwayson_node
USEALWAYSONnode    [TRUE|FALSE]
LOGFile            tdpsql.log
```
  The following list contains brief descriptions of the key options in the tdpsql.cfg file:
  SQLSERVer
  
  Specifies the name of the Microsoft SQL Server that is running on the local computer.
  
  BACKUPMethod
  
  Determines whether to run a Legacy or VSS backup.
  
  BACKUPDestination
  
  Determines whether to run a local backup, Tivoli Storage Manager backup, or both. For Legacy backup, only Tivoli Storage Manager is used.
  
  LOCALDSMAgentnode
  
  Specifies the local node name of the client that is running on the local computer. This option is required for VSS offloaded backups.
  
  REMOTEDSMAgentnode
  
  Specifies the remote client node that runs the VSS offloaded backups on a remote computer.
  
  ALWAYSONNode
  
  Specifies the Tivoli Storage Manager node name use to back up availability databases in an AlwaysOn Availability Group.
  
  USEALWAYSONnode
  
  Specify TRUE to set the AlwaysOn node as the default node for all backup operations of standard and availability databases. You can use this option to change database backups from a standard Tivoli Storage FlashCopy Manager node to an AlwaysOn node.
  Specify FALSE to back up standard databases to the Tivoli Storage FlashCopy Manager node. Availability databases are always backed up with the AlwaysOn node.
If you are running the stand-alone configuration on Tivoli Storage FlashCopy Manager, do the following steps:
1. In the Tivoli Storage FlashCopy Manager installation directory, open the client options file (dsm.opt) with a text editor.
2. Edit the dsm.opt file and change the TCPServeraddress tsm_server statement to TCPServeraddress flashcopymanager.
3. If installed, remove the Tivoli Storage Manager client acceptor service. Run the following command from a Command Prompt window:
```
C:\Program Files\Tivoli\TSM\baclient\dsmcutil remove /name:"TSM CAD"
```
  In this case, TSM CAD is the name of the client acceptor service that you want to remove.
4. Reinstall the remote client agent service by entering the following command:
```
C:\Program Files\Tivoli\TSM\baclient\dsmcutil install remoteagent 
/name:"TSM AGENT" /node:DOOMVM3_SQL /password:doomvm3sqlpasswd 
/partnername:"TSM CAD"
```
  In this case, TSM AGENT is the name of the remote agent and TSM CAD is the name of the client acceptor service.
5. Start the client acceptor service by entering the following command:
```
net start "TSM CAD"
```
  In this case, TSM CAD is the name of the client acceptor service are starting.
  
  Do not start the remote client agent service manually. The remote client agent service is automatically started by the client acceptor service when it is needed.
Optional: Use the VSSPOLICY option to Specify a management class for VSS backups.
Unless specified otherwise, Tivoli Storage FlashCopy Manager uses the default management class of the policy domain that its node name is in. To specify that Tivoli Storage FlashCopy Manager uses a different management class, add the VSSPOLICY option to the tdpsqlc.cfg file. The format of the option is as follows:
```
VSSPOLICY SQL_server_name "db_name" backup_type backup_dest mgmt_class
```
For example:
```
VSSPOLICY doomvm3 * FULL LOCAL MGMT2
```
This statement specifies that Tivoli Storage FlashCopy Manager uses the management class MGMT2 for local backups of any database in the SQL server named doomvm3.

Feedback