Monday, May 14, 2012

Merge Replication for Huge Tables

I have a problem. I have an audit table which is about 66 million rows, and the client wants to replicate it to another server, but this table has no cluster index, so the only way to do it is through merge replication, but it always times out, I gues this happends because the table is tat big.



I want to know if there is a way to do this without getting the timeout error?



Thanks.





No comments:

Post a Comment