Sam,

There is an IBM technote (1105967) that explains this.
Go to:
     http://www.ibm.com

and search for:
     "Restoring SQL database to an alternate database"
or
    "1105967"

Make sure you include the quotation marks to help limit the search.

Thanks,

Del

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

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 12/21/2004
06:46:04 AM:

> I am trying to restore an SQL database from one server instance into
> another on a separate node. I can see on the node that the database was
> backed up on that backups have occurred succesfully but I cannot get any
> node to see the databases that were backed up from other nodes/instance.
>
> I have read the help guide and searched through the manuals/google but
> found nothing. I suspect that it is a mistake in the config on my part
> but I am not able to find out what it could be....
>
> Any ideas?