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:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 2:07 PM To: [EMAIL PROTECTED] 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. **********************************************************************