Browse by Tags

Tagged Content List
  • Blog Post: Follow the Data in Transactional Replication

    Follow the Data in Transactional Replication Chris Skorlinski Microsoft SQL Server Escalation Services Abstract Many technology solutions use a STORE and FORWARD model to move data though out the business. It begins when source data change is detected, collected, and STORED in a cache. This...
  • Blog Post: Distribution Agent fails with “Could not remove directory” error

    Distribution Agent fails with “Could not remove directory” error Sateesh Yele Microsoft SQL Server Support Symptom: The Distribution Clean up job fails with the following error. Executed as user: Domainname\Username. Could not remove directory ‘C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER...
  • Blog Post: Published Database Transaction Log continues to Grow!

    Chris Skorlinski Microsoft SQL Server Escalation Services A customer recently noticed their Published database transaction log would continue to grow until they backed up the Distribution database.  DBCC OPENTRAN() Oldest distributed LSN     : ( 0 : 0 : 0 ) Oldest non - distributed...
  • Blog Post: What Immediate_sync means in Transactional Replication

    What Immediate_sync means in Transactional Replication José Moreira Neto Microsoft SQL Server Escalation Services sp_addpublication parameter: [ @immediate_sync=] 'immediate_synchronization' Immediate_sync has a default of FALSE. independent_agent must be true for immediate_synchronization...
  • Blog Post: What is a “virtual” Subscription in Transactional Replication

    What is a “virtual” Subscription in Transactional Replication The SQL Replication system table syssubscriptions contains one row per published article per subscriber. Notice the “virtual” subscriber. With the immediate_sync property is set to true, “virtual” subscriptions are created as placeholders...
Page 1 of 1 (5 items)