Hi, I'm not quite sure if I'm answering your question here, and I may be opening a can of worms into a larger and much discussed topic, but might an 'export dump' to a flat file of your databases (into a .csv or | separated or similar format) which can then be given the TSM Archive treatment and kept strictly to your retention requirements help you here?
Being in a universal format it will generally mean that, in the event of a restore in x years time, you'll be able to get at your data irrespective of database platform or version, without having to rebuild the system to how it may have been at the point in time your backup was originally made. If security is also an issue here, as long as you are diligent with your key management, you could enable encryption (56bit DES) on the client, which is more than you can currently do with normal TDP/API based backups in TSM which don't at the moment support encryption. Hope that helps, David McClelland Tivoli Storage Manager Certified Consultant Operations Backup and Recovery Projects Shared Infrastructure Development Reuters 85 Fleet Street London EC4P 4AJ -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Levi, Ralph Sent: 12 November 2004 14:21 To: [EMAIL PROTECTED] Subject: Long-term data backup strategy I am looking for suggestions for saving data (db's and the like) for long periods of time. Our problem is servers go EOSL (end of service life) and we build newer ones but usually with different names, and can't do a simple rename in TSM because both old and new server will coexist for an extended time. Ultimately, it is time to delete the old server from TSM and unfortunately, all the data goes bye-bye. I prefer not to discuss the reality of what good is this data if the underlying application or DB version is obsolete. The users just "want their data saved" despite that we tell them it is nearly useless. Any suggestions would be welcome. Thanks, Ralph --------------------------------------------------------------- - Visit our Internet site at http://www.reuters.com Get closer to the financial markets with Reuters Messaging - for more information and to register, visit http://www.reuters.com/messaging Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Ltd.
