Best way to Copy a Replicated Database?

Hi.
We have a production database that is set up to be replicated to a fail-over
server, with two-day synchronization.
Periodically, our developers would like to make copies of the production
database to their development box. Obviously, we would just like to take a
copy of the database, without any of the replication settings. However, the
Copy Database Wizard does not allow copying of replicated databases.
How would you approach this problem?
Thanks
Jon,
you could use backup and restore.
HTH,
Paul Ibison
|||Hi. Thanks.
This will work to some extent. But I was hoping for something like Copy
Database Wizard, because of all other dependent information it can copy at
the same time.
Do I need to look for and copy anything manually after backup/restore to a
different server?
"Paul Ibison" wrote:

> Jon,
> you could use backup and restore.
> HTH,
> Paul Ibison
>
>
|||Jon,
essentially they do the same thing, however the way they do it is different.
The Copy database wizard does a detach and attach (sp_detach_db and
sp_attach_db) which causes your problems. Backup and restore will not cause
such problems but will achieve the same aims.
HTH,
Paul Ibison
|||Thank you very much. It worked just fine: it copied all relevant users and
Full-Text Catalog settings as well, which was pretty handy. I suppose the
only thing that did not get copied were the replication settings and some
jobs, which we mostly did not want copied to our development instance, anyhow.
"Paul Ibison" wrote:

> Jon,
> essentially they do the same thing, however the way they do it is different.
> The Copy database wizard does a detach and attach (sp_detach_db and
> sp_attach_db) which causes your problems. Backup and restore will not cause
> such problems but will achieve the same aims.
> HTH,
> Paul Ibison
>
>