Questions tagged [transactional-replication]

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

Filter by
Sorted by
Tagged with
1
vote
1answer
1k views

Replication on Always On

I have two SQL Servers 2014 Enterprise Edition (SERVER A, and SERVER B) designed for Always On Availability Group. There are 5 databases in the AG. I have been told that we need to replicate one of ...
4
votes
1answer
96 views

Restoring data into a replicated table after failed purge process

We have a monthly purge process that purges data from a few tables using a somewhat complex SSIS package. Up until this time everything is running smooth and fine without any issues. However, if ...
2
votes
3answers
5k views

SQL Server - Linked Server error - Could not connect to server XYZ because

Server being used: SQL Server 2012 SP3 I just received a strange error (strange because it worked earlier) could not connect to server LNK_SRV because sa is not defined as a remote login Not sure ...
0
votes
0answers
2k views

SQL Server replication issue - table not updating

I have a transactional replication publication from the primary server (SQL Server 2008 R2, with the DB in 2000 compatibility) to a read-only copy used for reporting/spreadsheets/etc. Replication is ...
0
votes
0answers
79 views

Where to find documentation about the log reader procedures?

From the replication monitor in sql server transactional replication, when I have a look at what has been replicated, from publisher to the distributor, I get the following picture: It does not show ...
1
vote
1answer
742 views

Why my transaction has not been replicated? What was the transaction sequence number?

I have been troubleshooting a replication problem, according to the picture below: with reference to the picture above, the bit that says Sessions of the distribution agent I can get using the ...
1
vote
0answers
841 views

Error in skipping command in transactional replication in SQL Server 2012

My transactional replication is failing continuously. I am trying to skip the command but not able to do that. Below are the steps which I performed. 1) use distribution select * from ...
4
votes
1answer
3k views

How can I determine the last synchronization time for a SQL Server replication subscription?

I'm using SQL Server replication to mirror a few tables from an on-premises SQL Server instance to an Azure SQL database. We had an issue where the replication encountered an error, and we incorrectly ...
4
votes
1answer
3k views

Can not drop table due to replication error, though table is not being published

I am attempting to drop a table in a database that is a publisher. The table in question is not being published. The error I get is: Msg 15021, Level 16, State 1, Procedure sp_MStran_ddlrepl, Line 14 ...
1
vote
1answer
472 views

Re-initializing a transactional replication wihch was initially synced from backup

I have a transactional replication which was initially synced from backup. Now I need to add a new table which is really big so we have decided to backup and restore a fresh copy of the db to ...
0
votes
1answer
138 views

Keeping my database updated every 30 minutes using Log files

I have a situation where I get a full nightly backup and trans log backup every 30minutes starts at 7:00 am ends at 2:00 am. I need to restore them every 30 minutes into a database and replicate this ...
4
votes
1answer
921 views

SQL Server Transactional Replication snapshot delivery loop

I have configured transactional replication from SQL Server 2008 to SQL Server 2014. And everything is OK, except one thing: after the initial snapshot is delivered to subscriber, distribution agent ...
4
votes
1answer
2k views

Pausing AlwaysOn Availability Group replication for failover

We are currently implementing a new software package which has one part of its system using database replication (but doesn't support AlwaysOn Availability Groups) replicate from another database that ...
2
votes
1answer
2k views

In sql server replication when stored procedures get replicated, it creates MSins, MSdel and MSupd procedures for all tables in the database

I have single sql instance and I have created replication of my database in same instance. Now when I have inserted data into the tables I found out that replication of insert stored procedure is ...
1
vote
0answers
41 views

How can we upgrade SQL Server 2008 R2 to 2012 with replication

We want to upgrade from SQL Server 2008 R2 to 2012, current production environment having multiple publishers and subscribers.
2
votes
3answers
2k views

Getting the error "Can't rename a table because it is published for replication" while it's not

I'm trying to rename a table, but I'm getting the error : "cannot rename the table because it is published for replication". But this table is not among the published articles. I'm suspecting it's ...
0
votes
1answer
132 views

Two-way replication between SQL Server 2005 and SQL Server 2008

We currently have a SQL Server 2008 and SQL Server 2005 participating in one-way transactional replication of a single database. If possible we would like to set this up as a Two-way replication. ...
1
vote
0answers
39 views

Options for transferring/transforming from one database to another?

We have a hosted instance of intersystems-cache. There is an aggregate log that is near 600 million rows and is rather abstract and complicated. I am planning to parse this log and store more ...
3
votes
1answer
1k views

High number of undistributed commands after a "An existing connection was forcibly closed by the remote host" event

For the lasts days I'm getting a high undistributed commands value in the replication monitor. Restarting the Server Agent solve the problem (momentarily) but after few hours starts again. Even when ...
1
vote
1answer
656 views

Unexpected growth Transaction log file 100 GB which is part of Transactional Replication

I configured transactional replication on SQL Server 2014/Windows Server 2012. The database size is only 30 MB, but log file size is 100 GB. Every day, the log file size is growing 5-7 GB. Database ...
0
votes
1answer
225 views

Transactional Replication - Publications with same Name on the same Domain

I'm using Transactional Replication and I've currently got three 2008r2 instances Publisher/Distributor/Subscriber. I need to put three more 2008r2 instances on the same domain in the exact same ...
3
votes
1answer
80 views

Replacing a SQL server involved in Transactional Replication with least amount of downtime

I have a physical server that the company wants to move to virtual - currently, it is a subscriber in Transactional Replication on a very large database. What would be the best way to minimize the ...
-1
votes
1answer
177 views

Implementing Replication on existing database

I'm a developer but I need to implement replication on an existing database. I'm a bit familiar with replication and I already was able to implement it but I had a few issues and the two most notable ...
1
vote
1answer
631 views

Unable to Generate Scripts for Publications

Version is SQL 2008 R2 Enterprise I am attempting to document our replication configuration. Replication is running and working fine: In SSMS I right click on a publication and select Generate ...
0
votes
4answers
1k views

Add article to transaction replication without generating a snapshot at all

I have a transaction replication and the subscription was synced from snapshot years ago. Now I have a new table that needs to be added to the replication. Problem is the table is close to a TB and ...
1
vote
2answers
7k views

Replication between two different SQL Server versions

We have mirroring configured (transactional replication) in our primary and secondary SQL Servers, which are running on Windows 2008 R2 SP2 OS with 2008 R2 SP3 as the SQL Server version. If we first ...
0
votes
1answer
45 views

Move database without replication taking new snapshot

We are upgrading a physical server we have SQL installed on at work, and I need to move SQL to a new machine, but I need to do it with minimum downtime. I have the new virtual server already ...
0
votes
1answer
4k views

Unable to shrink log file due to transactional replication

I have a transactional replication configured as per below: ServerA.DBA (pub) --> ServerB.DBB (Sub) ServerB.DBB (pub1) --> ServerC.DBC (Sub) ServerB.DBB (pub2) --> ServerD.DBD (Sub) ...
1
vote
3answers
3k views

Rows deleted in the subscriber - what to do? - SQL Server Transactional Replication

Someone has delete by mistake a row of a table in the subscribed server/database. I am getting the following error message: The row was not found at the Subscriber when applying the replicated (...
0
votes
2answers
328 views

SQL Server Transaction Replication on different versions of Windows

Currently we use SQL Server 2014 Transaction Replication in Windows Server 2012 (both Publisher and Subscriber are on different servers with the same operating system). We need to add a new ...
0
votes
2answers
80 views

Need best way to to avoid Replication Re-Configuration

I need the best way for the scenario because of which I got irritated. I do have 3 Production database Servers Srv1, Srv2 and Srv3. I configure transactional replication among these servers. Srv1 is ...
1
vote
1answer
1k views

SQL Server replication error "profile name is not valid"

Today I started getting the below error message on one of the distribution agent. The publication has one push and on pull subscription. The error appeared on the push subscription only. The ...
0
votes
2answers
97 views

SQL Server transactional replication process and error [closed]

I need to setup a replication. Which replication is better if I want to keep my data updated in the second server as soon as new data is pushed into the primary server. I tried setting up by ...
0
votes
1answer
624 views

SQL Server 2012 Replication Backup and Restore [closed]

I am using SQL Server 2012. We have setup a replication using 'transactional with queued updating'. If the publisher database crashes and some records in the subscriber database have not been ...
2
votes
0answers
66 views

Migrating a Replicated Database from one SQLServer 2012 instance to another

We are working on a migration plan from old hardware to new hardware, these are SQL 2012 servers. A couple of the databases heavily use transaction replication so I'm trying to avoid recreating and re-...
2
votes
0answers
215 views

How to mirror a replicated database

Forgive me if this question has already been asked - I've hunted around, but can't find something that matches my situation. Say I have my Principle server (DB1), with a database Mir1. I set up ...
1
vote
1answer
1k views

Can you remove the redirect from transactional replication from an HADR publisher?

We have a pair of SQL Server 2012 availability groups that we have set up transactional replication to a 2012 distributor and subscriber. We are moving databases for the (synchronized) secondary ...
0
votes
2answers
1k views

Transactional Replication: Cannot continue the execution because the session is in the kill state

I have Transactional replication in one environment, I disable existing one and configuring it again, But While initialization in am getting following error Distributor Subsystem: Cannot continue ...
1
vote
1answer
411 views

Replication To Enterprise & Standard Edition subscribers

We have a defined and well running transactional replication process. One publisher, one distributor (on separate servers) and several subscribers (pull). All servers have Enterprise Edition. Latency ...
1
vote
1answer
108 views

SQL Server replication with subscriber doesn't know about the publisher

I have a case where many SQL Server instances need to be merged and centralized in one master database. This needs to be near real-time solution. After looking around in Google, I've found that ...
2
votes
1answer
148 views

t-sql or powershell to return currently-configured snapshot folder for transactional replication SQL 2012

I'm working on a script to iterate through all the snapshot folders and do some basic find and replace of the ANSI_PADDING OFF bug and replace it with SET ANSI_PADDING ON. I'd like to be able to ...
1
vote
0answers
219 views

Start up replication after AlwaysOn failover

I have a 4 node AlwaysOn configuration with 2 nodes at the main site, 2 at the DR site and a FSW. The 2 main site nodes are configured for Automatic/Synchronous fail-over, the 2 DR nodes are Manual/...
1
vote
1answer
280 views

How can I find out that a publication has "replicated schema changes" enabled?

Where can I find out (preferably using T-SQL) within a published databases, if it would replicate the schema changes? here is how to create a publication This topic describes how to create a ...
14
votes
1answer
17k views

Length of LOB data (2135980) to be replicated exceeds configured maximum 65536

I am getting the replication error 'Length of LOB data (2135980) to be replicated exceeds configured maximum 65536'. sp_configure was previously applied to set it to max value (-1) and a query on ...
0
votes
1answer
592 views

SQL Server Replication using Static IP

I'm trying to setup transaction replication using a static IP. I have 2 servers: one has a static IP but other one does not. In this case can I do replication. I am able to connect to the static IP ...
4
votes
2answers
6k views

SQL Server Database Restore with Replication

Forgive me if this sounds angry/rant-y, but it kinda is. High Level Overview: How can I restore a SQL DB that's involved in transactional replication with 5 pub/subs, without having to drop, create, ...
1
vote
1answer
286 views

Subscribing to individual articles within a publication

Can we filter the articles in the publication (which has few subscribers already) while adding the new subscriber? look at the last statement ‘Subscribing to individual articles within a publication ...
1
vote
0answers
264 views

Londiste PostgreSQL replication over slow connection

I've got a setup with a single master and two branches. Unfortunately, the network connection to the master is over a 3G wireless network. It's not terribly slow, but the latency is pretty high. ...
0
votes
1answer
2k views

Sql Server Replication requires the actual server name to make a connection to the server

I get the following message when I want to create a Remote Distributor. First i delete my whole configuration of replication then after i take a first step to create new replication and i get below ...
2
votes
2answers
93 views

Can Records be Replicated in an Availability Group Out of Sequence?

A data warehouse ETL process is querying a read-only secondary in an availability group. The ETL process queries a single table incrementally using datetime range criteria of a minute and read ...

1
3 4
5
6 7
10