Process to create db copy on another server

23 Feb 2006 2:15 PM

Ben

Hello

(duplicated post in sqlserver.replication)

I have a production database that i would like to have mirrored on another
server. I have never worked with database replication, but from what I
understand, changes made to any of the replicated DBs get reflected in all
other DBs. What I need is to have the one production database copied daily
(or weekly) to another box.

Can I somehow set this up through replication so that the replicated
database cannot be updated? ie is static and just syncs to the production db?

Should I be using replication or another tool/process?

Thanks for the help!

23 Feb 2006 5:33 PM

Andrew J. Kelly

Replication is usually more for real time updates. But you can use Snapshot
replication and set the time to how ever often you wish. But if you are
really talking about a daily or even weekly copy I would just set up a job
to copy the full backup file to the other servers and restore it. You can
put the restored copy in ReadOnly mode so it doesn't have to use locks.

--
Andrew J. Kelly SQL MVP

Show quote

"Ben" <ben_1_ AT hotmail DOT com> wrote in message
news:01C58D3A-8F33-4C09-9326-A8D8BB754062@microsoft.com...
> Hello
>
> (duplicated post in sqlserver.replication)
>
> I have a production database that i would like to have mirrored on another
> server. I have never worked with database replication, but from what I
> understand, changes made to any of the replicated DBs get reflected in all
> other DBs. What I need is to have the one production database copied
> daily
> (or weekly) to another box.
>
> Can I somehow set this up through replication so that the replicated
> database cannot be updated? ie is static and just syncs to the production
> db?
>
> Should I be using replication or another tool/process?
>
> Thanks for the help!