TDP for SQL ver 2.2 does support multiple sessions backing up to the tsm
server.  The term they use in the manual for this is data striping.
  Have a management class in the domain that your node belongs to that goes
to your tape pool.  You will want to send your data objects to this
managmentclass and your meta objects to a disk managementclass.
You will need to modify your options file to do this.
    include \...\meta \...\* diskmgmtclass
    include \...\data \...\* tapemgmtclass
Update your node so that it can use 4 tape drives (update <nodename>
maxnummp=4)

When you run your backup you will need to set the number of stripes equal to
the number of drives that you wish to use.  Also use this value when
performing restores.

James Thompson


>From: Diego N Fabani <[EMAIL PROTECTED]>
>Reply-To: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Database Backup with multiple drives
>Date: Tue, 19 Jun 2001 10:39:39 -0300
>
>Hi! I'm trying to perform a database backup ( ms-sql ) with TDP for SQL. I
>want to do it directly to a storage pool using 4 tape drives. Do you know
>how can i do to backup a big database using my 4 drives at the same time?
>
>Thank you very much, Diego.
>
>  Diego Nicolas Fabani
>  Distributed Services
>  E-mail :  [EMAIL PROTECTED]
>  Tel. #: 54-11-4319-7063.  Tie Line #: 840-7063
>  CTSI Martinez. IBM Argentina S.A.

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com

Reply via email to