Hi, we use Sybase on UNIX, so I don't know if this helps but...
First, SQL Backtrack, IMHO, is not production software. We dump ALL the databases to a filesystem, then backup the filesystem and database dumps as regular files, it works very well. However I have the benefit of a high speed network (SP switch) and 32x18GB disks for the filesystem (RAID 0). The filesystem is NFS mounted. I know on UNIX Sybase can only create 32 stripes and each stripe is limited to 2 GB - IF your using a 32-bit version, ie. v11. So won't help you, IF your on v11. For performance I can dump 20MB/s to a local array, 10MB/s to NFS. Let me know if you need more info. Miles ------------------------------------------------------------------------------------------- Miles Purdy System Manager Farm Income Programs Directorate Winnipeg, MB, CA [EMAIL PROTECTED] ph: (204) 984-1602 fax: (204) 983-7557 ------------------------------------------------------------------------------------------- >>> [EMAIL PROTECTED] 22-Oct-01 4:33:10 AM >>> Hi TSMers, Is there anyone has experience on TSM with Sybase? We have a customer with 200GB data on Sybase (NT platform). As we have checked, SQL Backtrack and OBSI module for ADSM couldn't work with the LAN-free backup of TSM, so we want to propose online dump DB method, then will use TSM's LAN-free backup with the intermediate file created. Does anyone has this experience that can share as we concern with the performance of dumping 200GB? Thanks. Best Regards, Molly Pui I/T Specialist Tivoli Systems, IBM China/Hong Kong Limited Email: [EMAIL PROTECTED]
