"juValdiv" <juan@abacor.net> wrote in message
news:e3S44S1RFHA.3716@TK2MSFTNGP14.phx.gbl...
> Is there a simple way to copy an entire database to another new one?
>
> I need to copy my production database to another for training purposes.
>
> Thanks for your help,
>
> Juan.
>
>
>

> If you need data, you can use a DTS or Backup/Restore. Elsewhere you can
use
> the SQL script that creates the database (that you can obtain from
> Enterprise Manager..database\all task\ Generate SQL script)
>
> Francesco Anti
>
> "juValdiv" <juan@abacor.net> wrote in message
> news:e3S44S1RFHA.3716@TK2MSFTNGP14.phx.gbl...
> > Is there a simple way to copy an entire database to another new one?
> >
> > I need to copy my production database to another for training purposes.
> >
> > Thanks for your help,
> >
> > Juan.
> >
> >
> >
>
>