-
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 | 47565 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
Transactional Replication - Distributor
Hello: I have SQL Server 2008 R2 Transactional Replication setup & i am seeing that Distributor database is consuming 60% of the MAX ...Unanswered | 11 Replies | 134 Views | Created by aaditya2000 - Wednesday, October 18, 2017 11:32 PM | Last reply by Hilary Cotter - 13 hours 29 minutes ago -
0 Votes
Replication snapshot error - Value cannot be null Parameter name: strObjectName
System.ArgumentNullException: Value cannot be null. 2017-10-04 08:20:57.52 Parameter name: strObjectName 2017-10-04 08:20:57.52 at ...Unanswered | 9 Replies | 262 Views | Created by Dr KP Hussain - Wednesday, October 04, 2017 12:30 PM | Last reply by Hilary Cotter - 13 hours 45 minutes ago -
0 Votes
Always ON and Replication subscribers
Subscriber for 20+ servers over different databases. All these DBs will be joined in one AG Group and Server B will be asynchronous replica. trying to find out if there is ...Answered | 5 Replies | 147 Views | Created by SQLmaddy - Friday, October 13, 2017 10:40 AM | Last reply by SQLmaddy - Thursday, October 19, 2017 11:02 AM -
2 Votes
SQL Server 2016: Bidirectional Transactional Replication using Backup, Do I use/need Snapshot?
**Overview:** I have been setting up bidirectional transactional replication between 2 SQL Servers. We have another pair of servers, running Inductive ...Unanswered | 8 Replies | 169 Views | Created by dc_sanityworx - Wednesday, October 11, 2017 7:15 PM | Last reply by Teige Gao - Thursday, October 19, 2017 1:43 AM -
0 Votes
SQL 2016 Replication problem with compatibility level
I have three server SQL 2016 SP1 CU5 Developer edition. On this servers I have configured transaction replication. One server I use for distributor, one for publisher, one for subscriber. All database ...Proposed | 15 Replies | 186 Views | Created by Maty M - Tuesday, October 10, 2017 7:19 AM | Last reply by Hilary Cotter - Friday, October 13, 2017 1:59 PM -
0 Votes
how to do peer-to-peer replication
Hi, i have one server. it is connecting through internet. client database is there in this server. i need one help, whatever records is there in server database ...Proposed | 1 Replies | 77 Views | Created by SSQL123 - Friday, October 13, 2017 6:51 AM | Last reply by Hilary Cotter - Friday, October 13, 2017 9:50 AM -
0 Votes
Replication agent stopped automatically
Start Synchronizing Why it hppens? What could be the reason. We didn't find any error. This is SQL Server 2008 R2.Proposed | 3 Replies | 117 Views | Created by S.Vijay Kumar - Thursday, October 12, 2017 10:22 PM | Last reply by Hilary Cotter - Friday, October 13, 2017 2:23 AM -
0 Votes
Log shipping to remote server not working
Secondary server (B) - Both servers running SQL 2008 R2 Standard - Both servers have a network shared folder but: ...Proposed | 11 Replies | 183 Views | Created by George Waters - Monday, October 09, 2017 7:43 PM | Last reply by Teige Gao - Thursday, October 12, 2017 7:59 AM -
2 Votes
Replicating to tables that have instead-of triggers on them.
Imagine I have three SQL Server instances, each with some "master" system. Perhaps one is an ERP, one is CRM, one is an HR system. Imagine, also, that I have no control over the schemas of ...Answered | 3 Replies | 114 Views | Created by allmhuran - Wednesday, October 11, 2017 7:26 AM | Last reply by allmhuran - Wednesday, October 11, 2017 11:46 PM -
0 Votes
Sync two database with deferent table?
Hi, I have this scenario: - On private database and one public database on same/deferent server - Both have deferents tables (user info table ...Answered | 11 Replies | 147 Views | Created by Ali Abdulhussein - Wednesday, October 11, 2017 8:52 AM | Last reply by Ali Abdulhussein - Wednesday, October 11, 2017 3:27 PM -
1 Votes
Replication vs CDC - performance, RBAR
In relation to the idea of populating an ODS, I am looking seriously into transactional replication for the first time. I should note that my enterprise already has CDC enabled on some ...Proposed | 5 Replies | 150 Views | Created by allmhuran - Wednesday, October 11, 2017 2:05 AM | Last reply by Hilary Cotter - Wednesday, October 11, 2017 2:33 PM -
1 Votes
What is meant by "SQL 2016 does not support..."
Good morning, I've been looking at some replication options and have come across a quote which i find quite ...Answered | 7 Replies | 147 Views | Created by AndyB1978 - Tuesday, October 10, 2017 8:36 AM | Last reply by Teige Gao - Wednesday, October 11, 2017 4:56 AM -
0 Votes
Replication - The Process Cound Not Connect to the Subscriber
BACKGROUND I am attempting to set up transaction-based replication between two nodes that reside on different networks. In both instances I am using SQL Server 2012. I have ...Proposed | 5 Replies | 111 Views | Created by cfnoob - Tuesday, October 10, 2017 7:44 PM | Last reply by Hilary Cotter - Tuesday, October 10, 2017 8:59 PM -
0 Votes
Merge replication copies Filestream (large blobs) to subscriber or just referenced?
Hi All, I am exploring SQL server replication feature. After reading through few articles and blogs, I am sure that I will be using merge replication for my work. However, I could ...Proposed | 3 Replies | 105 Views | Created by Tejas Gajera - Tuesday, October 10, 2017 2:55 PM | Last reply by Hilary Cotter - Tuesday, October 10, 2017 5:42 PM -
0 Votes
Problem with Agent Security Credentials on Replications
Hi Experts, I have configured the distributor to initiate the replication. I have created to replication on Publisher with my user credentials (in the agent security) for process ...Answered | 5 Replies | 134 Views | Created by chandu.muzik - Monday, October 09, 2017 1:50 PM | Last reply by Hilary Cotter - Tuesday, October 10, 2017 2:54 PM -
0 Votes
MsMerge_genhistory has alot of rows with pubid = null
I have a merge replication and I am worried that the cleanup of metadata might not be enough. I have a retention period of 60 days and I can see thet the metadatacleanup-job do remove rows i ...Answered | 6 Replies | 292 Views | Created by Dratskapoo - Tuesday, September 26, 2017 2:44 PM | Last reply by Dratskapoo - Friday, October 06, 2017 2:56 PM -
0 Votes
Wrong conflicts in merge replication
Hi, Now and than I'm getting wrong merge replication conflict. Conflict with one of the old records. My Replication retention period is set to 5 days. How kan I solve ...Unanswered | 4 Replies | 233 Views | Created by gm011 - Tuesday, September 19, 2017 8:31 AM | Last reply by gm011 - Thursday, October 05, 2017 1:52 PM -
0 Votes
Approximate Time to Migrate 80GB data to New server
Hi Experts, I was asked to give a migration plan of entire stuff which should be from one server to other. We have the new server specifications as (Windows Server 2012 R2 Standard, ...Proposed | 1 Replies | 135 Views | Created by chandu.muzik - Wednesday, October 04, 2017 9:23 AM | Last reply by Hilary Cotter - Wednesday, October 04, 2017 10:06 AM -
0 Votes
Verbose File
Hello: In log reader verbose file i am seeing 2 entry of ReadBatchSize. In Agent profile value for -ReadBatchSize - 500 So i am confused with ...Proposed | 1 Replies | 174 Views | Created by aaditya2000 - Saturday, September 30, 2017 6:55 PM | Last reply by Lin Leng - Tuesday, October 03, 2017 5:03 AM -
0 Votes
Transactional Replication - Tlog File
Hello: I have 2 Tlog files in Transnational Replication. While my replication is active & in progress can i do DBCC SHRINKFILE with ...Answered | 2 Replies | 175 Views | Created by aaditya2000 - Saturday, September 30, 2017 9:27 PM | Last reply by aaditya2000 - Monday, October 02, 2017 11:14 PM - Items 1 to 20 of 11422 Next ›
