ADSM-L

Re: Paramter missing in tdpsqlc restore command

2006-07-20 07:11:36
Subject: Re: Paramter missing in tdpsqlc restore command
From: "Schaub, Steve" <steve_schaub AT BCBST DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 20 Jul 2006 07:10:44 -0400
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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Paul Dudley
Sent: Wednesday, July 19, 2006 11:13 PM
To: ADSM-L AT VM.MARIST DOT 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

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.
Please see the following link for the BlueCross BlueShield of Tennessee E-mail
disclaimer:  http://www.bcbst.com/email_disclaimer.shtm

<Prev in Thread] Current Thread [Next in Thread>