ADSM-L

Re: SQL database restore question

2004-08-27 10:04:37
Subject: Re: SQL database restore question
From: "Leonard, Christopher" <christopher-leonard AT UIOWA DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 27 Aug 2004 09:05:24 -0500
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
_________________________________

Attachment: smime.p7s
Description: S/MIME cryptographic signature

<Prev in Thread] Current Thread [Next in Thread>