-
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 | 47429 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
BCP Import From Snapshot Replication For Recovery
To start with, I used the following link as my base to start: Older Post Target server is SQL Server 2016, which is the Distributor and Subscriber. Source is ...Unanswered | 2 Replies | 28 Views | Created by KD-Bajan - 4 hours 18 minutes ago | Last reply by KD-Bajan - 7 minutes ago -
0 Votes
merge replication history analysis
We have a strange situation and i am hoping there is some way to see the exact time history of what occurred in replication. Merge replication, one publisher/distributor (SQL 2014 ...Unanswered | 5 Replies | 34 Views | Created by Darin Horton - 2 hours 18 minutes ago | Last reply by Hilary Cotter - 52 minutes ago -
0 Votes
Web Sync for merge replication
I have a problem with Web Replication. I have successfully set it up where IIS & SQL were on same server. I am now repeating the process but IIS is on its own internet ...Answered | 8 Replies | 196 Views | Created by David K - Tuesday, August 29, 2017 1:34 PM | Last reply by David K - Wednesday, September 20, 2017 4:15 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 | 2 Replies | 52 Views | Created by gm011 - Tuesday, September 19, 2017 8:31 AM | Last reply by gm011 - Wednesday, September 20, 2017 2:16 PM -
0 Votes
Merge Replication subscriber last_sync_date not changing
Hi All, Our merge replication is complex and is a centralized subscriber model but the business is not agreeing to change the topology. From last 4-5months we are ...Unanswered | 3 Replies | 68 Views | Created by kyarlapati - Tuesday, September 19, 2017 10:24 AM | Last reply by kyarlapati - Wednesday, September 20, 2017 11:06 AM -
0 Votes
Not able to restore sql2016 db to sql2012.
Hi, I want to restore a database from sql server 2016 to sql server 2012. I have changed compatibility level to sql server 2012 (110) while taking db backup from slq server 2016. ...Answered | 5 Replies | 121 Views | Created by Rangarao Darla - Tuesday, September 12, 2017 6:26 AM | Last reply by Atif-ullah Sheikh - Tuesday, September 19, 2017 7:27 AM -
1 Votes
Web Sync for merge replication
I have setup Web sync for merge replication, which was working fine for a while. However I now have an issue with replication where by it fails after downloading 3100 ...Unanswered | 3 Replies | 108 Views | Created by David K - Friday, September 15, 2017 4:25 PM | Last reply by David K - Monday, September 18, 2017 4:29 PM -
0 Votes
SQL Server Delta Records Pull & Push
Hi In our SQL Server DB, we have about some 800+ tables and there are 40 - 50 tables are business critical tables. MIS team needs to generate reports based ...Unanswered | 4 Replies | 116 Views | Created by KARTHIK214 - Friday, September 15, 2017 7:37 AM | Last reply by Tom Phillips - Monday, September 18, 2017 12:32 PM -
0 Votes
Distribution clean up is not removing the records
Hello, I have been facing a strange scenario. We are using Transactional replication in our environment. Recently we migrated the sql server to 2016 from 2008R. ...Unanswered | 4 Replies | 206 Views | Created by Mohd iRaffi - Thursday, September 07, 2017 8:34 AM | Last reply by Mohd iRaffi - Monday, September 18, 2017 8:30 AM -
0 Votes
@EstimatedDataLoss
Hi What exactly is the calculation logic/code behind the function/expression - @EstimatedDataLoss Helpsays its the number of seconds of transactions that have ...Unanswered | 5 Replies | 127 Views | Created by Gauri888 - Tuesday, September 12, 2017 5:13 AM | Last reply by Teige Gao - Monday, September 18, 2017 8:03 AM -
0 Votes
Snapshot replication does not copy default values in tables' fields
Hi, I have SQL 2008 R2 Standard in one side (Publisher) and SQL 2008 R2 Express in the other (Suscriber), the publication is a push type, but the tables at the suscriber lost ...Answered | 2 Replies | 88 Views | Created by George Waters - Saturday, September 16, 2017 8:58 PM | Last reply by George Waters - Saturday, September 16, 2017 10:08 PM -
0 Votes
how to check the Rebuild index status in sql server? --urgent
Hi All, I am facing the rebuild index issue. I have 2TB of database , we have configured the rebuild index before on wards i have put the database in simple ...Answered | 3 Replies | 18452 Views | Created by TSRam - Monday, July 01, 2013 11:37 AM | Last reply by TSRam - Friday, September 15, 2017 8:02 AM -
5 Votes
Trouble Messages in Transactional Replication Log
Hi. I hope someone can orient me about what this message means I am finding in a history log of a replication job. I have ...Answered | 7 Replies | 84 Views | Created by Alextroy - Thursday, September 14, 2017 11:07 AM | Last reply by Alextroy - Thursday, September 14, 2017 4:11 PM -
2 Votes
Best solution to provide read copy for MIS environment in SQL Server 2008R2
Hi, We require to create read copy for MIS purpose ( reporting). The domain is Telecom BSS and our DB size is around 250-500 GB. The DB has around 800+ tables. ...Proposed | 3 Replies | 132 Views | Created by Muthu V - Wednesday, September 13, 2017 1:24 PM | Last reply by Tom Phillips - Thursday, September 14, 2017 12:16 PM -
1 Votes
Replication monitor cannot connect to distributor
HI, I am getting below error when I try to connect replication monitor from both distributor and publisher. But there is no issue in launching the monitor when i connect it from any ...Unanswered | 1 Replies | 96 Views | Created by Mansoor Ali Jaffery - Monday, September 11, 2017 6:15 AM | Last reply by Teige Gao - Tuesday, September 12, 2017 6:37 AM -
0 Votes
Procedure name can not be start with sp_
Hi, I have setup a Transactional replication in SQL Server 2008 R2. I am using only Tables articles for the replication. Between Distributor to Subscriber i am getting ...Answered | 8 Replies | 187 Views | Created by Sheetal Prasad S - Sunday, September 10, 2017 4:36 PM | Last reply by Sheetal Prasad S - Monday, September 11, 2017 3:31 PM -
0 Votes
Failed to insert rows into Change Data Capture change tables
The process could not execute 'sp_replcmds' on ''. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help: http://help/MSSQL_REPL20011 Failed to insert rows ...Proposed | 1 Replies | 115 Views | Created by Kasturi Rajesh - Saturday, September 09, 2017 3:22 PM | Last reply by Teige Gao - Monday, September 11, 2017 7:43 AM -
0 Votes
CDC inserting more than one entries
My CDC table is This is the table dump of my cdc table. What i am not sure is there are multiple insert and delete operation at same time and with the timestamp, it look like ...Unanswered | 1 Replies | 134 Views | Created by SupriyaHegde - Sunday, September 10, 2017 8:08 AM | Last reply by Lin Leng - Monday, September 11, 2017 4:55 AM -
0 Votes
Problem with creation of pull subscription
I try to create new pull subscription to existing transactional replication. I executed sp_addsubscription with @subscription_type = N'pull' and @sync_type = N'none'. ...Answered | 3 Replies | 6102 Views | Created by andsm - Thursday, October 06, 2011 5:42 PM | Last reply by Shailesh_23 - Friday, September 08, 2017 9:51 AM -
0 Votes
two node sql server 2016 replicaton installation & configuration
sir I have two server node with OS windows 2012 R2 datacenter. I am purchase SQL server 2016 Enterprise core license. Now i ...Proposed | 3 Replies | 130 Views | Created by subhash chatterjee - Thursday, September 07, 2017 12:37 PM | Last reply by Shailesh_23 - Friday, September 08, 2017 9:47 AM - Items 1 to 20 of 11397 Next ›
