Zoltan,

I am sorry your "SQL guy" is having trouble.
When restoring to an alternate server with alternate
locations, you need to specify each piece that you
are restoring, including all logical and physical
pieces involved in the backup... this is a SQL Server requirement.

If the IBM KB article cannot help you, can you please call IBM support?
They can walk you through this.

Thanks,

Del

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

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 10/06/2004
09:26:29 AM:

> My SQL guy sent me the following email about the restore:
>
> "ok, got it to work finally.  after upgrading the client, it still
> wouldn't restore to my SQL 7 instance.  so i tried the SQL 2000
instance,
> and that gave me an error that the path was incorrect (it was trying to
> restore to the D drive, which is where it was stored on ADMNT30, but i
> didn't have a D drive on DSS7).  so i tried to do a relocate files in
the
> TDP client, but the files and paths aren't there!  why?  i don't know,
> they should be.  so, on DSS7, i have a small seperate hard drive i had
> marked as E, i wiped it out, and renamed it D, and did the restore, and
it
> seems to be working.  what a pain in the.... !"
>
> Is there a workaround for this issue ?  Does it always have to go back
to
> the same drive-letter/path ?
>