Dear experts,

I have to contnous transfer data from one sql server to another sql server , but condition is that first sql (database used and inserted by another application) should maintain 3 month data at any time and anohter sql will store all the data transfer from first sql. I want standard way for doing this. Kindly acknowledge.


What about replication?