-
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 | 47289 Views | Created by Greg Y - Thursday, December 07, 2006 8:22 PM | Last reply by Harry SQL DBA - Saturday, February 19, 2011 5:43 AM
-
0 Votes
Transaction Replication
Hi, How to get details of script which one get error in Subscriber. This Mean, Some ...Unanswered | 2 Replies | 91 Views | Created by chennai_svk - Thursday, August 17, 2017 5:15 AM | Last reply by chennai_svk - 22 hours 29 minutes ago -
3 Votes
Merge replication not transmitting all changes
I've got a reoccuring issue with SQL 2012 though it's occured in 2008 and 2014 as well. The setup is as follows. 5 servers (sites). 1 publication server and 4 subscribers dotted ...Unanswered | 15 Replies | 242 Views | Created by Marsegg - Thursday, August 10, 2017 11:12 AM | Last reply by Hilary Cotter - Friday, August 18, 2017 11:57 PM -
0 Votes
Transnational replication for Delete command
I have setup MSSQL transaction replication setup in our environment. SQL version: SQL Server 2014 Server1 as publisher Server2 as ...Unanswered | 2 Replies | 63 Views | Created by Dhaval2410 - Friday, August 18, 2017 5:35 AM | Last reply by Hilary Cotter - Friday, August 18, 2017 10:51 PM -
0 Votes
Web Sync
Hi, I am struggling to setup a Web Sync. I have gone thru all the setup and have SUCCESS appearing in my ?Diag page Problem is with ...Unanswered | 1 Replies | 57 Views | Created by David K - Friday, August 18, 2017 9:41 AM | Last reply by Hilary Cotter - Friday, August 18, 2017 10:49 PM -
1 Votes
read only replication and view Stored procedures
Hi I configured transaction replication and required reporting user to access some procedures and view procedures. but When grant db read only access to users, then the can ...Proposed | 3 Replies | 158 Views | Created by ashwan - Thursday, August 03, 2017 8:25 AM | Last reply by Sandy_ha_ha_ha - Friday, August 18, 2017 2:30 AM -
0 Votes
Add Articles in Existing Merge Replication
Hi, What is best method to add new articles in Existing Merge Replication without Re ...Proposed | 7 Replies | 271 Views | Created by chennai_svk - Tuesday, August 01, 2017 5:32 PM | Last reply by Kalila2255 - Thursday, August 17, 2017 3:53 AM -
0 Votes
Peer to Peer Replication
We are planning to set up a Peer-to-Peer Replication on Always -on (SQL Server 2016). The current architecture is more like the below - 1. Standalone SQL Server 2. Always ...Unanswered | 1 Replies | 58 Views | Created by S.Vijay Kumar - Wednesday, August 16, 2017 6:24 PM | Last reply by Hilary Cotter - Wednesday, August 16, 2017 6:57 PM -
0 Votes
The process could not execute 'sp_replcmds during Transactional Replication
Log reader job failing with this error below using this command: -Publisher [Pub_Server] -PublisherDB [Pub_Database] -Distributor [Dist_Server] ...Answered | 6 Replies | 2035 Views | Created by LLittle - Monday, May 11, 2015 9:05 PM | Last reply by LLittle - Wednesday, August 16, 2017 6:42 PM -
0 Votes
Oracle Publisher contains no objects that can be replicated
Hi there, we are running SQL Server 2014 Enterprise, I am trying to configure transactional replication with an Oracle 12c database, in trying to create the Oracle Publisher, I get the following ...Proposed | 4 Replies | 245 Views | Created by aparm - Monday, February 27, 2017 7:57 AM | Last reply by tolnep - Wednesday, August 16, 2017 12:49 AM -
0 Votes
Replication Alerts Configuration- URGENT
Hi Team, This is an urgent. Can any body guide me that how to create alert for below status for both for Publisher and Subscriber in Transactional ...Unanswered | 9 Replies | 171 Views | Created by S.Vijay Kumar - Wednesday, August 02, 2017 4:44 AM | Last reply by S.Vijay Kumar - Tuesday, August 15, 2017 10:33 PM -
2 Votes
Upgraded Distributor / Publisher Server from 2008 r2 to 2016. Replication not working
I upgraded sql server from 2008r2 enterprise edition to 2016 enterprise edition, on same server. I detached, uninstalled 2008, installed sql 2016, reattached. Replication issues ...Answered | 19 Replies | 196 Views | Created by datad - Monday, August 14, 2017 1:42 AM | Last reply by Hilary Cotter - Tuesday, August 15, 2017 8:10 PM -
0 Votes
Any issue with replicating images?
Greetings. Are there any issue replicating image data types in SS 2014? Specifically, will updates to these values make it over reliably to the ...Unanswered | 2 Replies | 63 Views | Created by ChrisRDBA - Monday, August 14, 2017 6:24 PM | Last reply by Hilary Cotter - Monday, August 14, 2017 6:46 PM -
0 Votes
Merge Replication - Update Foreign Key Constrant
Hi, I need to change the delete and update rules on a foreign constraint in a replicated database (merge). The publication is setup to replicate scheme changes and the subscribers ...Answered | 2 Replies | 118 Views | Created by TSD123 - Friday, August 11, 2017 4:28 PM | Last reply by Teige Gao - Monday, August 14, 2017 9:03 AM -
0 Votes
Heterogeneous Replication Via Linked Server
I am trying to setup Tran replication between SQL Server and Postgresql however microsoft officially supports only Oracle and IBM as Non-SQL Server Subscribers. I have created ...Answered | 7 Replies | 344 Views | Created by Asif_DBA - Monday, March 20, 2017 5:35 AM | Last reply by Asif_DBA - Sunday, August 13, 2017 7:09 AM -
1 Votes
What type of replica I need?
Hi, I have some doubts about replication, I have 2 servers with SQL Standard 2016 ("A" and "B") all users work in server "A" but in case of a disaster ...Answered | 12 Replies | 213 Views | Created by George Waters - Tuesday, August 08, 2017 9:19 AM | Last reply by KevinBHill - Friday, August 11, 2017 12:44 PM -
0 Votes
Write protection error on tempdb during replication
08/09/2017 12:20:52,spid77,Unknown,The operating system returned error 19(The media is write protected.) to SQL Server during a write at offset 0x00000009430000 in file 'F:\SQL Server\tempdb.mdf'. ...Unanswered | 2 Replies | 99 Views | Created by contactomorph - Thursday, August 10, 2017 9:02 AM | Last reply by Hilary Cotter - Thursday, August 10, 2017 11:13 AM -
0 Votes
SQL Replication Filling T-Log
Hi All, We used SQL transactional replication on one of our database however we currently don't need to replicate any data so we have disabled all subscriptions however the T-Log ...Unanswered | 2 Replies | 110 Views | Created by Robert Pollock - Wednesday, August 09, 2017 8:38 PM | Last reply by Hilary Cotter - Wednesday, August 09, 2017 10:17 PM -
0 Votes
Unsent Transaction Threshold Using EXEC sp_dbmmonitorresults
I'm seeing, on occassion, in a SQL 2008 R2 database mirroring session (multiple databases) that the 'unsent transaction' ('time_behind' metric) is exceeding 2 minutes, though generally resolving with ...Unanswered | 3 Replies | 121 Views | Created by Trevor Seward - Tuesday, August 08, 2017 3:41 PM | Last reply by Hilary Cotter - Wednesday, August 09, 2017 2:41 PM -
2 Votes
How Sync Framework reads data from AlwaysOn group
I am planning implement replication on AlwaysOn group to make a batch process. If I use SQL native replication it will read data from the Primary node. (as secondary nodes ...Answered | 2 Replies | 116 Views | Created by Kamalakar Aukunooru - Wednesday, August 09, 2017 11:06 AM | Last reply by Hilary Cotter - Wednesday, August 09, 2017 2:16 PM -
0 Votes
Replication Latency history
How can i get Transactional replicaiton latency history from past 1 month with time stamp?Answered | 2 Replies | 130 Views | Created by S.Vijay Kumar - Wednesday, August 02, 2017 11:42 PM | Last reply by Hilary Cotter - Monday, August 07, 2017 1:50 PM - Items 1 to 20 of 11365 Next ›
