OK - I have done this and it is working as far as backing up the SQL database goes.
Now what do I do if I need to restore from this new node name back onto the client? Do I need to do anything with the dsm.opt and dsmarch.opt files before starting the restore? Regards Paul Dudley Senior IT Systems Administrator ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] 03-9257-0603 http://www.anl.com.au > -----Original Message----- > From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On > Behalf Of Del Hoobler > Sent: Saturday, 4 August 2007 2:37 AM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: [ADSM-L] TDP for SQL question > > Paul, > > Typically... I see that people will name their node > the same as their primary SQL node with an extension. > Something like: > Primary: SQLSRV23_SQL > Archive: SQLSRV23_SQL_ARCH > > And they will have a separate DSM.OPT file, something like > DSMARCH.OPT that has the archive nodename. > > Thanks, > > Del > > ---------------------------------------------------- > > "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on > 08/03/2007 > 12:53:23 AM: > > > I have been told that if I want to create an "archive" backup of an SQL > > 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 once > a > > month (for example) and make sure to bind those backups to a management > > 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? > > > > Regards > > Paul Dudley ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.