As a working example we use: (restore goes also to another db serever)
tdpsqlc restore ZP1 /tsmoptfile=dsm_restore.opt /tsmnode=s030sql 
/fromsqlserver=S030 /INTO=ZQ1 /strip=4 /replace 
/relocate=ZP1DATA1,ZP1DATA2,ZP1DATA3,ZP1DATA4,ZP1LOG1,ZP1LOG2 
/to=J:\ZQ1DATA1\ZQ1DATA1.mdf,J:\ZQ1DATA2\ZQ1DATA2.mdf,J:\ZQ1DATA3\ZQ1DATA3.mdf,G:\ZQ1DATA4\ZQ1DATA4.mdf,I:\ZQ1LOG1\ZQ1LOG1.ldf,I:\ZQ1LOG2\ZQ1LOG2.ldf
Regards
Stefan Holzwarth

> -----Ursprüngliche Nachricht-----
> Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im 
> Auftrag von Paul Dudley
> Gesendet: Donnerstag, 20. Juli 2006 05:13
> An: ADSM-L AT VM.MARIST DOT EDU
> Betreff: Paramter missing in tdpsqlc restore command
> 
> I am running the following tdpsqlc command and get a parameter missing
> error - possibly after /relocate  - can anyone point me in the right
> direction as to what I may be missing?
> 
> 
> 
> I am trying to restore a database from another server to a different
> location on this server
> 
> 
> 
> tdpsqlc restore Sales2000 full /fromsqlserver=nt_sales2_database
> /relocate /to=n:\Database\MSSQL\Data\Sales2000_Data.mdf
> 
> 
> 
> Regards
> 
> Paul
> 
> 
> 
> 
> 
> 
> 
> Paul Dudley
> 
> ANL IT Operations Dept.
> 
> ANL Container Line
> 
> pdudley AT anl.com DOT au
> 
> 
> 
> 
> 
> 
> 
> 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.
>