The transactional-replication tag has no wiki summary.
3
votes
1answer
251 views
SQL Server 2008 R2 replication high delivery latency
I am seeing an unusually high delivery latency between our distributor and subscribers and i do not understand why.
We have in this configuration 3 sql servers using transactional push replication to ...
4
votes
0answers
147 views
Initializing Transactional Replication From Backup
There is an option when setting up a publication for replication to Allow Initialization From Backup. We have been creating replicated databases for several years now and have always initialized from ...
2
votes
0answers
144 views
Why do I get “The initial snapshot for publication is not yet available.”?
We are using Transactional Replications with updatable subscriptions. 1 publisher, 1 subscriber.
SQL Replication started encountering a constraint error on 3/6 at 10AM because people at two different ...
2
votes
0answers
92 views
SQL Server : Transactional Replication Filter By Computed Column
There is a database that contains records for multiple groups of people. These records do not contain a column indicating which group the record is "owned" by (very frustrating). I need to setup ...
2
votes
0answers
153 views
Transactional Replication Error adding new subscription (null) article
When attempting to add a new subscription to an existing Transactional publication on 2008. It is all configured on 1 server as it is for Pre-Production testing.
I get the following error when ...
2
votes
0answers
34 views
List of changes required to upgrade scripts after starting to use replication in SQL Server
We have recently setup transactional replication on our test and production databases. As part of that change, we've had to make changes to how we create upgrade scripts as well. The goal is to make ...
1
vote
0answers
206 views
SQL Server Troubleshooting Replication and Long-Running fn_dblog query
I am trying to get (pull) Transactional Replication working again for a subscriber.
Currently, in Replication Monitor I am seeing messages in the Publisher to Distributor tab and the Distributor to ...
1
vote
0answers
43 views
dropping and adding subscription only picking up new article on some subscribers
I have used the following script to drop aand re-add a table from a subscription so I could move replace the ntext fields with nvarchar(max) columns. the script worked fine, but when I ran the ...
1
vote
0answers
68 views
Distribution Agent running but subscription does not exist?
I have an issue where in my replication topology, the distribution agent is running, and says there are no commands to distribute. However, checking the undistributed commands, it shows there are a ...
1
vote
0answers
119 views
Transactional Replication Snapshots causing serious locking after 2012 upgrade
I am experiencing serious locking when adding new articles to an existing transactional replication publication, which is hanging the website. This is the first time I have attempted this since I ...
0
votes
0answers
6 views
Restore of Replicated Database fails with “Cannot drop the table <table name> because it is being used for replication.”
published database restoration failed once you setup transactional Replication using system Store procedures. Few work around to this problem is restore with KEEP_replication option and than drop the ...
0
votes
0answers
22 views
Ghost replication jobs in replication monitor
Has anyone ever seen and know the cause of this issue? We have transactional replication with pull subscriptions. At 2am this morning it appeared that the job (that runs every 15 minutes) stalled out. ...
