TDP SQL BACKUP

[rye212015]

Hi,

We have 1.5tb database which taking 5 hrs to backup using tdpsql. Any ways to fine tune for the backup and restore to complete faster?
TSM Server connection is already running in 4GB teaming.

Your help will be much appreciated.

Thank you,
Ryan

 

[BaR]

Have a look here:
https://www.ibm.com/support/knowled...itsm.db.sql.doc/dps_con_info_performance.html

Mainly working with the stripes (or streams) and buffer size.

Bar

 

[rye212015]

Hi Bar,

I have tried to tweak the tdpsql.cfg settings and icrease stripes to 8 but not much changes on the sql db backup and restore performance.