-
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 | 52167 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
-
0 Votes
Shutdown Time-Out Interval for Transactional Replication
Properties > Job System > Shutdown time-out interval parameter is set to 15 seconds. Since I have no experience with what this Parameter is in charge of, please ...Answered | 5 Replies | 159 Views | Created by BogdanU - Thursday, October 10, 2019 1:04 PM | Last reply by Hilary Cotter - 19 hours 49 minutes ago -
0 Votes
Login failed for user '<username>'. Reason: The account is disabled. (.Net SqlClient Data Provider)
how do i fix a `Login failed for user '<username>'. Reason: The account is disabled. (.Net SqlClient Data Provider)` error?Unanswered | 5 Replies | 339 Views | Created by Q-Plex - Saturday, October 5, 2019 2:07 PM | Last reply by Amelia Gu - Friday, October 11, 2019 9:50 AM -
0 Votes
Replication to azure subscriber
Hi, I'm experiencing the error below: A .NET Framework error occurred during execution of user-defined routine or aggregate ...Proposed | 2 Replies | 416 Views | Created by vee_bee - Wednesday, October 9, 2019 10:04 PM | Last reply by vee_bee - Friday, October 11, 2019 7:21 AM -
0 Votes
DATE data type is not replicated to Subscriber in Merge Replication
Hi, I have configured Merge Replication on DB. This is SQL Server 2016 ENT What i observered is in one table (Column) DATE and TIME data type is not ...Unanswered | 2 Replies | 197 Views | Created by VijayKSQL - Wednesday, October 9, 2019 10:46 PM | Last reply by VijayKSQL - Thursday, October 10, 2019 2:29 PM -
2 Votes
The Distributer Has not been Installed Correctly - Error 20036 SQL 2014
Primary &Secondary node -DR Site (DR-DB01)--->Secondary node 2.Environment #2 with SQL ...Unanswered | 12 Replies | 444 Views | Created by Peang Suy - Saturday, October 5, 2019 1:29 PM | Last reply by Dedmon Dai - Thursday, October 10, 2019 5:13 AM -
0 Votes
To Which Database the data is sharing in mysql read replica
Hi , I had configured to two databases (one is master and one is slave database). Now i inserted some data in master database. The created data is reflected in ...Proposed | 3 Replies | 142 Views | Created by NagaveniG - Wednesday, October 9, 2019 12:40 PM | Last reply by Cathy Ji - Thursday, October 10, 2019 1:42 AM -
1 Votes
MSSQL Replication Over The Internet
I'll be configuring a replication of a database over the internet using SSMS. I need to encrypt the communication between the two hosts, and a VPN isn't an option. Is using HTTPS via IIS the best ...Proposed | 2 Replies | 202 Views | Created by Richard Long - richard2long4u269 - Tuesday, October 8, 2019 7:11 PM | Last reply by Dedmon Dai - Wednesday, October 9, 2019 8:11 AM -
0 Votes
replication
Hi All, I see log file for a DB keep growing. Log_reuse_wait_desc shows as 'replication'. What can be done to fix the issue? I see many forums ...Unanswered | 5 Replies | 323 Views | Created by SSG92 - Monday, October 7, 2019 9:53 AM | Last reply by Cathy Ji - Tuesday, October 8, 2019 9:41 AM -
0 Votes
Transactional Replication Collation Conflict
i have one server with collation(SQL_Latin1_General_CP1_CI_AS)and Database with collation(Arabic_CI_AS)Use it as publication to the replication and i have another server with ...Proposed | 5 Replies | 297 Views | Created by MohamedEmam - Wednesday, October 2, 2019 2:01 PM | Last reply by Hilary Cotter - Monday, October 7, 2019 5:43 PM -
0 Votes
Not able to configure second subscriber on transnational replication.
Hi, I am trying to add extra subscriber on already established transnational replication using below code. ...Discussion | 1 Replies | 435 Views | Created by Lakshmi_pvv - Friday, September 13, 2019 6:52 AM | Last reply by Matt Bradley Mcr - Saturday, October 5, 2019 9:33 PM -
0 Votes
SQL Server Replication 101
So we are trying to create an Enterprise Data Warehouse and Operational Data Store(ODS) Data Environment. Our idea is to spin-up a Replication Environment in order to isolate our EDW/ODS Environment ...Unanswered | 2 Replies | 280 Views | Created by ITBobbyP - Monday, September 30, 2019 8:03 PM | Last reply by ITBobbyP - Monday, September 30, 2019 9:29 PM -
0 Votes
LS_Copy & LS_Restore job not working in Log shipping MS SQL 2016
Hello Everyone, Trying to configure Log shipping as DR solution. LS_Backup working fine in primary site. Backup files are getting resides in primary. However, LS_Copy & ...Unanswered | 5 Replies | 363 Views | Created by SinuDBA - Wednesday, September 25, 2019 8:24 PM | Last reply by Cathy Ji - Monday, September 30, 2019 1:38 AM -
0 Votes
why does property of replicated subscriber show replicated as false
Hi we run 2017 STD. I'm looking at the properties of a subscriber in a tran replication relationship and Replicated shows false. Why? I'm pretty certain it is replicated if for no reason, the count as ...Unanswered | 10 Replies | 629 Views | Created by db042190 - Tuesday, September 3, 2019 5:14 PM | Last reply by db042190 - Thursday, September 26, 2019 12:15 PM -
0 Votes
SQL Server 2017. Implementing Replication on a Failover Cluster failed
Hello I am trying to implement a replication on a failover cluster but I am getting the following error when I tried to create the distribution ...Answered | 2 Replies | 273 Views | Created by Rey1962 - Wednesday, September 25, 2019 1:57 PM | Last reply by Rey1962 - Wednesday, September 25, 2019 4:01 PM -
0 Votes
Monitor Distributor Agent in Transnational Replication
Hi, I wanted to monitor the Distributor Agent's running status in Transnational Replication. I want to get alert when it is stopped. Tried to create alert for the ...Proposed | 3 Replies | 580 Views | Created by Udham Singh - Tuesday, August 6, 2019 11:15 AM | Last reply by BogdanU - Wednesday, September 25, 2019 12:05 PM -
0 Votes
Error: SQL Server Not Configured For Remote Access (2017, Standard Edition, on an Azure VM)
Hi. I wanted to kindly ask for the help about these errors: A log reader agent can only be installed for a database enabled for transactional/snapshot ...Unanswered | 2 Replies | 373 Views | Created by BogdanU - Wednesday, September 18, 2019 9:37 AM | Last reply by BogdanU - Wednesday, September 25, 2019 11:57 AM -
0 Votes
SQL Server Merge Replication Error: The format of a message during Web synchronization was invalid
I am doing Merge Replication using Web Synchronization. On Subscriber end, there is SQL Express 2012 on Windows 10 Pro. On publisher end, there is SQL Server 2017 on Windows Server 2019. Web ...Unanswered | 3 Replies | 286 Views | Created by M0Bilal - Monday, September 23, 2019 3:53 PM | Last reply by Dedmon Dai - Tuesday, September 24, 2019 9:09 AM -
0 Votes
Merge replication - sync failed (after high number of rows updated)
Hi MSDN and all helpers on this forum. I'm facing a new problem with SQL Merge replication. (yes, a new one , even if i'm working with merge replication since years, this error is ...Answered | 10 Replies | 5549 Views | Created by -Olivier- - Monday, April 16, 2012 11:46 AM | Last reply by M0Bilal - Tuesday, September 24, 2019 6:45 AM -
0 Votes
I dont want the snapshot to be created for commands that have already been sent to subscriber (hundreds of them).
Good Morning experts, I have a publisher db containing thousands of articles to be sent to subscriber. The publisher db is 2TB. There is lot of latency , thousands of undelivered ...Answered | 4 Replies | 318 Views | Created by juniorkiran - Sunday, September 22, 2019 3:06 AM | Last reply by Hilary Cotter - Monday, September 23, 2019 5:33 PM -
2 Votes
How to add another subscription to existing transactional replication
Hi, We have four publications (1,2,3,4) on server "A" with Push Subscriptions in place. Publication 1,2 & 3 are being replicated to Server ...Answered | 3 Replies | 1079 Views | Created by ZahidButt - Wednesday, January 16, 2019 3:00 PM | Last reply by ZahidButt - Tuesday, September 17, 2019 4:27 PM - Items 1 to 20 of 11939 Next ›
