Tiago,
To schedule backups of the SQL databases, you will need to do the
followings
* In TSM define 2 "COMMAND" schedules; one to perform the DIFF or INCR
TDP backup (daily will work) and the other to perform the FULL backup
(weekly will work). Here is an example of how your FULL schedule will
look like "define sched TDPDOMAIN TDPSCHEDULEFULL action=command
object='"LOCATION_OF_TDP_DIRECTORY\TDPFULL.CMD"' ....watch the single
and double-quotes in the schedule definition.
* Define a new TSM Central Scheduler Service for the TDP node.
As Del noted, refer to the TDP for SQL guide at this link:
http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp?topic=/
com.ibm.itsmfd.doc/dpsql.htm
In the left frame, bring up the PDF and refer to Chapter3 for in-depth
details on the configuration.
Good luck.
BERTAUT TCHUISE
Storage Support Administrator
Legg Mason Technology Services
*410-580-7032
BTchuise AT leggmason DOT com
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Botelho, Tiago (External)
Sent: Friday, August 21, 2009 9:53 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] TSM Data Protection for SQL - Scheduler
Hello,
I'm new to TSM Data Protection for Databases.
I configured the TSM DP for SQL and I'm able to perform manual backups
for my SQL DB.
How can I Scheduler a Backup to a SQL Database (like TSM Scheduler in a
TSM BA Client) to perform daily backups?
TSM Server (AIX 6.1.3)
Server Version 5, Release 5, Level 3.0
TSM Data protection for SQL 5.5.1.0
Tdpsql.cfg
LASTPRUNEDate 21-08-2009 10:17:50
SQLAUTHentication SQLuserid
SQLSERVer VWAEPASV000127
FROMSQLserver VWAEPASV000127
MOUNTWaitfordata Yes
BACKUPMethod LEGACY
DIFFESTimate 20
BUFFers 3
BUFFERSIze 1024
STRIPes 1
SQLBUFFers 0
SQLBUFFERSIze 1024
LOGPrune 60
DATEformat 2
TARGETNode 1
LANGuage PTG
NUMBERformat 5
Dsm.opt
LASTPRUNEDate 21-08-2009 10:17:50
SQLAUTHentication SQLuserid
SQLSERVer VWAEPASV000127
FROMSQLserver VWAEPASV000127
MOUNTWaitfordata Yes
BACKUPMethod LEGACY
DIFFESTimate 20
BUFFers 3
BUFFERSIze 1024
STRIPes 1
SQLBUFFers 0
SQLBUFFERSIze 1024
LOGPrune 60
DATEformat 2
TARGETNode 1
LANGuage PTG
NUMBERformat 5
Thank you
Best regards
Tiago
IMPORTANT: E-mail sent through the Internet is not secure. Legg Mason
therefore recommends that you do not send any confidential or sensitive
information to us via electronic mail, including social security numbers,
account numbers, or personal identification numbers. Delivery, and or timely
delivery of Internet mail is not guaranteed. Legg Mason therefore recommends
that you do not send time sensitive
or action-oriented messages to us via electronic mail.
This message is intended for the addressee only and may contain privileged or
confidential information. Unless you are the intended recipient, you may not
use, copy or disclose to anyone any information contained in this message. If
you have received this message in error, please notify the author by replying
to this message and then kindly delete the message. Thank you.
|
