> What happens if, by reclamation process, two or more of the "striped" > portions of the backup get reclaimed onto the same tape? Will TSM allow > that to happen? if so, how do you do a restore? Any other gotchya's out > there?
Todd, In a nutshell.. turn on collocation by filespace to avoid this. We talk about this in Chapter 1 of the User's Guide under "Additional Strategy Considerations". * If you use data striping, also use Tivoli Storage Manager server filespace collocation to try to keep each stripe on a different storage volume. Use the Tivoli Storage Manager command UPDATE STGPOOL to set this parameter. It is recommended that meta data (counted as a separate filespace) not be allowed to go to tape media. * The maximum number of data stripes you can use must be smaller than the maximum supported by the SQL server and less than the value of the Tivoli Storage Manager server TXNGROUPMAX option in the dsmserv.opt file. SQL Server 7.0 allows a maximum of 32 data stripes, and SQL Server 2000 allows a maximum of 64. Thanks, Del ---------------------------------------------------- Del Hoobler IBM Corporation [EMAIL PROTECTED] - Leave everything a little better than you found it. - Smile a lot: it costs nothing and is beyond price.
