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

learn more… | top users | synonyms

1
vote
0answers
25 views

Transactional Replication - Replication Order of Related Tables

** 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 ...
0
votes
1answer
24 views

How to restart the distributor agent of transactional replication?

After troubleshooting query time out error I would like to restart my distributor agent. So I go to my distributor server, in my distributor DB (called distribution_SA) I run the following query: ...
0
votes
1answer
22 views

The process is running and is waiting for a response from the server - transactional replication

I could not yet figure it out why one of my transaction replication subscription is constantly coming out with the following annoying message: The process is running and is waiting for a response ...
0
votes
1answer
33 views

transaction log restore

we have an external production database (maintained by another company) and we are trying to build an internal database that replicates the production database for reporting purposes (both ...
0
votes
1answer
68 views

Replication Madness

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. ...
1
vote
1answer
16 views

How to make distributor highly available in Always On Configuration

We have clients requested us to configure Always on with Replication. Microsoft does not support it. "The distributor should not be a host for any of the current (or intended) replicas of the ...
1
vote
1answer
40 views

Can you use CDC on a subscriber for transactional replicaiton [closed]

Is there a way with SQL Server to have a limited number of tables replicated to another server using transactional replication and then use CDC or Change Tracking ONLY in the server replicated to?
0
votes
1answer
46 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 ...
0
votes
0answers
89 views

SQL Server Replication Snapshot Agent login fails

I have setup TRANSACTIONAL REPLICATION from ServerA to ServerB ServerA = Primary Server = SQL Server 2008 R2 Enterprise ServerB = Secondary Server = SQL Server 2008 R2 Standard Edition. I ...
0
votes
2answers
61 views

Live Partial Table / column replication

I want to know if there is a way to achieve the following with SQL Server 2012 Enterprise Edition? I have Table A: on Server 1 with say 10 columns. Table A: | col1 | col2 | col3 | coln | col10 | ...
0
votes
1answer
53 views

Best way to transfer a few tables from reserve server to production

We have two MS SQL Servers (2012 Standard Edition on Windows 2012 Server) which are located in the same subnet. One is production server. Another is reserve server. Currently there is a ...
0
votes
0answers
42 views

SQL Server 2012 Replication Subsystem Increase Number of Working Threads

I am trying to create Transaction Replication (Push) between two servers, using a distribution database on a3rd server. Server 1 is SQL Server 2008, Server 2 is SQL Server 2012. The Distribution ...
0
votes
1answer
42 views

How to delay replication start

I'm creating a new publication for replication using the @allow_initialize_from_backup option to avoid the snapshot immediate creation and therefore locking all objects replicated on articles. The ...
2
votes
0answers
50 views

Domain name change of SQL servers involved in replication

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 ...
0
votes
0answers
102 views

Subscription fails with Incorrect syntax near '9'

In my Distributor To Subscriber History I get the following error: Command attempted: 9 (Transaction sequence number: 0x0018E94F0000207A006200000000, Command ID: 59) Error messages: ...
0
votes
1answer
20 views

How to recover from transaction replication failure?

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 ...
0
votes
2answers
32 views

Build replication from backup not publication source

I have an interesting scenario I am trying to find a solution to. We currently have the current setup. ProductionDatabase (publisher) is the publication for transnational replication to the ...
1
vote
1answer
43 views

Will Transactional Replication Work?

I have multiple site servers and a central server. Each has a Widget table with identical schema. There is currently a custom process that sends new Widget records from the site server that ...
0
votes
1answer
36 views

What is the best solution to implement to replicate a database, with a purging process is in place

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 ...
0
votes
0answers
17 views

adding article seems like hang (transcational replication - pull type)

Hi stackexchange friends, I'm in the midst setup replication (transactional - pull type) between 2 sql servers. sql1 = as publisher sql2 = as distributor & subscriber as well. I have done ...
1
vote
1answer
190 views

SQL Server Cross Domain Transcational Replication

Has anyone got any documentation for doing/implementing Cross Domain SQL Server 2012/2008R2/2008 transactional replication document or steps (with screenshot or without screenshot) Thanks for your ...
0
votes
2answers
292 views

Replication Blocks Code Deployment

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 ...
0
votes
0answers
141 views

Why doesn't this transactional replication post script work? (Works in SSMS and SQLCmd.exe)

I have created a script that creates any missing indexes on replicated indexed views. It gets the index definitions from the publisher (Linkedserver) and applies them to the subscriber. The script ...
2
votes
1answer
41 views

Reading from subscriber during Transactional Replication

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 ...
1
vote
1answer
141 views

distrb.exe & Logread.exe using huge SQL.txt file in C:\Users\sqlsrvacct\AppData\Local\Temp folder

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 ...
1
vote
2answers
118 views

Changing two publications at the same time causes deadlock in distribution database

I have transactional replication setup. Let's say three databases on server A replicate to corresponding three databases on Server B. The databases are identical (same structure for different ...
1
vote
1answer
433 views

Moving SQL server 2008 to a new Server with all DBs, replication and Jobs

We have to move our Production SQL server 2008 to a new Server (with latest SKU and more RAM). So we need to move all DBs, replications setup (publisher) and all jobs, means everything :). Also we ...
0
votes
1answer
122 views

How does the Distributor know you have seeded/initialized your Subscriber using a backup?

Im building my first transactional replication database for our Sharepoint team. The Publisher database is fairly large 330GB+ Because the Publisher database is in a different data center than the ...
2
votes
2answers
73 views

Replication between SQL Server 2005 - 2005

I'm hoping to get some help with a SQL Server 2005 replication issue. In short, in replication monitor, (On the Publisher), on the 'Distributor to Subscriber History' tab, I see two lines under ...
2
votes
1answer
161 views

Is it possible to replicate wide table in MS SQL?

The reason of me using sparse columns is to overcome limit of 1024 columns in a table (I know that generally it's not a good reason and there are downsides, but in my situation it's good option ...
3
votes
1answer
297 views

With SQL transactional replication, does changing user permissions to a table trigger a new snapshot?

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 ...
1
vote
0answers
72 views

SQL Server replication - recommendations for stability

We have two SQL Server 2008R2 Standard servers, and we've set up replication of a single database between them. The replication is about as simple as it can get - it's a transactional replication from ...
0
votes
0answers
172 views

SQL Server 2012 Transactional Replication Issue — Table Data not updating at subscriber

In my projects we configured Transactional Replication for my Database - one publisher, one distributor and two subscribers For 2nd subscriber every table data is updating properly But for 1st ...
3
votes
2answers
41 views

Is my Publisher database my actual source database or is it a new database?

I am setting up transactional replication for the first time and am working through my backup policies I need to set. Is my Publisher database my actual source database? Or is it a new database that ...
2
votes
2answers
467 views

Dropped the Distibution database before disabling publishing and distribution, how to proceed?

I'm setting up my first Distributor database on SQL Server 2012. I successfully created one and then wanted to blow it away and perform the task again just for practice. This was a brand new ...
1
vote
1answer
265 views

Transaction Replication Without Snapshot

So I have looked up many other people trying to get Transaction Replication Without Snapshot working and I'm stuck. I've followed what everyone has said so I don't know what I'm missing. Prod server ...
1
vote
0answers
70 views

Replication topology advice - central subscriber

I'm seeking guidance and advice about how to set up replication in MSSQL to deal with the following criteria. We have a central server hosted at a data center - this is where our web app is located. ...
2
votes
1answer
552 views

Could I realistically use SQL Server Express as a distributor database for transactional replication?

We have a group of users within my company that are running reports directly against our production database. It has gotten to the point where they are hammering it enough to cause performance issues ...
4
votes
1answer
116 views

SQL Server transaction replication ignores DML which does not change data

I have a transactional replication setup between the two servers and I noticed that if a run a statement similar to this: UPDATE mytable SET mycolumn = mycolumn the replication somehow knows to ...
2
votes
2answers
685 views

SQL Server Replication breaks up after doing DBCC CheckDB with Allow data loss on Primary

We have one way transactional replication enabled on SQL Server 2008 databases. Due to some issues we had to run DBCC checkDB, bringing the database to single user mode. When we complete the DBCC ...
3
votes
1answer
173 views

Transactional Replication: can create 52 publication, but creating 53rd leads to problems

My apologies in advance for a long post, but I was really trying to make sure I do my due diligence before turning to the community for help, so here it goes. I am working on a proof of concept with ...
0
votes
0answers
180 views

How to move SQL server transaction replication from one server to another server [closed]

Currently we have SQL Server 2005 as a publisher and SQL 2008 R2 as subscriber for one of our database (about 350 GB in size). I want to move the replication to our different server (Which also has ...
1
vote
1answer
55 views

Changes to main Database during Transactional Replication

Can you please advise how can I keep slave database up to date while it's in transactional replication with master. I mean what If I change indexes, columns, tables or sthm else in master dabase? ...
1
vote
2answers
935 views

SQL Server Transactional replication failed due to snapshot agent failure

I'm trying to set transactional replication between 2 SQL Server 2012 named instances. I've followed a step by step manual and created a Publication. But once I look into Replication Monitor I Get ...
17
votes
4answers
7k 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 ...
3
votes
1answer
1k 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
1answer
124 views

.NET error when trying to create snapshot for transactional Replication

I encountered a bizarre prob today while creating a transactional publication on a SQL 2012 server running on Windows Server 2008R2. I had just had some success creating and initializing some Merge ...
2
votes
3answers
2k views

Is replication possible on two different domains?

I am implementing a database replication between different geograhical locations where each one is on a different domain. After going through all the process, when I start the agent it runs and stops. ...
0
votes
1answer
70 views

What happens if you accidentally insert data into a replication target table?

We use transactional replication to replicate data from table1 on server1 to table2 on server2. However, one of my colleagues accidentally inserted some data into table2. In order to keep the two ...
0
votes
0answers
118 views

Adding Massive amount of Articles to existing publication cause screen to hang forever

I am using Win Server 2008 R2 / SQL Server 2008 R2 and i am trying to add about 2K + articles to the existing publication and the screen hangs @ the articles screen. The screen has been there and ...