none
Replication mdf and ldf size

    Question

  • 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.

    At publisher

    mdf-45 MB

    ldf-26 MB

    At subscriber

    mdf-78.9 MB

    ldf- 68.1 MB

    I saw this kind of difference for all databases which have merge replication.Why?

    Wednesday, November 21, 2012 2:42 PM

Answers

  • 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

    Wednesday, November 21, 2012 2:59 PM
  • Hello,

    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.


    vijayasarathi

    Friday, November 23, 2012 4:30 PM

All replies

  • 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

    Wednesday, November 21, 2012 2:59 PM
  • Hello,

    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.


    vijayasarathi

    Friday, November 23, 2012 4:30 PM