This is a common problem with deduplication, and someone at EMC should have
told you this before you bought.

You should not/cannot run compression on your backups before they get to the
dedupe system.  It messes most of them up.

As to finding someone with your config?  Good luck with that.  Data Domain
VTL, Sybase, and SQL Backtrack are all products with very little market
share.  (Data Domain has good market share, but very few DD customers use
VTL.)  When you combine them together like that, your chances of finding
someone else doing it is slim to none.  Your best bet would be to call the
SQL Backtrack guys and see what they can help you find.

W. Curtis Preston

On Thu, Aug 26, 2010 at 10:22 AM, Nancy L Leugemors <
Leugemors.Nancy AT healthnow DOT org> wrote:

> 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.
>