Currently, we backup everything either to DISKPOOL (which migrates to
LTOTAPE), or directly to LTOTAPE.  Files (backup/archive client), databases
(TDP for Domino, and TDP for SQL), everything is eventually stored into
LTOTAPE.  The databases get backed up FULL every time.  The largest
database we have is ~75GB.  The TDP SQL databases are in a different set of
management classes from the other files (TDP Domino databases have their
own management class, as well).

Soon, we will be creating an application that will have a 500GB database.
FULL backups for SQL databases will be changing over to FULL with DIFFs
(for the larger databases, FULLs on the smaller ones).  I would like to
segregate the SQL databases into their own tape storage pool.  There will
be no reclamation on the tapes in this storage pool, and collocation will
be turned on, because I will be doing some striped backups.   (I don't see
the sense in reclaiming tapes when the major databases range in size from
10% to 400% of a tape, but give me a reason to consider it, and I will)

What is the best way to handle moving/changing the storage location of my
SQL databases from the LTOTAPE storage pool to the LTOSQLTAPE storage pool
(I just made that name up).

Should I modify the existing management classes to start using the new
storage pool?  If so, what happens to the files in the current storage
pool?

Should I create a new management class pointing to the new storage pool and
change the INCLUDE statements to point to the new management class?  If so,
what happens to the files in the current storage pool and the current
management class?

Is there another way to do this?

Thanks in advance for your help.

Todd Lundstedt
Technical Specialist
Via Christi Information Management Services
Todd_Lundstedt AT via-christi DOT org