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:[EMAIL PROTECTED] Im > Auftrag von Paul Dudley > Gesendet: Donnerstag, 20. Juli 2006 05:13 > An: ADSM-L@VM.MARIST.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 > > [EMAIL PROTECTED] > > > > > > > > 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. >