We have 2 servers with 2005 merge replication setup and we have some questions about it:
1.) The database grew up about 55GB data(since most of them are binary image data) and log alternatively and we want to change from Full recovery mode to Simple recovery mode to reduce log size. Do we need to drop and create replication again or simply
change the recovery mode is enough? Any other procedures we need to follow?
2.) The snapshot(run once about 2 weeks) job run about 3 to 4 hours. As this job drew all the resources while it's riunning and severely affect other transactions, we want to reduce it's running time. How about rebuild the index for replication system tables(e.g.
msmerge_content) and how much gain by this action? Any other suggestions?
Thanks and regards,
View Complete Post