Sam,

There is no "set access" function for Data Protection for SQL
so you need to connect with the TSM Server as the NODENAME that
originally performed the backup.

Did you try the IBM Tech note (1105967)that I pointed you to
on 12/21 in this list? What happened when you tried it?

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 01/07/2005
05:10:54 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?
> >
> > Thanks!
> >
> > Sam