HI all, I am trying to replicated a huge database, problem is the subscriber server is a development server and it has just 1024mb ram to use for the whole sql server. Now i am stuck with one of the tables which has 40 million rowns in it. It is approximately 30GB long. Is there a way to spped up this process. My publisher is sql 2000 my subscriber is sql2005. Thanks in advance.
Which replication you are using!! Merge Replication: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/mergperf.mspx Tran Replication: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx
