Choosing an appropriate replication type

[sarahw]

Could anyone advise on the most appropriate type of replication required for the following scenario?

One live server and one backup server, limited no of transactions per day - 2000ish, connected on 100mb LAN.

Any advise will be gratefully received. Thanks in advance.

Sarah

 

[fluteplr]

What version of SQL Server 7 or 2000?
Given that volumn though it probably doesn't really matter.

 

[sarahw]

Thanks for responding. SQL Server 2000. I was thinking maybe Transactional Replication with Updating Subscribers. But after speaking with someone, they have mentioned clustering maybe an option. I have read something about this but don't quite understand how it would be implemented. Would replication or distributed transactions still be required?

Any info would be very helpful.