May, 2009

  • Replication: Header information is either corrupted or missing

    I have seen this issue many times and decided to share my experience and how this issue may be resolved: Problem : I have installed a SQL Server 2005 and IIS on the same machine and all is working fine via HTTP. SQL Server Mobile connects, the subscription...
  • Replication: Questions about Upgrades and Mixed Technologies

    I have spoken to many people in regards to three common questions and therefore thought it may be useful to post this information on my blog What is the recommended way of upgrading your replication topology? What is the recommended way of upgrading...
  • Replication: Transactional Replication Performance Issue

    one possible cause... There are many factors that can influence the performance on a transactional replication topology. I would like to address one that is not so commonly known. Problem : I had worked on an issue in which we were experiencing...
  • Replication: Distribution Cleanup

    Manual Cleanup What can one do when the distribution cleanup job is unable to cleanup the transactions in the distribution database? If this should occur, one should analyze why this is happening as the cleanup job is essential to the replication...