Wednesday, November 21, 2012 2:42 PM
I am using merge replication.But i found that mdf and ldf size are different at publisher and subscriber.Both database have same contents as merge replication(with push) is setup.
ldf- 68.1 MB
I saw this kind of difference for all databases which have merge replication.Why?
Wednesday, November 21, 2012 2:59 PMModerator
The MDF difference could be related to differences and that the data is bcp'd in and will be more contiguous and the pages/extents will be more full than with the publication databases.
The ldf contains the logged information. Expect it to be quite different between databases.
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 Shulei ChenModerator Thursday, November 29, 2012 7:04 AM
Friday, November 23, 2012 4:30 PM
This is not an issue. you need to know more about the architecture of SQL database and its internals. The case you mentioned can be explained with the example,
1. one glass of water which is 1 liter
2. another glass of water with same quantity 1 liter but with some stones.
check the weight of both glasss , 2 nd glass will be more. Here water is data and stone is free space occupied.
check you database free space available in both server ( publisher & subscriber)
Unless untill you have the problem in difference of data, you no need to worry about it . Check the free space on both database and release it accordingly.
- Marked As Answer by Shulei ChenModerator Thursday, November 29, 2012 7:03 AM