Luc,

Yes. If using the GUI, after selecting the database on the restore tab
use the right-mouse button on the database entry in order
to enter the new database name... and also to choose the
locations for the new database files.
You can also do this from the command-line.
You might find some other hints/tips in the User's Guide
or on WWW.IBM.COM, search for:
   +tdp +sql +restore +alternate

Thanks,

Del
----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 10/13/2004
09:55:58 AM:

> Hi All
>
> Is there a way to restore a SQL database on the same server but with a
> different name ????
>
> thanks
>
> Luc