You are missing the dbname - you have to specify /relocate=<dbname>, the command line will not default. The /relocate and /to parms are matched pairs, which allows you to restore multiple db's in one command if you want Steve Schaub Systems Engineer, WNI BlueCross BlueShield of Tennessee 423-752-6574 (desk) 423-785-7347 (cell) ***public***
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Paul Dudley Sent: Wednesday, July 19, 2006 11:13 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] 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. Please see the following link for the BlueCross BlueShield of Tennessee E-mail disclaimer: http://www.bcbst.com/email_disclaimer.shtm
