Tiago,

There is a section in the User's Guide that discusses this exact topic.
Please take a look.

Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 08/21/2009
09:53:28 AM:

> [image removed]
>
> TSM Data Protection for SQL - Scheduler
>
> Botelho, Tiago (External)
>
> to:
>
> ADSM-L
>
> 08/21/2009 09:55 AM
>
> Sent by:
>
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> Please respond to "ADSM: Dist Stor Manager"
>
> 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
>
>
>
>