We use a cloud-based SAAS provider as one of our line-of-business applications. An on-site SQL Server 2008 R2 instance in our DMZ is a transactional replication subscriber to a number of publications ...

I'm looking at Peer-to-Peer Transactional Replication and it looks like a perfect fit for my requirements, but there's one unclear part - load balancing (see picture below).
How it is implemented in ...

According to an old MSDN article (from the SQL Server 2008 R2 era), Microsoft SQL Server transactional replication subscribers need to be within two versions of the publisher. Does this hold true for ...

this may be a simple question for most but I am a bit confused and could use guidance, I am not a DBA, however I need to present out case for servers to our DBA's
I am looking to set up replication ...

Has anyone seen a domain Group Policy stop a transactional replication snapshot from being configured and executed "A required privilege is not held by the client".
To cut a long story short... I am ...

i have Publisher server with one transactional replication on it, one publication with two articles( Microsoft Navision tables), there are 4 servers connected like subscribers and the replication is ...

we have the same question here.
However, that does not answer my question below.
I'm using SQL Server 2012 and trying to implement transactional replication. I'm using the system stored procedures to ...

Often, I will add a single article to an existing transactional replication publication. I then start the snapshot agent to copy the new article and it's data over to the subscriber. Most of the time, ...

I have SQL Server 2012 Enterprise edition, transactional replication. many servers, many DBs.
This morning I come to the office and been told the latency on some databases was about 30 min behind.
I ...

I am on the publishing server trying to add a new subscriber that is on a different domain. We have a trust between the domains and I can connect to the subscriber using sms on the publishing server ...

** This was previously asked on Stackoverflow - I removed it from there and recreated here **
I have an issue with SQL Server Transactional Replication. My topology is as follows (and this cannot be ...

Summary
We were contracted to build a "Hot-Standby" for a company which keep their data in the cloud. The through-put is relatively low. Database availability/accuracy is a matter of life or death. ...

I have a situation where client wants to change their domain name of servers hosting SQL Servers(e.g. from AB to CD). I have a transactional replication with updatable subscription configured with 1 ...

My transaction replication works such that, to curb data growth, every day articles in publishers are purged but this purging of data is not replicated on to the subscriber. So at any point of time my ...

I am planning to implement a solution solution to create a separate database for reporting purposes (read only). I thought of implementing transactional replication to solve this problem, however I ...

We have a database (SQL Server 2008r2) that is being transactionally replicated, namely tables, sprocs, views, indexed views and UDFs only, to another server (SQL Server 2014) as part of a cautious ...

When using Transaction Replication, are there any restrictions around selecting data from the subscriber whilst transactions are being applied to it?
i.e. can selects be made against tables to which ...

I have the following situation:
SQL server 2008 R2 SP2
I have both the Distribution and Subscription database in this server.
LogReader agent and Distribution agent are running in continuous mode
the ...

I was hoping to get some help with a SQL Server 2012 transactional replication scenario - or maybe just my understanding of where permissions are stored in SQL server. If I change a users permissions ...