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 [email protected] -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Botelho, Tiago (External) Sent: Friday, August 21, 2009 9:53 AM To: [email protected] 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.
