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:[EMAIL PROTECTED] Behalf Of Ung Yi Sent: Wednesday, April 02, 2003 9:33 AM To: [EMAIL PROTECTED] 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 >>> [EMAIL PROTECTED] 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. **********************************************************************
