I have production Environment Microsoft SQL server 2000 Sp3a Cluster,i have 4 tables to be (2 way replication) merge replication with other site , one of tables have image column, now the size for this table more than 50GB so when i will create Replication the initial snapshot will take more than 5 hours down time , my questions:
1- which better method to when initial snapshot for Publish merge replication ?
2- what the best senarion to cleanup replication with out remove the subscriber database and with out create new snapshot again ?
3- if i disable snapshot agent job after initial snapshot finished there is any side affect on replication?
Thanks & Regards.