On 03/08/2007, at 2:53 PM, Paul Dudley wrote:
I have been told that if I want to create an "archive" backup of an
database via TDP for SQL, then I should create a separate node name in
TSM (such as "SQL_Archive") and then backup using that node name
month (for example) and make sure to bind those backups to a
class that has the long term settings that meet our requirements.
What else is involved in setting this up? On the client do I have to
create another dsm.opt file with the new node name to match what I set
up on the TSM server?
In the context of the BA client, you can create multiple server
stanzas in dsm.sys to point at different TSM instances and/or node
names - eg, we do this with one particular system so that we can hold
an image backup for ten days normally, but once a week, put one aside
for eight weeks. The dsm.sys for this node looks like:
All that is in dsm.opt is a line "servername (instance)", so that
backups by default go to the client's standard node; for the 8 week
retention, we add a "-se=(instance)_8WR", and TSM does the right
thing. (The '[...]' signals where I've cut out a number of TCP/IP
options, along with other client-side options.)
How to do this for a TDP client is left as an exercise for the
reader. :-) Hopefully, it should give you some ideas. Good luck.