Replication: Issue with setting up Transactional Replication with Updatable Subscribers and NFR Triggers

Problem: I have set up a Transactional Replication with Updatable Subscribers on my SQL 2005 server and created user triggers on the Publisher database. These triggers have been configured with “not for replication”. I update my subscriber and the changes are propagated onto the publisher. I then update my publisher and these changes are not sent…

0

CDC: CDC Hangs when I try to disable it

Problem Description: SQL Server 2008 SP1 Transactional Replication CDC enabled I have an issue that occurs while trying to disable CDC on one of my databases. When I execute the system stored procedure sys.sp_cdc_disable_db, the procedure will hang waiting on a “REPL_HISTORYCACHE_ACCESS” lock for an indefinite amount of time. Workaround / Solution: The cause of…

0

Replication: SQLCESALOG: Is it possible to change the number of files and the size of each?

Yes it is. Following the following KB article:     http://support.microsoft.com/kb/955968 In SP1 for SQL Server Compact 3.5 is different from previous versions. Please check KB article for differences. MaxLogFileSize and MaxPreviousLogFiles are the two keys that we can use to alter the file size and increase the previous log files. There is a minimum value for…

0

Replication: Merge Fails with error : “The process could not increment the lineage version”

I have come across this interesting issue in which we have the following scenario: Merge Replication All servers are running SQL 2008 When merge replication is processing certain published articles, we see that the merge agent is blocked, and is being blocked by another spid executing another task coming from the same merge agent. A…

2

Replication: My merge agent keeps “dropping and creating” my newly added articles!!!

Problem: Consider the following scenario: You add a new article(s) to an existing publication in your merge replication environment and Your merge agent uses ‘-ParallelUploadDownload’ parameter with a value of 1 for synchronization. Note: Merge Agent profile High Volume Server-to-Server Profile enables parameter -ParallelUploadDownload In this scenario, you will notice that the merge agent enumerates…

0

Replication: The schema script could not be propagated

Problem: I create a SQL Server 2005 replication topology on my Windows 2003 server. Everything synchronizes fine. I then go and add a default constraint to an article. Subscriber is synchronized and the default constraint is propagated to the subscriber. Subscriber is marked for reinit with upload first. When the subscriber is marked for re-initialisation,…

0

SQL Server: SQL Server and Windows “End of Support” Dates

http://blogs.msdn.com/psssql/archive/2010/01/08/important-sql-server-and-windows-end-of-support-dates-you-should-know-about.aspx taken from the blog above, this information is important for all to know: Important SQL Server and Windows “End of Support” Dates you should know about…. There are some important dates about the end of support for specific products and releases involving SQL Server and Windows that I want you to be aware of:…

0

Replication: Access Permission Error when generating Dynamic Snaphot

Problem: My snapshot agent fails to create a dynamic snapshot  for a subscriber in my Merge replication environment. Each subscriber is supposed to receive the snapshot based on their login account. Each account is explicitly added to a group which is defined in the PAL .However the agent fails with the below error. The login…

0

Replication: Transactional Replication Over WAN

A lot of users have wondered about the performance latency transactional replication suffers over WAN. After analyzing / discussing this within the teams, here are the main points one should take into consideration when deciding / testing this type of implementation: Should you notice performance degradation when testing your transactional replication over WAN, please verify…

1

Happy New Year Readers

Happy New Year Readers! May the best moments of 2009, be the worst of 2010 are my wishes to you all 🙂

0