Since My email, I did exactly as you recommed and it worked.

THanks so much

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


-----Original Message-----
From: Del Hoobler [mailto:hoobler AT US.IBM DOT COM]
Sent: Tuesday, April 01, 2003 2:07 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SQL Restore Error


Mehdi,

Look at the /RELOCATE and /TO options.
(... or the right-mouse click while the
backup to restore is selected.)

This allows you to move the database
to a different physical location.

Thanks,

Del

----------------------------------------------------

> 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


**********************************************************************
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.

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