Here's an example of a restore that relocates/renames the database and log
pieces:

tdpsqlc restore ServiceCenter3 full /into=ServiceCenterTemp /replace
/relocate=ServiceCenter1_Data,ServiceCenter1_Log
/to=g:\mssql7\data\servicecentertemp_data.mdf,g:\mssql7\data\servicecenterte
mp_log.ldf


The /relocate= values are found from doing a QUERY TSM /FILEINFO command.
You'll probably have to specify from /FROMSERVER= parameter, too. The above
command restores the most recent backup of the production database into a
test instance.

Bill Boyer
DSS, Inc.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Ung Yi
Sent: Wednesday, April 02, 2003 9:33 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SQL Restore Error


Hello,

I am still on TDP 1.?, but I think you have specify different file location
in the restore option if your directory structure are different between the
two servers.

Yi

>>> Mehdi.Amini AT VALUEOPTIONS DOT COM 04/01/03 01:30PM >>>
SQL Version 7
TDP Version 2.2.1


Trying to restore SQL Database onto another SQL Server but I am getting this
error


ACO0151E
Restore failed [Microsoft] ODBC SQL Server Driver...The file cannot be used
by RESTORE..Consider using With MOVE Option to identify a valid Location.

What am I doing wrong

Mehdi Amini
LAN/WAN Engineer
ValueOptions
12369 Sunrise Valley Drive
Suite C
Reston, VA 20191
Phone: 703-390-6855
Fax: 703-390-2581



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed.If you have received this email in error please notify
the sender by email, delete and destroy this message and its
attachments.

**********************************************************************