Zosimo

A very important question you need to answer is:

Are you are running Data Protection for SQL
backups using multiple stripes?

If you are, then you need to keep the data on separate tapes.
That is because during restore, you will also be using
striping and therefore those tapes will be mounted at
the same time and data will be read from those tapes
simultaneously.

The Data Protection for SQL User's Guide discusses
this under sections called "Data Striping Values"
and "Using Collocation".

Thanks,

Del

----------------------------------------------------

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 02/28/2004
03:40:51 AM:

> Hi TSMers,
>
> Can I disable collocation option on TDP for SQL storage pool?  I have 15
> clients with small amount of TDP backups and stored into different tapes
> (10% average utilization) and we're running out of tapes on the library.
> What is the impact if I disable the collocation?  Still I should easily
> restore the backups.  Thanks for you help in advance.