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