Moses,
Your metadata shows the following 6 files: 3 data files named DWH_Data,
DWH_1_Data, and DWH_2_Data and 3 log files named DWH_Log, DWHPROD_Log, and
DWHPROD_Log1. However, your TDPSQLC RESTORE command is only relocating two
of them, DWH_Data and DWH_Log. Therefore, the other 4 files are trying to
restore themselves to locations that are determined from the metadata stored
with the backup set. In the case of DHWPROD_Log, the file was located on
the F: drive on the original SQL Server, as you can see from your /FILEINFO
query. Therefore, since your TDPSQLC RESTORE command does not RELOCATE the
file, TDPSQLC is trying to restore it on the F: drive on the target server
as well. The solution is that you need to RELOCATE _all_ the files that
should have different physical names on the target server.
Hope this helps,
Chris
_________________________________
Chris Leonard
MCSE, MCDBA, OCP, CIW
_________________________________
The Database Guy
http://www.databaseguy.com
Brainbench MVP for Oracle Admin
http://www.brainbench.com
_________________________________
smime.p7s
Description: S/MIME cryptographic signature
|