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" <[EMAIL PROTECTED]> 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
