Re: [ADSM-L] SQL TDP lan free backup on VMWARE

We have 4 Storage Groups per Node, and 3 nodes.  However, 1 node is
about 600 GB, the other two add up to about 600 GB.  They all backup at
the same time of the night, when they do a full backup on each box.  We
have other Exchange nodes that backup at various times but these three
(being the largest) I have backing up at a time when they can have more
bandwidth.  We back them up via the LAN (1 GB NICS each) directly to
disk.  They all take about 4 (sometimes 5) hours each to backup unless
the LAN is congested which means the total backup time for the 1.2 TB is
around 4 to 4.5 hours, which is about 4.5 - 5 GB per Min.  Which means
we're pushing the TSM Server's NIC to about the edge. :-D

The TSM server has 1, 1GB NIC (Teamed in Failover mode).  Note: The 1
Largest node only takes 4 hours to do a full backup.  We used to have
them in a direct to SAN backup, but discovered that doesn't work much
faster than doing the LAN backup, and has the added burden of tying up 1
or more Tape drives per node, which could be doing other things.  Now,
if I had a 1.2 TB single system, this would be a no brainer for Direct
over SAN backup. But until it gets bigger than 8-9 hundred GB it really
does work out to be equal either way.  

See Ya'
Howard


> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of Len Boyle
> Sent: Monday, January 26, 2009 3:11 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] SQL TDP lan free backup on VMWARE
> 
> Howard,
> 
> Can you give the list a little more details on the Exchange system
> backup of 1.2 TB in about 4 or so hours.
> 
> How many exchange storage groups do you have and how many of them
> backup up in parallel?
> How large are they?
> Are you using multiple nics of 1gig each or a 10gig nic?
> 
> Thanks len
> 
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of Howard Coles
> Sent: Monday, January 26, 2009 3:34 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: [ADSM-L] SQL TDP lan free backup on VMWARE
> 
> Not necessarily.  You would think so, but in my experience your at
> about
> the break even point.  Due to the SAN having to go to tape, as opposed
> to being able to go to disk on a LAN backup.  I backup a few Exchange
> systems via TDP that equal about 1.2 TB in about 4 or so hours.
> 
> However, a good strategy would be to do a full once a week or month
and
> do diffs or incremental each day for speed's sake.
> 
> See Ya'
> Howard
> 
> 
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
Behalf
> > Of Adrian C. Pardo
> > Sent: Monday, January 26, 2009 2:26 PM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: [ADSM-L] SQL TDP lan free backup on VMWARE
> >
> > Mark,
> > The customer required to use the TDP, so, the way will be TDP via
> LAN,
> > but
> > 700 Gg in a Lan...will take longer than in a SAN..
> >
> > Adrian
> >
> >
> >
> > -----Mensaje original-----
> > De: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] En nombre
> de
> > Mark
> > Stapleton
> > Enviado el: Lunes, 26 de Enero de 2009 18:18
> > Para: ADSM-L AT VM.MARIST DOT EDU
> > Asunto: Re: [ADSM-L] SQL TDP lan free backup on VMWARE
> >
> > You'd be surprised on what little difference there can be between
LAN
> > and
> > SAN backups. However...
> >
> > Your next best bet is to do a dump of the database to a flat file,
> and
> > then
> > using the LAN-free storage agent to back that up across the SAN (to
> > tape
> > only, I'm afraid). If you don't have the storage agent license
> > purchased,
> > you'll need to do that in order to do SAN-based backups on that box.
> >
> > --
> > Mark Stapleton
> > System engineer, CDW
> >
> >
> > -----Original Message-----
> > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
Behalf
> > Of
> > Adrian C. Pardo
> > Sent: Monday, January 26, 2009 2:02 PM
> > To: ADSM-L AT VM.MARIST DOT EDU
> > Subject: Re: [ADSM-L] SQL TDP lan free backup on VMWARE
> >
> > Stef
> >
> > Well, next question, how can we do a Lan Free backup of these SQL
> > bases...
> > Doing via LAN will take forever!!
> >
> > Adrian
> >
> >
> > -----Mensaje original-----
> > De: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] En nombre
> de
> > Stef
> > Coene
> > Enviado el: Lunes, 26 de Enero de 2009 17:50
> > Para: ADSM-L AT VM.MARIST DOT EDU
> > Asunto: Re: [ADSM-L] SQL TDP lan free backup on VMWARE
> >
> > On Monday 26 January 2009, Adrian C. Pardo wrote:
> > > We need to backup a SQL database Using TDP and Lan Free on a
> VMware
> > > machine (the database size is 700Gig Aprox)
> > >
> > > Any sugestion??
> > Not possible.  The client can not access the hardware for SAN
access.
> >
> >
> > Stef
> >
> > No virus found in this incoming message.
> > Checked by AVG.
> > Version: 7.5.552 / Virus Database: 270.10.13/1916 - Release Date:
> > 1/26/2009
> > 7:08 AM
> >
> >
> > No virus found in this outgoing message.
> > Checked by AVG.
> > Version: 7.5.552 / Virus Database: 270.10.13/1916 - Release Date:
> > 1/26/2009
> > 7:08 AM