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" <[email protected]> wrote on 08/12/2010 03:33:26 PM: >> From: dishonty <[email protected]> >> To: [email protected] >> Date: 08/12/2010 03:49 PM >> Subject: TDPSQL syntax for redirected restores >> Sent by: "ADSM: Dist Stor Manager" <[email protected]> >> >> 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
