-
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 | 47171 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
Replication agent encountered a file compression (cabinet) library error - WHY?
I have SQL2014 Transaction replication setup and trying unsuccessfully to initialize replication to complete as snapshot agent always stops with this error: This ...Unanswered | 2 Replies | 48 Views | Created by philfactor - Thursday, July 20, 2017 7:17 PM | Last reply by philfactor - 11 hours 41 minutes ago -
0 Votes
Re initiating the subscription
Hi All, We are having SQL Replication where Publisher & distributor at our end and subscriber is at DR site. We have around 500GB data transferred to Subscriber but due to some ...Unanswered | 6 Replies | 78 Views | Created by Kaps84 - Thursday, July 20, 2017 4:25 AM | Last reply by Satish Kumar Gajula - 14 hours 46 minutes ago -
0 Votes
SQL replication problem
Microsoft.SqlServer.Replication.NativeSqlConnectionException: Conversion failed when converting date and/or time from character string. 2017-07-13 10:53:40.33 --- End ...Unanswered | 19 Replies | 175 Views | Created by target223 - Thursday, July 13, 2017 11:19 AM | Last reply by target222 - 21 hours 21 minutes ago -
0 Votes
Configure Replication on Ubantu/docker ; SQL Server 2017
Hi, Can you provide assistance on configuration of Snapshor/Transactional replication. I have installed and configured MS-SQL Server 2017 on docker and Ubantu, but I'm not getting ...Discussion | 1 Replies | 37 Views | Created by Ashwani.Pandey - 23 hours 54 minutes ago | Last reply by Olaf Helper - 23 hours 7 minutes ago -
0 Votes
Configure Replication on Ubantu/docker ; SQL Server 2017
Hi, Can you provide assistance on configuration of Snapshor/Transactional replication. I have installed and configured MS-SQL Server 2017 on docker and Ubantu, ...Proposed | 1 Replies | 32 Views | Created by Ashwani.Pandey - 23 hours 51 minutes ago | Last reply by Olaf Helper - 23 hours 7 minutes ago -
2 Votes
SQL Server 2017 Merge Replication
I have done some testing and development for SQL Server 2017 using Merge Replication. Although this works fine in a general term, I am wondering if there is a better ...Answered | 7 Replies | 137 Views | Created by Quentin.Samuelson - Wednesday, July 05, 2017 7:17 AM | Last reply by Ashwani.Pandey - 23 hours 58 minutes ago -
1 Votes
Windows account password change then replication error log
Hello, seniors. After changing the Windows password during replication operation, the following log is caught. How should we solve ...Answered | 3 Replies | 55 Views | Created by Jaegeun Kim - Thursday, July 20, 2017 2:10 AM | Last reply by Jaegeun Kim - Friday, July 21, 2017 3:26 AM -
0 Votes
Transaction replication
Hi I am new to the organization. There is a transaction replication on one DB 2008 to 2014 SE editions. Now I need to add other two database(200GB ) to replicate. How I could do that with out ... -
0 Votes
How to find the cause of conflicts and retires
Hi I have a main publication at present that has 3 subscriptions connecting in. At one of the subscribers, replication is taking around 6-7 ...Unanswered | 1 Replies | 33 Views | Created by SQL Noob88 - Thursday, July 20, 2017 4:32 PM | Last reply by Hilary Cotter - Thursday, July 20, 2017 4:40 PM -
0 Votes
SQL 2008 Cluster log reader agent issues
Ok so i'm fairly new to SQL and have been getting on reasonably well with a new clients existing infrastructure. A recent request was to enable transactional replication from a source system (2008 ...Unanswered | 2 Replies | 60 Views | Created by CJohns80 - Tuesday, July 18, 2017 9:06 AM | Last reply by CJohns80 - Tuesday, July 18, 2017 11:27 AM -
0 Votes
Another snapshot agent for the subscription or subscriptions is running, or the server is working on a previous request by the same agent.
Hi Guys, Could you please help me solve this issue. I have a merge replication between two databases. Every evening the job starts ...Proposed | 16 Replies | 9434 Views | Created by AleshaDBA - Thursday, September 15, 2011 8:19 AM | Last reply by SQLsloth - Monday, July 17, 2017 2:41 PM -
0 Votes
After reinitialization no new data arrives at subscriber database
<style type="text/css">p { margin-bottom: 0.1in; direction: ltr; line-height: 120%; text-align: left; }</style> At a customers site there is a replication that seems all ...Answered | 6 Replies | 271 Views | Created by Rudolf Swiers - Monday, July 10, 2017 10:04 AM | Last reply by Rudolf Swiers - Saturday, July 15, 2017 8:12 AM -
0 Votes
SQL Replication Agent Error.
OK here is a new one since RMO is not an option. I am working on getting a batch file to kick of replication. Batch file is fine. I am running into login failures. My Dev ...Unanswered | 7 Replies | 92 Views | Created by Mark A Morton - Friday, July 14, 2017 3:04 PM | Last reply by Mark A Morton - Friday, July 14, 2017 8:19 PM -
0 Votes
Article properties - Enable Memory Optimization fails due to Nullable Index
I set Enable Memory Optimization on a publication article and get the below error even though the table has a NOT NULL primary key. It does however have a Non-Clustered Index that ...Unanswered | 1 Replies | 68 Views | Created by OttoErago - Friday, July 14, 2017 3:43 PM | Last reply by Hilary Cotter - Friday, July 14, 2017 4:32 PM -
0 Votes
How to remove merge replication orphaned partition metadata
Using sql merge replication with pull subscriptions and filtered articles: When a subscription is no longer needed we delete it on the ...Proposed | 7 Replies | 92 Views | Created by nycfdtd - Friday, July 14, 2017 1:09 PM | Last reply by nycfdtd - Friday, July 14, 2017 3:51 PM -
1 Votes
TCP Provider: An existing connection was forcibly closed by the remote host. (Source: MSSQLServer, Error number: 10054) Get help: http://help/10054
Hi Team, we have 1 replication setup on production server.Publisher and distribution are on same server and subscriber is at other end. We are getting above error ...Unanswered | 2 Replies | 100 Views | Created by Anu321 - Friday, July 14, 2017 5:40 AM | Last reply by Hilary Cotter - Friday, July 14, 2017 10:04 AM -
0 Votes
Merge Replication - Disaster Recovery
I have inherited a large scale Merge Replication system. We have the Distributor and the Publisher on a 2012 SQL server which sits on a windows failover cluster. We have about 1200 ...Unanswered | 1 Replies | 96 Views | Created by Vittoria_Cali - Thursday, July 13, 2017 9:41 PM | Last reply by Hilary Cotter - Thursday, July 13, 2017 10:33 PM -
0 Votes
Selecting articles which contain certain properties
Hello! I'm having difficulty selecting articles which contain certain property criteria. For instance, my publication has hundreds of articles, however I am trying to select just ...Answered | 2 Replies | 92 Views | Created by Tommycat1313 - Thursday, July 13, 2017 3:38 PM | Last reply by Tommycat1313 - Thursday, July 13, 2017 4:14 PM -
0 Votes
Syncronizations timing out
Recently some synchronizations have been failing. This is only happening to specific subscribers. The last message shown in the replication monitor and in their local replication logs ...Unanswered | 27 Replies | 332 Views | Created by nycfdtd - Wednesday, July 05, 2017 5:35 PM | Last reply by nycfdtd - Thursday, July 13, 2017 3:02 PM -
0 Votes
Updatable Subscriptions for Transactional Replication - Is Enterprise required?
I know this feature was "deprecated" in SQL Server 2012, but we are still able to create these using T-SQL. Also according to this link on the Microsoft Docs this feature ...Unanswered | 2 Replies | 102 Views | Created by flanagak - Wednesday, July 12, 2017 8:26 PM | Last reply by flanagak - Wednesday, July 12, 2017 8:59 PM - Items 1 to 20 of 11327 Next ›
