-
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 | 52104 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
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 | 97 Views | Created by SSG92 - Monday, October 7, 2019 9:53 AM | Last reply by Cathy Ji - 4 hours 32 minutes ago -
0 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 | 8 Replies | 231 Views | Created by Peang Suy - Saturday, October 5, 2019 1:29 PM | Last reply by Peang Suy - 9 hours 47 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 | 3 Replies | 149 Views | Created by Q-Plex - Saturday, October 5, 2019 2:07 PM | Last reply by Hilary Cotter - 20 hours 22 minutes ago -
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 | 160 Views | Created by MohamedEmam - Wednesday, October 2, 2019 2:01 PM | Last reply by Hilary Cotter - 20 hours 30 minutes ago -
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 | 335 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 | 194 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 | 288 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 | 560 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 | 200 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 ...Unanswered | 3 Replies | 518 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 | 302 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 | 211 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 | 5479 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 | 251 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 | 1010 Views | Created by ZahidButt - Wednesday, January 16, 2019 3:00 PM | Last reply by ZahidButt - Tuesday, September 17, 2019 4:27 PM -
0 Votes
Production to Pre Production Data replication
Hi Team I have TBs of SQL DBs on Azure IAAS. I would like to have these production DBs to be replicated to my Pre prod IAAS SQL environment on daily or weekly intervals. Since DBs ...Unanswered | 8 Replies | 382 Views | Created by Whynot_vish - Friday, September 13, 2019 11:07 AM | Last reply by Whynot_vish - Tuesday, September 17, 2019 4:45 AM -
0 Votes
Schema script could not be propagated to the subscriber
When I check in the Replication Monitor it shows like follows, > Tried to access the publishing servers share ...Answered | 2 Replies | 331 Views | Created by Chama.Rana - Tuesday, September 10, 2019 4:35 AM | Last reply by Chama.Rana - Thursday, September 12, 2019 5:48 AM -
0 Votes
Distribution Agent Fails - Cannot Create Temp Files in SQLServer\140\COM Folder
Hello. I would like to kindly ask for your thoughts with the following: 1) I have a Transactional Replication (TR) with a remote Distributor (DIS), between the ...Answered | 2 Replies | 288 Views | Created by BogdanU - Wednesday, September 11, 2019 1:13 PM | Last reply by BogdanU - Wednesday, September 11, 2019 1:49 PM -
0 Votes
Moving Distributed database from system database in Distribution server to another database
I have configured tracer tokens on my distributed database which is in system database on by distributor instance. i want to move the distributed database to another instance ...Proposed | 3 Replies | 375 Views | Created by Sads_02 - Friday, September 6, 2019 9:38 AM | Last reply by Cathy Ji - Wednesday, September 11, 2019 9:39 AM -
0 Votes
replication pending commands
all commands that are greater than the earliest/MIN trans_seqno of the publication for all subscribers in the distribution agent history table. Appreciate if ...Unanswered | 1 Replies | 328 Views | Created by sqlman2011 - Tuesday, September 10, 2019 11:00 AM | Last reply by Dedmon Dai - Wednesday, September 11, 2019 7:23 AM - Items 1 to 20 of 11934 Next ›
