Transactional Replication has been configured between 2 SQL Server 2008 R2 instances. There is a single Publication with 60 articles. Initial snapshot worked. (Around 120GB of BCP files were generated.)
OLTP_SQLServer2008R2 (10.50.1777) is a PUBlisher. OLAP_SQLServer2008R2 9(10.50.2789) is the DIStributor and SUBscriber.
Replication is working fine.
Business now wants to add 5 new articles to Publication. (4 tables contain a couple of 100 records, one table contains 1,600,000 rows.)
Publication is change to reflect the 5 new tables.
Snapshot Agent is done after business hours. (Replications starts generating snapshot for all 60+ tables, not just the 5 new ones. Which is not ideal, so that might need to be tweaked, as I believe it should just snapshot the new articles in the publication, no?)
In any case the Snapshot Agent does not complete. Errors indicate "Failed to read BLOB column". Snapshot Agent retries a number of times. Same error. Finally it stops retrying after a number of times.
Replication is no longer working. Replication Monitor shows that there are 234,666 commands waiting in the distribution database which will take over 1 hour to complete.