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.Solonovitch AT bkme 
DOT com



Please consider the environment before printing this Email





-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Botelho, Tiago (External)
Sent: Tuesday, December 29, 2009 6:40 PM
To: ADSM-L AT VM.MARIST DOT 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."