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 [EMAIL PROTECTED]
