Re: TDP for SQL question

2008-01-23 Thread Del Hoobler
Paul, If you need to restore from the new node name, you would launch the CLI or GUI specifying the alternate options file name. For example, in the example below: GUI: TDPSQL /TSMOPTFILE=DSMARCH.OPT CLI: TDPSQLC RESTORE dbname full /TSMOPTFILE=DSMARCH.OPT This will tell Data Protection for

Re: TDP for SQL question

2008-01-22 Thread Paul Dudley
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 Syst

Re: TDP for SQL question

2007-08-03 Thread Del Hoobler
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 nodenam

Re: TDP for SQL question

2007-08-02 Thread Stuart Lamble
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 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 t

Re: TDP for SQL question

2003-07-02 Thread Loon, E.J. van - SPLXM
are re-investigating. Thanks!!! Kindest regards, Eric van Loon KLM Royal Dutch Airlines -Original Message- From: Del Hoobler [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 21:02 To: [EMAIL PROTECTED] Subject: Re: TDP for SQL question Eric, I would have them check again to make

Re: TDP for SQL question

2003-07-01 Thread Del Hoobler
Eric, I would have them check again to make sure they are using the NODENAME they think they are using. Have them check their DP for SQL logs files as well. Also, check the TSM Server activity log to see what messages are being logged for that NODENAME. DP for SQL will log ending statistics that s

Re: TDP for SQL question

2001-10-19 Thread Del Hoobler
> Now the question, can we tell the TDP client to do a restore of the > production database but then redirect it to another server running SQL? We > have a spare server that has plenty of space that can be used for this. If you are using TDP for SQL 1.1.2, refer to the TDP for SQL 1.1.2 Installat

Re: TDP for SQL Question

2001-05-10 Thread Robert L King
r Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: TDP for SQL Question Yes, by default that is the way it is done. After you install TDP on the client, look in the ..Tivoli/TSM/Mssql directory. The file sqlfull.smp is designed to be copied to sqlfull.cmd. You need

Re: TDP for SQL Question

2001-05-10 Thread William Degli-Angeli
TDP for Sql supports the use of wildcard characters in the command line backup commands. Thanks, Bill William Degli-Angeli IGS TDP Development Endicott, NY (607) 752-6749 TieLine: 852-6749 Internet: [EMAIL PROTECTED] "Magura, Curtis"

Re: TDP for SQL Question

2001-05-10 Thread David Longo
Yes, by default that is the way it is done. After you install TDP on the client, look in the ..Tivoli/TSM/Mssql directory. The file sqlfull.smp is designed to be copied to sqlfull.cmd. You need to edit the bat file for directories etc. The backup command in it wil do a full backup of ALL DB