Below is a slight modification to the How to: Initialize a Transactional Subscription from a Backup steps to handle Publisher database backups to multiple BAK FILES. 1) Execute sp_addpublication (Transact-SQL) at the Publisher on the publication database. Specify a value of true for @allow_initialize_from_backup = N’true’ and @immediate_sync = N’true’ 2) Create a backup of
Read More »
Updated post on The process could not execute ‘sp_replcmds’
Content provided by: Ajith Krishnan Microsoft SQL Server Escalation Services I was working with Ajith the other day to track down a blocking problem for a customer. We know the “problem” stored procedure but wanted a quick way to determine which statement inside the stored procedure were being blocked. Ajith wrote the query below using
Read More »
Question to research: How can subscribers with just VBA do an “on demand synchronization”? Background: SQL 2008 R2 Standard Edition Publisher/Distributor with SQL 2008 R2 Express subscribers. SQL Express does not include SQL Agent to schedule Replication jobs, therefore, the subscribers are setup using “push” Replication from the Publisher. They would like the ability for
Read More »
Content Provided by: Paul King, Microsoft One of the most important things to watch out for with change data capture is the transaction log I/O subsystem. As stated earlier, log file I/O significantly grows when change data capture is enabled in a database. In addition to that, log records stay active until change data capture
Read More »