The transactional-replication tag has no wiki summary.
0
votes
1answer
25 views
distribution.dbo.MSdistribution_history comments explanation
The comment column of distributor.dbo.MSdistribution_history contains comments such as
<stats state="2" fetch="11554" wait="214007" cmds="17898546" callstogetreplcmds="106880">
...
0
votes
1answer
94 views
SQL Server 2005 Transactional Replication
I am in the process of replicating my companies databases from SQL Server 2005 to SQL Server 2012 using Transactional Replication. When complete we will be running preliminary tests on the database, ...
3
votes
1answer
262 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 ...
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 ...
3
votes
2answers
268 views
SQL Server 2008 R2 Transactional Replication “Cannot insert explicit value for identity column…”
Right now I'm having an "identity crisis" with transactional replication in SQL Server 2008 R2. The database is running in compatibility 90. There's a table that has an identity column and won't ...
5
votes
1answer
55 views
Transactional replication creating a fixup index that's sleeping, but blocking other processes
I've just migrated my ERP database server from SQL Server 2000 to SQL Server 2008 R2 (both Enterprise Edition) and that migration went fairly smoothly.
However, now that I'm trying to recreate ...
4
votes
2answers
73 views
Transactional Replication Concerns
We are debating an architecture that employs sql server 2012 and transaction replication. Idea is to offload reporting activity to a secondary server and have the ability to include/exclude what is ...
0
votes
1answer
25 views
Subscriber database to be in sync using Distributor
I have database D1 as a publisher, D2 as a subscriber and they are using Distributor 'DIST' which is reside on the subscriber side. Both D1 and D2 database having DR databases called DR1 and DR2. I ...
2
votes
2answers
101 views
Bandwidth comparison between log shipping and transactional replication
Which technique uses more network bandwidth:
Log shipping
Transactional Replication
Can some one share any benchmarks for the same ?
What would be the Memory and I/O impact on the Primary server ...
-1
votes
2answers
47 views
Restore Replicated Database on Different Server
I want to Restore the replicated database on different server and resume the replication from there. I have distributor and subscriber running on the same server. when i restore my replicated database ...
0
votes
0answers
23 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. ...
3
votes
2answers
142 views
Cleaning up transaction replication del/ins/upd stored procedures?
I'm referring to the ones that start with:
dbo.sp_MSdel...
dbo.sp_MSins...
dbo.sp_MSupd...
I've noticed they are not removed when I run exec sp_dropsubscription on the Publisher then run ...
5
votes
3answers
175 views
What type of SQL Server Replication fits our scenario? Merge or Transactional?
Background
In our current setup, we have a single SQL Server 2005 instance on our remotely hosted web server. We additionally have another (non-MSSQL) database which we use for our POS system, which ...
1
vote
1answer
84 views
2012 Transactional replication not delivering new articles
I have added a new article to an existing push publication with the following code
sp_addarticle @publication='statics', article='FlightBaggageMarkup_tbl',source_object='FlightBaggageMarkup_tbl'
...
2
votes
0answers
148 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 ...
1
vote
1answer
120 views
Snapshot not picking up new articles in SQL Server 2012 transaction replication when added through script
I am trying to add new articles to an existing publication in SQL Server 2012.
I am adding the article to the publication with the syntax
--add the table into the correct publication
sp_addarticle ...
3
votes
1answer
81 views
Replication between SQL Server 2005 and Azure database
Is it possible to set up transitional replication between a SQL Server 2005 and a SQL Azure database?
My server is nearing end of life and I would rather migrate to a cloud infrastructure instead of ...
3
votes
1answer
58 views
Cannot delete publication
When attempting to delete a publication, I am getting the error cannot drop publication 'XX' cannot drop article 'XX'.
The subscription has been deleted at the subscriber. Any ideas on how I can ...
1
vote
0answers
209 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 ...
5
votes
1answer
275 views
Transactional Replication not sending all commands
I have a transactional replication topology as follows:
NY Publication Database same server holds distributor
NY - Subscriber
LON - Subscriber
HK - Subscriber
We are using bog standard, one-way ...
1
vote
0answers
44 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
1answer
60 views
Ensuring Only Fresh Data Gets Accessed on SQL Server 2008/2012 Replication For Reads
I am designing a scale out solution for a globally dispersed company that has data centers on all continents. Over 10,000 servers report to a SQL Server cluster in Los Angeles, and also query it to ...
2
votes
0answers
93 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
1answer
138 views
What causes Transactional SQL Server Replication to need to be rebuilt/re-initialised
In a company I've recently joined we have two SQL Server instances, connected via transactional replication. I'm a developer and hadn't really come across SQL replication before so am a complete ...
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 ...
4
votes
1answer
334 views
How to restore replication after server crash
We had two databases on one SQL Server 2005 instance with transactional replication between them (3 tables as articles). This server acted both as publisher and distributor.
Then the RAID on the ...
1
vote
0answers
121 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 ...
3
votes
1answer
152 views
What is the difference between 'two way transactional replication' and 'peer to peer replication'?
Can someone explain in detail the exact differences between 2 way transactional replication and peer to peer replication?
2
votes
0answers
155 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 ...
1
vote
1answer
148 views
Replication Error when adding small table as new article
I have just added a small (200 row) table to my current replication which has now broken my entire replication scenario as it seems to have broken the Log reader. The 2 tables are unrelated.
I am ...
3
votes
1answer
381 views
transactional replication, failing with communication link failure half way through bcp
I am trying to replicate to a 4th subscriber on a remote site. 3 subscribers work fine locally. the other difference is this is a 2012 subscriber from a 2008 r2 publisher and remote distributor.
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 ...
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 ...
3
votes
1answer
242 views
How to break out of error loop in transactional replication?
I was running some simple tests on a publisher and subscriber on the same instance:
I inserted 50,000 rows into a published article and the data was
correctly pushed to the subscriber.
I ...
4
votes
2answers
233 views
SQL Server : Transactional Replication Computed Column
I am a subscriber to a transactional replication subscription. I have no control over the publisher.
I have read the following article about schema changes to the publication database:
Make Schema ...
2
votes
2answers
163 views
SQL Replication Commands
I'm trying to figure out how i can get the number of commands over the last day for a sql server replication. Transactional / Snapshot / Merge.
I really want to be able to calculate the average ...
1
vote
1answer
127 views
transactional Replication of millions of updates
I have standard transactional replication setup from 2005 to 4 2008 subscribers. One of the tables that is replicated is updated several times from an agent job resulting in 6 million updates ...
