The automated distribution of transactional changes from a publishing database to one or more subscriber databases.

learn more… | top users | synonyms

5
votes
1answer
218 views

missing indexes on distributor database

Looking for missing indexes on my distributor databases, I surprisingly find too many. the tables that need to be indexed are generally 3: MSrepl_commands MSlogreader_history ...
0
votes
1answer
35 views

Multiple Replication Type Publications on Single DB

I have 2x critical DB's which until recently; I was reporting on as well as using in production. DB1 is a Vendor DB and DB2 an in-house DB used in conjunction with DB1 for custom tables and views (as ...
0
votes
0answers
64 views

Is it a good idea to disable lock escalation while adding new calculated columns to a table?

Having in mind that I can add computed columns to the subscription tables according to this link: SQL Server : Transactional Replication Computed Column Is it a good idea to disable lock escalation ...
0
votes
0answers
30 views

Attach replicated .MDF file with/without log after OS reinstalled

I have SQL Server 2014 DataCenter RTM Version on Windows 2012 Standard Edition for about 2 months and had migrated a database from SQL Server 2008 R2. The database had transactional replication was ...
0
votes
0answers
21 views

Replication - Daylight Saving time related issues

We had our replication subscribers complain when the clocks moved forward from 2 am to 3 am Pacific Time a few days back. And we noticed subscribers received delayed data. Our publications complained ...
2
votes
1answer
204 views

Availability Groups and Transactional Replication

My client has a setup as shown below. AG Group A ---------> Server A (DB--> A) ----> Server B ( DB--> A) Transactional Rep --> Server A ( DB-->A ) ---> Server C ( DB--> B) AG ...
1
vote
2answers
37 views

how to fix this replication alert?

Can anyone help me with the replication..when I was trying to add a new article on the publisher..I got the below alert.. I checked the subscriber the table wasn't there..
0
votes
0answers
12 views

I can't create a transactional replication

I have two databases identically in two SQL Server 2014 instances. The problem is as follows. I can access from server A to B, I can create the publication in server A and access to that publication ...
0
votes
0answers
38 views

Transactional replication with push subscriptions (No errors but not working)

I have a very simple replication process set up. SQL Server 2005 One publisher, one distributor and two subscriptions Subscriptions are push I created the snapshot, it reinitialized to the ...
2
votes
2answers
1k 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 @...
2
votes
1answer
677 views

Replication monitoring refresher for distribution job affecting performance

I have a performance problem due to a sql agent job executing dbo.sp_replmonitorrefreshjob. The environment is a 2 node Cluster with SQL Server 2005 SP2 and with transaction replication. The OS ...
2
votes
1answer
31 views

Dropping historic Partitions that are no longer required while in P2P replication

The Company I work for has a set of databases (largest just below 1Tb) on different servers - 2 in the US, 2 in Europe. We run full peer-to-peer replication per database between the 4 nodes - so they ...
1
vote
1answer
27 views

Sql server 2012 replication scenario

I am under a really specific scenario. I have a database on a customer's site and a website on Azure cloud that connects to that database. User is on a 50mbit fiber but this is obviously slow. So I ...
2
votes
1answer
61 views

Will replication commands build up if the distribution agent is stopped?

Assuming I have a transactional publication with a single article. There is a Publisher (PUB1) with two Subscribers (SUB1 AND SUB2), and a separate Distributor (DIST1) box is used. I would like to ...
3
votes
1answer
55 views

Identity management in Transaction replication with updatable subscription

I have migrated my publisher DB to new server yesterday. For migration what I did was removed subscriptions and publication completely backed up DB on which publication was configured restored DB ...
0
votes
0answers
28 views

Creating Replication from scratch and do not want to change indexes or Procedures on Subscriber Servers

i have a situation here I have replication from Server A (2008R2) Pub to B(2012) Sub for few databases.. I have 10 non-Clust-Indexes on X table on DB1 on A Server and non-Clust-Indexes 100 X ...
1
vote
1answer
35 views

SQL Server transactional replication distributor

If I have a SQL Server 2012, with two databases, both publishers, replicating to a bunch of subscribers. Can each database go through a different distributor? Is the publisher the server or the ...
1
vote
0answers
31 views

How to setup filtered transactional replication

Configuration/Setup PUBLISHER: SQL Server at branch premises having only specific branch data (ex: branch ID 135) SUBSCRIBER: SQL Server (live at data center) used by application having data for all ...
3
votes
1answer
79 views

Transactional Replication issues

I have a question, I am managing 2 SQL servers is Master Server (Publisher + Distributor) is Client Server (Subscriber) The client is basically owned by a client who is buying data from us. Both ...
0
votes
0answers
42 views

SQL server is replicating to wrong subscriber

I have a publication which is intended to push data to a subscriber over the internet from a remote server to our onsite local subscriber but it ends up on a wrong subscriber.Here is the scenario: ...
0
votes
0answers
61 views

SQL Server Transactional Replication Not Being Created

I'm trying to set up transactional replication between two instances of SQL Server 2014. The publisher is a named instance running SQL Server 2014 Standard Edition. The subscriber is an instance of ...
3
votes
0answers
247 views

How to PUSH data between a Local DB Server to Cloud DB Server?

I have an implementation doubt regarding replicating data between SQL Server 2014 database servers (Replicating data from Local Premises SQL Server to Cloud DB Server, which are not in same domain or ...
35
votes
4answers
22k views

Clustering vs. transactional replication vs. availability groups

Assuming you need to make sure your application that relies on SQL Server 2012 as its database backend is available around the clock, even if one server machine fails. As a developer and not a DBA, I ...
0
votes
1answer
54 views

SQL Server 2012 Transactional Replication - twin subscriptions on same machine

Server A publishes Pub1, Server B subscribes to Pub1. Server A and Server B are both SQL Server 2012 Standard Edition, default instances. When I use Replication Monitor to drop-in a Tracer Token, ...
1
vote
1answer
2k views

Replication Snapshot folder not cleaning up

The job that I thought was supposed to clean up old snapshots isn't removing the old files. The retention is left at default yet there are snapshots months old which remain. The job runs as the ...
2
votes
2answers
143 views

PostgreSQL Server: Many-to-One replication / Transactional Replication

I have several PostgreSQL DBs in different geographical locations (local sites). Each local site DB have the same schema, but unique data. For example, Take a table with columns: Site_ID, ...
0
votes
0answers
25 views

Optimizing the UPDATE For MSdistribution_history

One of the major headaches in my replication is the following MS procedure (over 55% usage), updating the distribution history. It currently has one index on columns agent_id, timestamp, runstatus, ...
1
vote
1answer
119 views

Will transactional replication break if there is a heavy update/delete query run on the publisher DB

For these specifications: Publisher: (prod OLTP DB server) SQL Server 2005, database size : 220 GB also acts as the distributor Subscriber (Prod reporting DB server): SQL Server 2005, DB gets ...
0
votes
0answers
35 views

Replication jobs using proxy

I wanted to use a proxy account for replication agent checkup job on SQL Server 2012. This proxy works for other jobs. I got the following error: Executed as user: SQLUserID. Only members of the ...
1
vote
0answers
145 views

SQL Server Transactional Replication Distribution Database not keeping up

We have following setup at the moment: 8 Cluster servers (SQL Server 2012 Standard Edition) talking to 2,000 store servers in the field via Merge Replication. The 8 servers are replicating to a ...
6
votes
3answers
3k views

Creating a read only replica of SQL Server database for reports

I've faced a problem when my .Net web application is running slow, even when I've optimized all queries. As it turned out another developer, who is making reports runs a bunch of non optimized queries ...
1
vote
0answers
41 views

Trans Replication and Always On Listener Group Name

We have currently (SQL Server 2012 STD) which is continuously replicating from 8 different database server for reporting purpose to server which is on SQL 2008R2. We would like to create an Always On ...
3
votes
2answers
65 views

Replication DB move

I have 2TB of DB involved in SQL Server transactional replication. I want to move publisher DB files to a newer disk with minimum amount of downtime and without breaking replication. Please let me ...
1
vote
1answer
180 views

SQL Server Change Tracking and Replication

My colleagues and I are working on a solution revolving around change tracking… Our goal is to use SQL Server change tracking to track changes to be pushed to another non-SQL system. Our database is ...
1
vote
3answers
220 views

Replication taking too much time between requests

We are using transactional replication in SQL Server 2014 with one master (publisher), 1 distributor (dedicated server), and 3 slaves (subscribers). All writes are made to master and reading is done ...
0
votes
1answer
89 views

SQL Server distributor server move

I need to move my distributor server to a brand new server without resnapshotting it. The scenario I have is similar to the one defined in below link. http://www.sqlservercentral.com/Forums/...
1
vote
4answers
114 views

Execute a script after transactional replication setup completes

We successfully set up transactional replication with 15 articles. After successful of article changes Done in subscriber, we need to execute ".SQL File" at subscriber database. Please help on this. ...
0
votes
0answers
12 views

Incremental snapshot in transactional replication [duplicate]

Is there a way to increment the snapshot at the distributor instead of reinitalizing the snapshot every time a new table is added/removed/altered? It is taking a lot of time to generate the snapshot. ...
3
votes
1answer
85 views

What about redundancy if distributor goes down?

I'm setting up load balancing, transactional replication and mirroring. However, what I actually thought might work from the beginning, making the system redudant doesn't actually work because a ...
0
votes
0answers
37 views

SQL Server : distribution agent error

In my transactional replication setup, the replication monitor keeps printing this message every 5 mins: Agent XYZ is retrying after an error. 35 retries attempted. See agent job history in the ...
3
votes
2answers
184 views

How to wait for SQL Server replication reinitialization via TSQL

We use transaction and push replication. Every night after the data import 2 replication targets are initialized with the following commands. USE [dbImport] -- Execute at the Publisher to ...
2
votes
2answers
67 views

Prevent SQL Server publisher from running out of disk space

I have an issue with transactional replication which leads to running out of disk space. The scenario is following. Database A is replicated to another computer via local distributor with command ...
1
vote
1answer
91 views

How to Properly shutdown and disassemble SQL Database Replication

While testing SQL Server Replication we setup Replication on our ERP Test DB from SQL Server Enterprise to SQL Server Standard. We have since got replication up-and-running on our Live database and ...
0
votes
0answers
103 views

Transactional Replication issue due to big Transaction Log in sql server 2008 r2

I want an answer of question and that would be highly appreciated Scenario: First of all i am an IT guy from Sports Field and using SQL Server 2008R2. I have 2 production servers server 1 and Server ...
1
vote
1answer
53 views

Temporarily removing replication from Publisher

Is it possible to temporarily remove Transactional Replication from a publisher database in order to allow a release to be executed against the database? If I stopped the log reader agent would I be ...
3
votes
0answers
126 views

transaction replication causing too many deadlocks after adding a indexed view - what to monitor in order to avoid this?

I have created the following indexed view and its clustered index: This view was created on a subscriber database and all the tables used in the view are constantly being written to through the ...
1
vote
1answer
95 views

how to find the name of the distributor server and publisher server from the subscriber server/subscriber database

Having in mind that I can add computed columns to the subscription tables according to this link: SQL Server : Transactional Replication Computed Column That I am already doing, and also adding ...
1
vote
0answers
44 views

How to manage old replication issue

Background We are using SQL Server 2008 and we had a merge replication configured (before i joined the company). After that they stopped using it and the didn't delete it and configured transactional ...
5
votes
1answer
960 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
1answer
637 views

Distributor latency - slow sp_MSget_repl_commands performance

One of our publishers is subscribed to by three subscribers, each subscriber is hosted on its own physical server. Two of those subscribers are 2008R2 and the third 2012. The 2012 subscriber is ...