We are using two different nodes for Windows servers with MS SQL databases - one for normal TSM backups and additional for MS SQL backups via TDP for SQL (for example, SERVER and SERVER_SQL).
TDP for SQL is not for archiving data for sure. Node SERVER_SQL keeps only online backups for MS SQL database with quite short expiry period - from 2 weeks to 1 month only. Usually it is enough for our applications. We are using node SERVER and normal ARCHIVE operation to make offline MS SQL database archives (database is taken as set of files, which has read/write consistency, because database is stopped). In this case, there is a possibility to keep offline SQL database backups for any required period of time in month or years. In addition, there is a possibility to keep in the same archive any other files, related to applications, to be in sync with database. In my opinion, this is the best way to have archives for databases. Of course, it is possible to dump data into file and then archive dump file, but this way is much less reliable. Regards, Grigori G. Solonovitch Senior Technical Architect Information Technology Bank of Kuwait and Middle East http://www.bkme.com Phone: (+965) 2231-2274 Mobile: (+965) 99798073 E-Mail: g.solonovi...@bkme.com Please consider the environment before printing this Email -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Botelho, Tiago (External) Sent: Tuesday, December 29, 2009 6:40 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] Can I archive SQL DB using TSM DP for SQL? Hello, Can I archive SQL DB using TSM DP for SQL? Thank you Please consider the environment before printing this Email. ________________________________ "This email message and any attachments transmitted with it may contain confidential and proprietary information, intended only for the named recipient(s). If you have received this message in error, or if you are not the named recipient(s), please delete this email after notifying the sender immediately. BKME cannot guarantee the integrity of this communication and accepts no liability for any damage caused by this email or its attachments due to viruses, any other defects, interception or unauthorized modification. The information, views, opinions and comments of this message are those of the individual and not necessarily endorsed by BKME."
