All Questions
Tagged with database-replication sql-server-2008
62 questions
1
vote
2
answers
2k
views
Invalid column name 'deletebatchsize_xact' and 'deletebatchsize_cmd'
In a sudden my SQL Replication job not synchronizing data but in the history it says all are successful.
After a details check, I'm getting below message from replication properties and from 'View ...
1
vote
0
answers
32
views
Replicating between two databases that are firewalled, using a machine in the middle?
I have 2 SQL servers: one running SQL Server 2008, the other SQL Server 2016. These two databases cannot, and will not be able to talk to each other directly due to complex firewalling rules. The ...
- 1,258
0
votes
0
answers
44
views
Replication - Is it possible to publish to different servers?
I use mssqlserver08 with ssms, and want to publish tables to two different servers.
One server is used to run my application, the other is used to backup data, and the tables' schema are the same.
...
- 7
0
votes
1
answer
986
views
Copying Indexes From Publisher To Subscriber in SQL Server Replication
I am configuring transactional replication.
I have configured that and its working fine.
Now i want to copy all the non clustered indexes and covered indexes(NC Index)
from publisher to subscriber.
...
- 31
0
votes
1
answer
144
views
SQL Server Replication Process Account Error
As per below image, I am Configuring the Transactional Replication in SQL Server 2008 R2.
I need to give process account and password.
I tried to provide the account as the account from which i login ...
- 31
1
vote
1
answer
67
views
Grails Support to Handle Datasource Failure
I am looking for a solution for automatic database failover in grails application. I have two databases which reside on two different sites connected over WAN. On Site A, we have Database 01 which is ...
- 2,674
2
votes
2
answers
2k
views
Replication Issue with computed columns
So the situation is there are two servers pub_server(publisher) and sub_server (subscriber).
There are two databases on pub_server : db1 and db2.
There exists a table xyz_tbl in db1 which is ...
- 135
1
vote
1
answer
250
views
Cross Database Queries vs Replication
I have 2 SQL 2008 database servers that have database stored procedures with cross database server queries (different physical servers. querying done through linked servers). I'm assuming this is not ...
- 765
0
votes
1
answer
192
views
Create a Live Replica Database
Our Company is developing a website and it pulls information from our internal production servers. for added security I was asked if we could set up a new server and pull from that. I know I can have ...
0
votes
0
answers
231
views
SQL Replication Running ALTER VIEW against a table
I have SQL Server Replication running between a Publisher and 2 subscribers.
Publisher: Microsoft SQL Server 2008 (SP3) - 10.0.5538.0 (X64)
Apr 3 2015 14:50:02
Copyright (c) 1988-2008 ...
- 43
-1
votes
1
answer
750
views
SQL violation of primary key constraint replication
I'm trying to make a replication between an sql server 2008 to 2012
I have done that before between 2008 server and works perfectly
Now when I set the publication type to snapshot, and doing it as a ...
0
votes
1
answer
1k
views
Problems with an orphaned replication
I'm pretty new to SQL Server, so of course I'm doing all the DBA tasks. I pulled a boneheaded move last week, and when I did a restore on a test DB, it overwrote the replication. So, I deleted as best ...
- 463
1
vote
1
answer
383
views
I couldn't see Conflict tables in replication monitor SQL 2008 R2 in Merge Replication
I worked Merge Replication in SQL server 2008 R2 , in replication monitor i can't see Conflict table, i must to see conflict tables in "MSmerge_conflicts_info" , please help me, How to see Conflict ...
0
votes
0
answers
1k
views
SQL Server 2008 R2 Replication - Publication creation not working
I'm trying to set up transactional replication from a SQL Server 2008 R2 (as publisher) to a SQL Server 2000, using the management studio. However, I can't get past the the creation of the publisher. ...
- 193
2
votes
1
answer
4k
views
Snapshot repldata\unc not clearing
SQL Server 2008 R2 Snapshot Replication
Background Info
x3 Servers all running MSSQL 2008 R2, on Windows Server 2012:
SERV1 containing two published databases- S1DB1 and S1DB2
SERV2 containing two ...
- 21