SQL Server Faq

Transactional Replication in SQL 2008 Fails “The distribution agent failed to create temporary files in ‘C:Program FilesMicrosoft SQL Server100COM’ directory. System returned errorcode 5.” Tweet

  It has been really long time since I have updated this blog as my Job involves a lot of travel however I try my best to update it frequently. In this blog I am going to discuss a issue … Continue reading

The subscription fails to Sync with the Publisher and marked inactive even though the settings have been configured to “never expire”

  We get the below error message when distribution agent tries to sync, Error: 14151, Severity: 18, State: 1. The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated. CAUSE: ====== … Continue reading