-
2 VotesReminder - 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 | 53669 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
'Agent message code 20034. The process encountered operating system error'
Hello all! I am trying to set up replication to a test environment and am running into some problems. This pratically a copy of an existing replication job that's working, but with the name of the ...Answered | 6 Replies | 27 Views | Created by Collin.Beckendorf - 1 hour 33 minutes ago | Last reply by Collin.Beckendorf - 11 minutes ago -
1 Votes
SQL server replication error
Hi All, We are getting below error in SQL server replication. its SQL 2012 enterprise ...Unanswered | 2 Replies | 47 Views | Created by karthik1202 - Tuesday, January 21, 2020 6:17 PM | Last reply by Hilary Cotter - 1 hour 26 minutes ago -
0 Votes
Does @threshold of identity range work on SQL Server Express?
According to this page https://msdn.microsoft.com/en-us/library/ms152543.aspx, "the @threshold parameter, which is used to determine when a new range of ...Answered | 4 Replies | 180 Views | Created by VSha0 - Sunday, January 19, 2020 11:07 PM | Last reply by VSha0 - 21 hours 45 minutes ago -
0 Votes
How to Handle Changes in PUBLISHER
We are running transactional replication on a application DB with approx 6000 tables. We are planning to upgrade the application and in doing so, a number of tables are ...Proposed | 6 Replies | 738 Views | Created by ARPRINCE - Wednesday, December 11, 2019 5:31 PM | Last reply by ARPRINCE - Tuesday, January 21, 2020 7:09 PM -
0 Votes
SQL Server 2019
Hi, I am having issues getting replication up and running correctly between two enterprise editions fo SQL Server 2019. I have just installed the latest CU1 update but am still ...Proposed | 5 Replies | 315 Views | Created by Peter Munnelly - Wednesday, January 8, 2020 11:12 PM | Last reply by Hilary Cotter - Tuesday, January 21, 2020 4:14 PM -
0 Votes
Change data capture remove data from tables older than 3 days
Hi Guys, We are using below SP for clean up, it was supposed to clean data older than 3 days from CDC tables, but its not works as excepted EXEC ...Proposed | 2 Replies | 232 Views | Created by Navind - Monday, January 13, 2020 8:08 PM | Last reply by Cris Zhan - Monday, January 20, 2020 2:47 AM -
0 Votes
MSSQL_REPL55012: An unspecified error had occurred in the native SQL Server connection component.
Hello all. I am a student attempting to run the 'Creating a Mobile Application with SQL Server Compact Edition' walkthrough on the MSDN site. Unfortunately I am ...Answered | 8 Replies | 12039 Views | Created by Jason3309192 - Thursday, April 5, 2007 3:05 AM | Last reply by MA Blouin - Thursday, January 16, 2020 12:00 PM -
0 Votes
Error 25542 SSCE_M_QP_READONLYINSERT
Hi all, I've a problem with a merge replication. When I make changes on it, adding a new article, the SQL Server CE subscriptions crash while trying to synchronize, the get error ...Unanswered | 6 Replies | 796 Views | Created by JMF70 - Monday, May 27, 2019 10:54 AM | Last reply by JMF70 - Wednesday, January 15, 2020 8:34 AM -
0 Votes
Merge Replication not deleting unmatched filter rows from Subscriber Database
I have applied filters on articles in SQL Merge Replication and syncing the data using MergeSynchronizationAgent via Web Synchronization. The data is syncing as per the applied filters from ...Answered | 12 Replies | 1151 Views | Created by M0Bilal - Monday, December 9, 2019 7:22 AM | Last reply by M0Bilal - Wednesday, January 15, 2020 7:41 AM -
0 Votes
Oracle Publisher row level triggers
We are using Oracle publisher to replicate data from oracle to SQL server,everything works well but i see the rowlevel triggers captures old data and new data also so i am seeing duplicates records in ...Unanswered | 2 Replies | 569 Views | Created by Snehasis pattnaik - Friday, August 30, 2019 2:10 PM | Last reply by Snehasis pattnaik - Friday, January 10, 2020 9:37 PM -
0 Votes
Switching properties without needing to reinitialize?
Greetings. We've got transactional replication setup between a 3 TB database and several reporting servers. For very long winded reasons we want to remove large amounts of data from ...Answered | 9 Replies | 965 Views | Created by ChrisRDBA - Thursday, December 12, 2019 8:50 PM | Last reply by ChrisRDBA - Friday, January 10, 2020 2:18 PM -
0 Votes
SQL Server merge replication copy data from production database to test database
Current setup: SQL Server 2016 merge replication with 1 publisher and 1 subscriber. Same exact setup for our test environment. We currently are setup with simple recover model and ...Answered | 6 Replies | 326 Views | Created by ToniS89 - Tuesday, January 7, 2020 10:28 PM | Last reply by ToniS89 - Thursday, January 9, 2020 3:11 PM -
2 Votes
data is not replicating from publisher to subscriber.
I configured transactional replication. However, data is not replicating from publisher to subscriber. I have attached screenshots of errors. Could you please ...Proposed | 7 Replies | 1021 Views | Created by juniorkiran - Tuesday, December 3, 2019 2:48 PM | Last reply by juniorkiran - Thursday, January 9, 2020 10:32 AM -
0 Votes
Snapshot Agent - Error when running agent
Hi I have installed SQL Server 2019 and setup a new publication as normal. When I have tried to run the snapshot agent it will get so far and then error out with ...Answered | 3 Replies | 386 Views | Created by SQL Noob88 - Monday, January 6, 2020 12:04 PM | Last reply by Cathy Ji - Thursday, January 9, 2020 10:06 AM -
0 Votes
The initial snapshot for publication 'ABC.pub' is not yet available."
We have two SQL 2012 servers. Replication has been running on these servers for years. Replication failed for several databases and I have not been able to reestablish them. ...Unanswered | 5 Replies | 248 Views | Created by juniorkiran - Monday, January 6, 2020 6:46 AM | Last reply by Dawn Yang - Thursday, January 9, 2020 1:47 AM -
0 Votes
Merge Replication Between SQL server 2012 and SQL server compact
Hello, I'm trying to create a merge replication between SQL sever 2012 SP4 and SQL server compact 3.5 SP2. Once I am creating a subscription in SQL ...Unanswered | 8 Replies | 537 Views | Created by OmarEhmidee - Tuesday, December 31, 2019 2:48 PM | Last reply by OmarEhmidee - Tuesday, January 7, 2020 2:50 PM -
0 Votes
SQL 2019 Replication Snapshot Error
I cannot create a snapshot with SQL Server 2019 in order to get a transactional replication up and running. Upon the snapshot agent starting I receive the following ...Proposed | 1 Replies | 334 Views | Created by Peter Munnelly - Sunday, January 5, 2020 7:58 PM | Last reply by Amelia Gu - Monday, January 6, 2020 3:06 AM -
0 Votes
SQL Server 2019: Logreader broken
The transactional log reader seems to be broken in sql server 2019 RTM. I upgraded my test environment and run in the problem that the second step in the sql server agent job (run ...Discussion | 4 Replies | 1127 Views | Created by AberleC - Tuesday, November 12, 2019 10:38 AM | Last reply by daniel_mrowiec - Friday, January 3, 2020 10:57 PM -
0 Votes
SQL Server Replication Configuration- Stuck at Replication Administrative Password step.
Hi everyone, I have been struggling for the past one week to setup the replication in our environment and has been stuck on Administrative Password issue when ...Unanswered | 3 Replies | 946 Views | Created by Shaddy_1 - Thursday, December 12, 2019 6:46 PM | Last reply by Shaddy_1 - Monday, December 30, 2019 8:44 PM -
2 Votes
snapshot agent showing red mark in replication monitor!!!(Merge replication)
few days before snapshot agent showing red mark in replication monitor without any changes... synchronizing from publisher to subscribe working fine... and ...Answered | 9 Replies | 3019 Views | Created by Baraiya Kirit - Saturday, December 20, 2014 7:26 AM | Last reply by Vlad Maryland - Friday, December 27, 2019 7:37 PM - Items 1 to 20 of 12004 Next ›
