I sent this out just over a month ago, and received no responses. Trying
again to see if anyone can help.... Thanks..
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
ps FYI. Since the first time I sent this note out, I have done some
testing. After working with TSM support on an issue that came up in my
testing, I find out that a management class cannot be changed if you are
backing up LANFREE. You must back up the file across the LAN in order to
change the management class. Once the active version of the file is in the
new management class, LANFREE backups can resume. However, I am still
getting occasional errors when I do this, and then try to perform striped
backups.
|
