locked
Purpose of the In and Out files when Sync-ing RRS feed

  • Question

  • Hi Folks, 

    I am new to using SQL Server replication and I was wondering if 
    someone could explain or point me in the right direction for an 
    explanation of In and Out files which appear and disappear when 
    performing a sync?

    Many thanks,

    Morris 

    Sunday, April 25, 2010 9:54 PM

Answers

  • they are for  debugging in web syncs. There is a registry setting to disable their creation.
    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
    Monday, April 26, 2010 1:00 AM
    Answerer
  • I regret that I can't find a link to where I first read about this. My ms contact does not seem to know about it either. I did recently find this which might help you.

     

    http://blogs.msdn.com/repltalk/archive/2010/03/22/how-to-change-the-reporting-level-for-the-merge-replication-replmerg-log.aspx

     

     


    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, April 28, 2010 5:30 PM
    Answerer

All replies

  • they are for  debugging in web syncs. There is a registry setting to disable their creation.
    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
    Monday, April 26, 2010 1:00 AM
    Answerer
  • Hi,

    Thanks for the answer, that makes sense.

    What is the registry key to disable their creation. Also, it is possible to increase or decrease the level of logging for example?

    Actually, is there an online resource where I can get a full explanation of this?

    Thanks,

    Morris

    Monday, April 26, 2010 7:32 AM
  • I was googling like a fiend trying to dig up that info last night. I can't find that info. I'll ping a contact of mine on the merge team.

    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
    Monday, April 26, 2010 12:14 PM
    Answerer
  • Thanks, that'd be great!

    Wednesday, April 28, 2010 8:16 AM
  • I regret that I can't find a link to where I first read about this. My ms contact does not seem to know about it either. I did recently find this which might help you.

     

    http://blogs.msdn.com/repltalk/archive/2010/03/22/how-to-change-the-reporting-level-for-the-merge-replication-replmerg-log.aspx

     

     


    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, April 28, 2010 5:30 PM
    Answerer
  • Thanks for the link, it looks to be very helpful

    Sorry for the delay in responding, been off on Holiday for a few days.

    Tuesday, May 4, 2010 8:12 AM