Hi,
I have the following scenario, and need to configure replication for
this. Pls advice.

We have 3 SQL server databases, at 3 locations on SQL server 2000
servers. They are connected over WAN by 2 MBPS link (triangle). I have
to configure replication on this. Database has around 200 tables, and
size of database would be around 200-500 MB each. Changes would be minor
on daily basis.
I have these servers at following locations.
Loc1 (HeadOffice)
Loc2 (branch office)
Loc3 (branch office)

Data has to replicate from Loc2 and Loc3 to Loc1 at short intervals
during the day.
Somewhere in midnight (off peak hours), data has to replicate from Loc1
to Loc2 and Loc3 (for changes made at Loc1 to be reflected in Loc2 and
Loc3).
These database are modified only during the day, and number of users at
each location will not exceed 30.

I have following queries
- Can I configure Transactional replication for Loc2 -> Loc1 and Loc3 ->
Loc1 to replicate at short intervals. And additionally Snapshot to
happen at midnight from Loc1 -> Loc2 and Loc3.
Or do I require Merge replication for this scenario. (or any other
solution you think would suit this requirement)

Pls suggest.

Thanx,
Shrikant Patil

MS Sql Server LazyDBA home page