What is your compression rate from the node?  If it is in the same range of the 
DataDomain then do you really care?

Andy Huebner


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Nancy L Leugemors
Sent: Thursday, August 26, 2010 12:23 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Data Domain: Data Domain, and SQL-Backtrack with Sybase 
databases

Hello,

I'm looking for anyone who is using SQL-Backtrack for Sybase and Data
Domain/TSM?

We are replacing our Virtual Tape libraries and physical tape library with
Data Domains.  One here onsite and another at our DR location.   We have
setup the Data Domain to emulate VTL.

We are experiencing poor deduplication rates on our SQL-Backtrack Sybase
compressed databases only.   We see a 1:1:1 dedup ratio on Sybase data
backed up with Backtrack.

When the data is not compressed, we see dedup ratios anywhere from 5:1 to
150:1 on some tapes.   Obviously, as you add backup versions of the same
DB on DataDomain, each new version gets better dedup because a lot of
common blocks are already on the appliance.   But, of course then the
backup runs 2x as long which is not acceptable for our RPO.   Our
DB2-UDB,MS-SQL,and Domino TDP all are seeing much better dedup rates.



Background:

TSM Server Version: 5.5.4.0
TSM Client:  5.5.2.0
TSM Client Sybase Version: ASE 15.0.3
TSM Client SQL-Backtrack Version:  6.8
Data Domain:  Model:  880
Data Domain OS Version:  4.8.1.0



Nancy Leugemors
Enterprise Systems
HealthNow, NY
716-887-7979

CONFIDENTIALITY NOTICE: This email message and any attachments are for the sole 
use of the intended recipient(s) and may contain proprietary, confidential, 
trade secret or privileged information.  Any unauthorized review, use, 
disclosure or distribution is prohibited and may be a violation of law.  If you 
are not the intended recipient or a person responsible for delivering this 
message to an intended recipient, please contact the sender by reply email and 
destroy all copies of the original
message.

This e-mail (including any attachments) is confidential and may be legally 
privileged. If you are not an intended recipient or an authorized 
representative of an intended recipient, you are prohibited from using, copying 
or distributing the information in this e-mail or its attachments. If you have 
received this e-mail in error, please notify the sender immediately by return 
e-mail and delete all copies of this message and any attachments.

Thank you.