Re: How to clone a db ?

Hi!
Of course!
make the backup of your DB,
create new instance with the desired name
(be sure to create with "for recovery" option),
and then recover from your backup.
It works perfect on my side,
Bye!!
Marcin
Uzytkownik "Marc-Olivier Meunier" <[email protected]> napisal w
wiadomosci news:00b801c36270$4e0697e0$0419e48c@froggy...
> Hi all
>
> I would like to know if there is a simple way to clone a db ?
> I have my db1 database and i want a db2 database with the same owner,
> same dbprocs, same tables, everything the same except the name of the
> database. What is the simpliest way to do that ?
> Is there any script that can do that easily ?
>
> --
> Marc-Olivier Meunier
> Ingénieur Projet BKLINK
> MVH-IRIS
> 14, rue Rougemont
> 75009 Paris