-
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 | 41463 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
Merge Replication The process could not connect to Distributor
I am attempting to test merge replication between servers on different workgroups. I have setup accounts with the lame logon on both server machines as well as in the SQL server. I have also set ... -
0 Votes
Change Data Capture, insert+delete instead of update
Hello everyone, I'm having an odd issue, that I need some help understanding. I've got a number of tables enabled for Change Data Capture, but I've noticed some behavior that ...Answered | 2 Replies | 117 Views | Created by Jarret - Wednesday, February 18, 2015 9:51 PM | Last reply by Jarret - Friday, February 27, 2015 9:53 PM -
0 Votes
Replication ceases working after adding table at publisher
Hi, I have a transactional replication between two SQL 2008 R2 which has been running fine for hours. I just added a new table in the publisher, added a PK and inserted ...Unanswered | 2 Replies | 47 Views | Created by The real Slartibartfast - Friday, February 27, 2015 5:24 PM | Last reply by Hilary Cotter - Friday, February 27, 2015 8:26 PM -
3 Votes
Relationship between subscription and agent job
Hi, When I create a transactional subscription (SQL 2008R2) I also get a SQL agent job. Is it safe to rename this agent job to something else as the name is awful and it ...Answered | 4 Replies | 45 Views | Created by The real Slartibartfast - Friday, February 27, 2015 3:16 PM | Last reply by The real Slartibartfast - Friday, February 27, 2015 3:39 PM -
0 Votes
Initial snapshot in Transactional replication
Hi, SQL 2008R2 Having a problem getting the initial load (snapshot?) of a database at the subscriber. I went through the wizard and selected ...Unanswered | 0 Replies | 48 Views | Created by The real Slartibartfast - Friday, February 27, 2015 11:15 AM -
0 Votes
Transaction replication Error
Hi, We are having a replication between two servers both are in SQL server 2000 standard edition. The service packs of both these are at different ... -
0 Votes
Switching Subscriber Distribution to an AG listener to support Subscriber Failover on existing replication
The article describes how to create a new Subscription from scratch referring to the AG listener. I am looking to alter an existing Subscriber / Distribution Agent to achieve the same. I ...Unanswered | 1 Replies | 50 Views | Created by RayG - Thursday, February 26, 2015 3:52 PM | Last reply by Cheer08 - Friday, February 27, 2015 8:12 AM -
0 Votes
Web sync error
It looks like I've run into a limit on batch size for the web sync using 2008 R2. I'm getting the following error the log. 2015-02-25 16:27:42.325 The format of a message ...Unanswered | 1 Replies | 50 Views | Created by deo.is - Thursday, February 26, 2015 9:01 PM | Last reply by Lydia Zhang - Friday, February 27, 2015 2:46 AM -
0 Votes
Multi-Server Transactional Replication
Hello. I have three servers, A,B, and C, with SQL Server 2005 SP4 (9.00.5266) installed on Windows Server 2003 R2 Standard x64 SP2. Server C has SQL Reporting Services installed ...Answered | 8 Replies | 150 Views | Created by skisdsupport - Friday, February 20, 2015 7:37 PM | Last reply by skisdsupport - Thursday, February 26, 2015 10:44 PM -
0 Votes
SQLWriter fails at PreRestore and PostRestore with error 0x800423f4 when SetAdditionalRestores is set true
SetAdditionalRestores(...., bAdditionalRestores=true) VSS Logs. [16:10:40.414 P:1668 T:18F8 BUECXMLC(1082) BUCOMP] ...Unanswered | 4 Replies | 93 Views | Created by LegendKiller2015 - Tuesday, February 24, 2015 4:39 PM | Last reply by LegendKiller2015 - Thursday, February 26, 2015 1:23 PM -
0 Votes
merge agent getting hung
Hi All, We have merge replication set up. We recently re initialized one of the subscription and it is completed successfully. But we see that it is not ...Unanswered | 1 Replies | 78 Views | Created by Khushi N - Thursday, February 26, 2015 11:28 AM | Last reply by dave_gona - Thursday, February 26, 2015 12:27 PM -
0 Votes
Replicate only changed and new data
Dear, Is there a possibility to SQL Server 2012, to all the changes that happen in the DB x record in DB y? DB x would have all the data, and ...Unanswered | 2 Replies | 81 Views | Created by Maty M - Wednesday, February 25, 2015 11:44 AM | Last reply by Maty M - Thursday, February 26, 2015 9:50 AM -
0 Votes
Network requirements for SQL Server Replication
Hi, Can any one tell me what is network requirements for SQL Server replication. I have successfully configured the replication on LAN with active directory but ...Proposed | 2 Replies | 70 Views | Created by Muhammad_Imran2002 - Wednesday, February 25, 2015 6:47 PM | Last reply by Lydia Zhang - Thursday, February 26, 2015 7:09 AM -
0 Votes
Difference between peer-to-peer and updatable subscriber in Transactional replication
Is peer-to-peer replication and updatable subscriber both one and the same Or is there any difference between them. Can anyone please let me know?Proposed | 2 Replies | 59 Views | Created by mad40yetng - Wednesday, February 25, 2015 8:10 PM | Last reply by Hilary Cotter - Wednesday, February 25, 2015 11:59 PM -
0 Votes
Dropping of replication failing during database deployment
"C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\Sql Package.exe" /a:script /SourceFile:"D:\DBFiles\**********.dacpac" ...Unanswered | 4 Replies | 69 Views | Created by aivoryuk - Wednesday, February 25, 2015 2:43 PM | Last reply by aivoryuk - Wednesday, February 25, 2015 8:18 PM -
0 Votes
New article will not replicate to subscriber
I have a very strange problem. I have an existing publisher/subscription, which is working perfectly. We added a new article using the SSMS 2012 GUI to the publication, ran ...Unanswered | 10 Replies | 85 Views | Created by Tom Phillips - Wednesday, February 25, 2015 3:46 PM | Last reply by Hilary Cotter - Wednesday, February 25, 2015 5:58 PM -
2 Votes
New table/column in publication breaks replication
Hi, SQL 2008R2 I added a control table to a database that is being replicated to a different server. The tabled called [__Updated] has one ...Answered | 5 Replies | 92 Views | Created by The real Slartibartfast - Tuesday, February 24, 2015 4:37 PM | Last reply by Hilary Cotter - Wednesday, February 25, 2015 3:55 PM -
0 Votes
Log Reader is getting Stopped in SQL replication
Hi All, We are having a oracle Publisher and distributor and subscriber is SQL SERVER. My Log reader service is getting failed showing below ...Proposed | 12 Replies | 128 Views | Created by Snehasis pattnaik - Monday, February 23, 2015 8:09 PM | Last reply by Hilary Cotter - Wednesday, February 25, 2015 3:50 PM -
0 Votes
SQL Azure Sync Agent
Hi, Is that anyone can share the firewall port and IP address communication on the SQL Azure Sync Agent requirement? Is the network communication bidirectional? ...Proposed | 1 Replies | 78 Views | Created by SQLAZURE2015 - Monday, February 23, 2015 1:31 AM | Last reply by Lydia Zhang - Wednesday, February 25, 2015 2:23 AM -
1 Votes
Network Domain Migration - Merge Replication
My company was recently acquired by a different Parent company. We are currently in the process of migrating from one Domain to the new one using a Microsoft tool called ADMT. I currently ...Proposed | 1 Replies | 60 Views | Created by 1Steve1 - Tuesday, February 24, 2015 5:06 PM | Last reply by Hilary Cotter - Tuesday, February 24, 2015 5:30 PM - Items 1 to 20 of 10339 Next ›
