Is that a mouthful! I'm looking for suggestions and experience. I have a two node active/active cluster On one node a Publisher with a vb app processing/loading around 100K entries a day. The other node is the handles the distributor feeding 3 seperate subscribers that our web front end retrieve from.
I need to have a hot standby server ready to take over the tasks of the 2 node cluster. And I'm looking at Transactional Replication and Log Shipping http://msdn.microsoft.com/library/default.asp?url=/library/en-us/replsql/replbackup_3js7.asp%5B/url%5D as my solution. Specifically the Semi-Synchronous Mode, since I'm looking for lease amount of latency and can turn off the data feeds. As anyone out there tried implementing Transactional Replication with Log Shipping? Was it on a cluster (not that should matter). Any gottchas, bugs, quirks, or was it as smooth as silk.
John Zacharkan