Yvonne,

Use the "/SQLSERVER=<instance>" option to indicate which
SQL Server instance you want to talk to. Use this for
all backup and restore operations.
For example:

   TDPSQLC BACKUP * FULL /SQLSERVER=SERVER1\INSTANCE1

   TDPSQL /SQLSERVER=SERVER1\INSTANCE1


For a command-line RESTORE, when restoring FROM a specific instance,
use the '/FROMSQLSERVER=<instance>' option.
For example,

   TDPSQLC RESTORE database1 FULL /RECOVery=Yes
/FROMSQLserver=SERVER1\INSTANCE3

>From the GUI, you do not need to specify the FROMSQLSERVER option,
since it knows which SQL Server to use based on your selection.

For a command-line QUERY, when querying from a specific instance,
use the '/FROMSQLSERVER=<instance>' option.
For example,

   TDPSQLC QUERY TSM * /ALL /FROMSQLserver=SERVER1\INSTANCE4


For more details, please take a look at the User's Guide. It contains
information about these two options as well as some examples.


Thanks,

Del

----------------------------------------------------


"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu> wrote on 08/12/2010
03:33:26 PM:

>> From: dishonty <tsm-forum AT BACKUPCENTRAL DOT COM>
>> To: ADSM-L AT vm.marist DOT edu
>> Date: 08/12/2010 03:49 PM
>> Subject: TDPSQL syntax for redirected restores
>> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>
>>
>> Hello,
>> I am new to TDPSQL (5.5.4).
>> I have 5 sql(2008) instances under the same node on the same
>> server.  I want to be able to restore a database from one instance
>> to a different instance under this same node. I am looking for good
>> example of how to accomplish this, as well as, the best way to
>> command line query info for a specific instance.
>> Any examples would be greatly appreciated!
>> Yvonne Dishon