Questions tagged [transactional-replication]
32 questions
2
votes
1 answer
If a SQL Server Replication Distributor and Subscriber are on the same server, should a PUSH or PULL subsciption be used?
Thanks in advance for any help.
I'm setting up a new Microsoft SQL Server replication and I have the Distributor and Subscriber running on the same server. The Publisher is on a remote server (as it is a production database and MS recommends that…
![](../../users/profiles/60645.webp)
userx
- 133
- 1
- 4
2
votes
1 answer
Adding new article to transactional replication gives error at subscriber
I have a updatable transactional replication set with SQL Server 2008. Everything is working fine.
I added a new table to the existing publication through sp_addarticle followed by sp_addsubscription. After that I ran the Snapshot Agent. The…
user56160
1
vote
0 answers
SQL Server distribution agent cleanup job causes blocking
I am using SQL Server transactional replication, and have noticed that on a daily basis all of the publications for a distributor are being blocked when the distribution agent cleanup job executes. I have seen this block persist for up to 2 hours. …
![](../../users/profiles/114770.webp)
Sean Fitzgerald
- 11
- 3
1
vote
1 answer
Is replication less resource intensive than high frequency reads?
I am beginning the development of a new web application which needs to be designed to scale from the word go.
I am looking into database replication and the concept of master/slave replication (or publisher/subscriber - I think these are the same…
![](../../users/profiles/61103.webp)
Lewray
- 143
- 1
- 1
- 6
1
vote
2 answers
How to move the files of a replicated database (SQL Server 2008 R2) to a different drive
I would appreciate if someone could help me with the following problem:
We use two SQL Server 2008 R2 databases under transactional replication: transactional publication with updatable subscriptions. because we run out of disk space we need to move…
![](../../users/profiles/112137.webp)
ileon
- 113
- 5
1
vote
1 answer
sql server peer to peer replication - have the agents running as NT AUTHORITY\NETWORK SERVICE?
On a test rig, I'm trying to get SQL Server 2005 peer to peer (transactional) replication working, with the replication agents running under the NT AUTHORITY\NETWORK SERVICE account.
Before this I setup a peer to peer replication with the agents…
![](../../users/profiles/55396.webp)
simon
- 714
- 7
- 20
1
vote
2 answers
Any reason to replicate SQL Server database for reporting?
We are upgrading our ERP application to run on SQL Server 2008 R2. It currently runs as a file-based system in it's own Server 2008 virtual machine. SQL Server will be installed into that VM.
We have a separate virtual machine (on the same physical…
![](../../users/profiles/70209.webp)
John Galt
- 67
- 5
1
vote
1 answer
SQL Server 2008 SP1 Transactional Replication of a Partitioned Table Generates StackDump
I have a partitioned table that is published for transactional replication. The SWITCH operations on this table appears to replicated to the subscriber even though the options to allow_partition_switch = 1 and replicate_partition_switch = 0 on the…
![](../../users/profiles/61423.webp)
electricsk8
- 65
- 5
1
vote
1 answer
Monitor SQL replication publishers from subscriber
I have transactional replication with many publishers(50+) and one central subscriber(data collecting).
Is there some way(feature of SQL server, 3th party tool) how to monitor all publications from one point ideally from central…
![](../../users/profiles/24822.webp)
drizzt
- 84
- 3
- 10
1
vote
1 answer
Can you use a relatively expensive filter on transactional replication?
I'm trying to replicate (transactional, push) a relatively small table (50K rows), subject to several different filters, which are rather expensive (each taking at least an hour long to complete, involving a join with a table having 4 billion rows…
![](../../users/profiles/35961.webp)
user35961
- 121
- 3
1
vote
1 answer
SQL Server 2008 - Performance impact of transactional replication?
I'm planning to set up transactional replication for a 100Gb SQL Server 2008 database. I have the distributor and publisher on the same server, and am using push subscription.
Should there be a performance impact on my publisher server when it…
![](../../users/profiles/69428.webp)
cxfx
- 135
- 1
- 6
1
vote
1 answer
SQL Server - VMWare Install - Transactional Replication causing 100% CPU
I am having severe trouble with a SQL Server - in particular, with transactional replication.
We used to have a Windows 2003 physical machine, with SQL 2000. We call this “WebDB”
The server was located in a datacenter, and we connected to it over…
![](../../users/profiles/14846.webp)
alex
- 1,710
- 15
- 43
- 63
1
vote
1 answer
Table modifications while running db replication (MS SQL 2008)
I'm running SQL Server 2008 Std with a database that is being published in a "Transactional Publication" to a single subscriber.
We are unable to make any changes to the tables on the publisher without getting the "cannot modify table because it is…
![](../../users/profiles/6463.webp)
typemismatch
- 205
- 3
- 9
0
votes
2 answers
SQL Transactional Replication snapshot not applying
I'm using SQL Transactional Replication with pull subscriptions to replicate databases (hosting their own distribution database) from several servers across a VPN to a central server. I've got the first 2 databases working fine but the 3rd one is…
dmch2
0
votes
1 answer
SQL Server - Firewall Blocking Replication Even Though Port 1433 is Allowed
I have two servers, Server 1 and Server 2, both are stand-alone, Windows Server 2016 with SQL Server 2017 using default instance. They are not members of a domain, and connected over a VPN (using Neorouter).
I am trying to set up replication using a…
![](../../users/profiles/166127.webp)
mharran
- 1
- 1