Thanks all - I'll take a look at transactional replication. Does anyone have a good (and easy) step by step guide?

Hi

Does replication require clustering? It can be delayed if needed so real time isn't a massive issue..

Thanks