• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

TDP SQL configuration

Hiten

ADSM.ORG Member
#1
We have recently migrated to IBM Spectrum Protect 8.1.4 and would like to configure TDP for SQL.
OS: Microsoft 2012 R2 64bit
IBM TDP Client: 08.01.0400
SQL version: MS SQL 2012 STD and ENT edition
 

Hiten

ADSM.ORG Member
#4
We have ISP 8.1.4 installed and want to configure TDP for SQL backup. We have installed BA client and TDP for SQL from latest bundle. When tried to configure the same got failed. We followed the attached process but it won't work.
 

Attachments

marclant

ADSM.ORG Moderator
#5
I can't speak for the others, but I'm not downloading a .zip file from unknown source.

Can you explain the steps you took here and document the error(s) you got?
 

Bharanij

ADSM.ORG Member
#6
1) To take the backup of MS SQL Db’s we need to install TDP SQL software in the client machine along with BA Client software.
2) The default installation directory for BA Client is as below:
C:\program files\tivoli\tsm\baclient
3) The default installation directory for TDP SQL is as below:
C:\program files\tivoli\tsm\tdpsql
4) Types of backup in SQL:
FULL BACKUP: It always takes the full backup of DB.
DIFFERENTIAL BACKUP: It always takes backup of changes made to DB from last full backup to the most current state of the DB.
LOG BACKUP: It always takes the backup of transaction logs generated in the SQL Log file.
5) TSM Server Side configuration:
a) Initially we need to register two nodes in the TSM server. One node is for file system backup and second node is for SQL DB backup.
b) Use the below commands to register the nodes to the TSM Server.
Reg node nodename nodepassword domain=domainname userid=none
6) Client side configuration:
a) Initially we need to install BA Client Software in the client machine and once we install BA Client Software we will get a client configuration file in the default directory of BA Client i.e., “dsm.opt” .
b) We need to provide required entries into “dsm.opt” file for successful running of the BA client.
c) Now we need to install TDP SQL software in the client machine. And once we install TDP SQL software we can find the below configuration files in the default directory of TDPSQL as mentioned above.
“TDPSQL.exe”
“TDPSQLC.exe”
“dsm.opt”
“TDPSQLFULL.smp”
“TDPSQLDIFF.smp”
“TDPSQLLOG.smp”
d) We need to provide necessary entries in the “dsm.opt” file of TDP SQL node. In that we need to enter the node name as the SQL node name which we registered in the TSM Server.
e) Once done with the changes in “dsm.opt’ file of TDPSQL then we need to reset the password of the TDPSQL node. For that first we need to go to command prompt of windows server of client machine there we need to go the below directory:
C:\programfile\tivoli\tsm\tdpsql
f) And give the below command to change the password.
Tdpsqlc changepassword oldpassword newpassword confirmpassword
g) Once we have reset the password we can trigger the backup of SQLDB manually by using below commands. For that we need to login to the TDPSQL directory and use below commands.

For full backup:

Tdpsql backup * full

For Diff backup:

Tdpsql backup * diff

For Log Backup:

Tdpsql backup * log

h) If we want to schedule a backup for the SQL DB then initially we need to make some entries in the below TDPSQL configuration files:

“TDPSQLFULL.SMP”, “TDPSQLDIFF.SMP”, “TDPSQLLOG.SMP”

i) We need to open “TDPSQLFULL.SMP” file make the following entries:

“TDPSQLC backup * full”

And then convert the file from “.SMP” format to “ CMD” format.

j) Repeat the same above step for differential and LOG backup using below commands:

k) For Differential: TDPSQL backup * diff

l) for LOG: TDPSQL backup * log

m) once we have made the required changes in the client configuration file of TDPSQL node then we need to schedule a scheduler service in the TSM Server by using below command:

define schedule domainname schedule name action=cmd objects=”location of TDPSQL.CMD” startdate=date starttime=hr: mm:ss duration=number durationunits=hours period=number periodunits=days/weeks/months/years

n) Then we need to associate the nodes to the TSM Server by using below command:

Define associate domainname schedulename nodename

o) Thus SQL DB backups are configured.


This was in that zip file but explain what issue your facing ?
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 17 19.5%
  • Keep using TSM for Spectrum Protect.

    Votes: 53 60.9%
  • Let's be formal and just say Spectrum Protect

    Votes: 10 11.5%
  • Other (please comement)

    Votes: 7 8.0%

Forum statistics

Threads
31,467
Messages
134,114
Members
21,565
Latest member
Chrescht
Top