-
2 Votes
Reminder - please indicate if a reply has answered your question.
How do I indicate a post answered my question? If a post has answered your original question, please indicate this by clicking on the "Mark as Answer" button ...Sticky | 4 Replies | 49640 Views | Created by Greg Y - Thursday, December 7, 2006 8:22 PM | Last reply by Harry SQL DBA - Saturday, February 19, 2011 5:43 AM
-
1 Votes
Schema changes to Transaction replcation setup 2018 R3 to 2014
Hi Currently my have transaction replication 2018 R3 to 2014. Now I business needs schema changes. add new Three tables add new three ...Unanswered | 7 Replies | 89 Views | Created by ashwan - Friday, February 15, 2019 4:45 AM | Last reply by Hilary Cotter - Friday, February 15, 2019 4:05 PM -
0 Votes
Clear sessions of Log Reader Agent
Can see multiple errors of the same type in Sessions of the Log Reader Agent (Publisher to Distributor History). I would like to clear these logs so as to easily monitor for genuine errors. Is it ...Answered | 7 Replies | 260 Views | Created by asthajn1009 - Monday, February 4, 2019 6:07 PM | Last reply by asthajn1009 - Friday, February 15, 2019 1:12 PM -
0 Votes
Transaction replication distributor to subscriber pending
Hi I am setting up 2008R2 to 2014 Transaction replication for propagate same scenario as prod . When I checked with tracer token that distributer to subscriber is pending. ...Unanswered | 1 Replies | 42 Views | Created by ashwan - Friday, February 15, 2019 8:15 AM | Last reply by Bartosz Lewandowski - Friday, February 15, 2019 10:59 AM -
0 Votes
SQL server cross replication login failed
Hello All, We have DEV and UAT domain. I am trying to create replication from UAT to DEV and vice versa. As we have two different domain we can't use domain account. So, i have ...Unanswered | 10 Replies | 187 Views | Created by Chickoo79 - Tuesday, February 12, 2019 7:43 PM | Last reply by Emily Fei - Friday, February 15, 2019 9:54 AM -
2 Votes
sp_MSreplcheck_qv
I am trying to replicate a database from SS2005 to SS2008, I have setup the distribution server as the 2008 server and am now trying to publish from the 2005 server, on doing that I get a ...Answered | 9 Replies | 11407 Views | Created by Y Jack - Thursday, September 16, 2010 1:32 PM | Last reply by Chandan.mssqldba - Thursday, February 14, 2019 9:31 AM -
0 Votes
Can we have two different publication servers and single subscriber Server
Hi, I have a request to add a database from a server to the existing replication setup. Existing setup: Server1: ...Answered | 4 Replies | 138 Views | Created by Kranthi_666 - Monday, February 11, 2019 11:47 AM | Last reply by Emily Fei - Tuesday, February 12, 2019 6:59 AM -
0 Votes
Lock on Views at snapshot replication all the time
Hi I did setup a snapshot replication including some views. Did work without any problems. After the snapshot was finished and transfered to the subscriber I tried to do a drop of ...Unanswered | 2 Replies | 161 Views | Created by Beat hotelleriesuisse - Friday, February 8, 2019 2:15 PM | Last reply by Dedmon Dai - Monday, February 11, 2019 5:48 AM -
0 Votes
Unable to configure transactional replication using Listener name from SSMS 2014
Hi, We are running SQL Server 2014 Ent and 2017 Ent. While setting up transactional replication with Publisher DB in ...Proposed | 1 Replies | 171 Views | Created by Rahul Gav - Sunday, February 10, 2019 7:11 AM | Last reply by Mohsin_A_Khan - Monday, February 11, 2019 12:32 AM -
0 Votes
Problem with CDC (change data capture)
On a high-load base (about a million commands per second) Included CDC on the table (about 1 000 000 000 rows) with changes of about 3 million per ...Unanswered | 6 Replies | 426 Views | Created by czar-wizard - Wednesday, January 16, 2019 1:35 PM | Last reply by Pr0ger - Thursday, February 7, 2019 7:17 PM -
1 Votes
How can I replicate data from SQL Server 2017 to SQL Server 2008 R2
SQL 2008 R2. I don't need real time replication, just daily. The servers run as virtual instance on the same physical server in Hyper-V. This is a membership database and is roughly 5 GB in ...Proposed | 4 Replies | 289 Views | Created by GrandpaDude - Thursday, January 24, 2019 10:29 PM | Last reply by Greg Y - Thursday, February 7, 2019 1:49 AM -
1 Votes
Configure replication from SQL server 2014 Enterprise Ed. to SQL server 2017 Enterprise Ed.
The query here is pertaining to Replication support between Publisher instance running on SQL Server 2014 Ent. Ed. and Subscriber instance being on SQL Server 2017 Ent. Ed. Currently all DB ...Unanswered | 2 Replies | 295 Views | Created by Rahul Gav - Saturday, February 2, 2019 11:15 AM | Last reply by Greg Y - Thursday, February 7, 2019 1:45 AM -
0 Votes
Always on replica and cached views
Hi All, I've a little suspect on returned rows from sql VIEWS created with(nolock) and pooled c# connections. My Installation is synch-commit availability ...Answered | 5 Replies | 281 Views | Created by dscaravaggi - Tuesday, January 29, 2019 5:39 PM | Last reply by dscaravaggi - Wednesday, February 6, 2019 3:59 PM -
0 Votes
Partition table Replication
Hi Experts, Am planning to migrate to a new version from SQL Server 2014 to 2017 enterprise. Am thinking of using the transactionreplication to keep the data sync. Am very new to ...Unanswered | 2 Replies | 166 Views | Created by Priya Bange - Tuesday, February 5, 2019 4:11 AM | Last reply by Hilary Cotter - Wednesday, February 6, 2019 2:46 PM -
0 Votes
Replicate to different network
Existing setup : Server1 (cloud) as Publication & Distributor (sql 2016) to Server2 (cloud) as Subscriber (sql 2016) ( same ...Proposed | 3 Replies | 167 Views | Created by KIRUBAKARAN J A - Monday, February 4, 2019 10:17 AM | Last reply by Hilary Cotter - Monday, February 4, 2019 7:25 PM -
0 Votes
Expired subscription clean up failing with sp_MSdrop_expired_subscription
This issue is with 3 servers that are running SQL 2005 SP3 with transactional replication. The "Expired subscription clean up" job is failing with the message "The name ...Proposed | 17 Replies | 12949 Views | Created by Brian.Jones - Monday, August 3, 2009 1:06 PM | Last reply by MrPshaw - Friday, February 1, 2019 5:36 PM -
0 Votes
Removing a filtered article in merge replication
Hi all, I have a merge rep setup, and it includes hierarchy of filtered tables. At the top of the hierarchy there is a parameterised filter (user login) and join ...Proposed | 1 Replies | 203 Views | Created by backtothefuture - Wednesday, January 30, 2019 2:28 PM | Last reply by Emily Fei - Thursday, January 31, 2019 7:28 AM -
1 Votes
Oracle Publications
I am trying to setup Transactional Replication from Oracle to SQL Server, but SQL is not seeing the schema of the objects. It can see the table names, but not the columns. Oracle is on 12.2 and SQL ...Answered | 1 Replies | 189 Views | Created by John Couch - Wednesday, January 30, 2019 2:44 PM | Last reply by Puzzle_Chen - Thursday, January 31, 2019 2:01 AM -
1 Votes
SQL Server 2008 Replication Agent missing required privilege
So our replication publisher was once an Active Directory domain controller. We removed it as a domain controller and have noticed that certain replication setups have stopped. we are getting the ...Answered | 16 Replies | 10772 Views | Created by Phillip Couto - Friday, April 29, 2011 4:03 PM | Last reply by ElementOmicron - Wednesday, January 30, 2019 6:19 PM -
0 Votes
How to get last synchronization date and time of a database in SQL
Hi Team, How to get last synchronization date and time of a database in SQL? Any query to check or what is the log file? Please let me ...Unanswered | 6 Replies | 278 Views | Created by boopathi subramaniam - Tuesday, January 29, 2019 4:39 PM | Last reply by Olaf Helper - Wednesday, January 30, 2019 9:10 AM -
0 Votes
SQL 2012 Replikation - can't create subscriber
Hi, gestern wollte ich einen Abonnenten für eine Replikation anlegen, es gibt noch keine weiteren Abonnenten. Der Publisher ist ein SQL 2012 Standard, der Abonnent ein SQL 2012 ...Answered | 4 Replies | 722 Views | Created by SIH007 - Monday, February 12, 2018 3:58 PM | Last reply by SIH007 - Saturday, January 26, 2019 4:24 PM - Items 1 to 20 of 11760 Next ›