Friday, August 03, 2012 10:48 AMHi Team,
I have setup Merge replication using push subscription. Data partition is enabled. I am not sure the role of data partition in replication as it is doing the same thing as the applied filter.
Also what is the use of the folders getting created in snapshot location by
If anyone knows,pls share with me.
Friday, August 03, 2012 12:10 PMModerator
The data partition will create a snapshot which just has the data which the subscriber needs. The filter will then filter changes
occurring on the subscriber and replicate them to the publisher if they fall into the filter criteria
occurring on the publisher and replicate them to the subscriber if they fall into the filter criteria
The folders are to create individual snapshots which contain only data for that subscriber or groups of subscribers which meet the filter criteria. If they used a common folder there might be a lot of files and other subscribers data could over write another subscriber.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Sunday, August 12, 2012 5:59 PM