Sandesh,

I took the following numbers off of our dd670 this evening.  Oracle (10g) is 
being backed up by RMAN using the oracle client for NBU 7.0.  We backup all 
filesystems (Data, db, arch and redo) into the same LSU.  SQL2008 using the 
native SQL backup feature and dumps straight to the data domain via CIFS.

In our Oracle LSU we're getting 14.8x with a retention of 7 days (compression 
normally goes up the longer you keep the data).  On SQL 2008 direct dumps we're 
getting 32.6x with a retention of 1 month.

Someone else mentioned virtual environments.  We use Hyper-V and get 25.8x with 
a retention of 1 month.

Mark Glazerman
Desk: 314-889-8282
Cell: 618-520-3401
 please don't print this e-mail unless you really need to

-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu 
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of sandesh
Sent: Friday, April 22, 2011 3:10 PM
To: VERITAS-BU AT MAILMAN.ENG.AUBURN DOT EDU
Subject: [Veritas-bu] EMC Data Domain OST Vs VTL with NetBackup

Thanks rhugga

I also have a quick question to all experts on dedup ratio that you see on 
database backup, for e.g. SQL, DB2 & Oracle. 

What is the usual ratio you see with database backups using native application 
backup utilites or using NetBackup Agents? Does it make any difference do it?

Suppose if DBA's generates 1TB of SQL native database backup flat files for a 
given server and if I back up flat files using NetBakcup n keep it for 5 weeks 
essentially backing up 30TB of data then how much compression one would see and 
what factors does it depend on.? 

Thanks.

+----------------------------------------------------------------------
|This was sent by sandesh.nbu AT gmail DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu