"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:eBcVYpjyHHA.3696@TK2MSFTNGP03.phx.gbl...
> Roy,
> clustering isn't a way of distributed processing or load balancing so I
> wouldn't include it here.
> I'd look at transactional replication vs log shipping (see here
> http://www.replicationanswers.com/Standby.asp) vs database mirroring with
> database snapshots.
> HTH,
> Paul Ibison
>

"Roy Goldhammer" <roy@hotmail.com> wrote in message
news:%23wY4XYhyHHA.988@TK2MSFTNGP02.phx.gbl...
> Hello there
>
> I have one server that recive data, and 1 or more servers who just
> presenting the data.
>
> From my knowlage there are two way to do that:
> 1. transactional replication,
> 2. Windows clustring.
>
> I'm wondering which one of them are better.
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:%23wvSs4ryHHA.3588@TK2MSFTNGP06.phx.gbl...
> Use transactional replication. Transactional replication can be used in
> NLB environments where all the web servers which form the front end of
> your NLB servers hang off a single SQL Server, or they each have their own
> SQL Server. Replication can keep all these servers in sync.
>
> --
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Roy Goldhammer" <roy@hotmail.com> wrote in message
> news:%23wY4XYhyHHA.988@TK2MSFTNGP02.phx.gbl...
>> Hello there
>>
>> I have one server that recive data, and 1 or more servers who just
>> presenting the data.
>>
>> From my knowlage there are two way to do that:
>> 1. transactional replication,
>> 2. Windows clustring.
>>
>> I'm wondering which one of them are better.
>>
>>
>
>