-
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 | 52975 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
Merge Replication not deleting unmatched filter rows from Subscriber Database
I have applied filters on articles in SQL Merge Replication and syncing the data using MergeSynchronizationAgent via Web Synchronization. The data is syncing as per the applied filters from ...Unanswered | 1 Replies | 93 Views | Created by M0Bilal - 15 hours 48 minutes ago | Last reply by Gonzalo Bissio - 6 hours 52 minutes ago -
0 Votes
Replication - Identifying What Account Distributor is running under
Fellow SQLers. sql 2016 Have setup Replication. All is running fine. Noticed that the replication SQL Agent jobs (ie. snapshot, logreader, ...Answered | 4 Replies | 424 Views | Created by mg101 - Friday, December 6, 2019 10:53 PM | Last reply by mg101 - 8 hours 47 minutes ago -
0 Votes
Max text replication Size - Interpretation
Fellow SQLers. We just started setting up replication. Realized that Max text replication Size was set to default of 65536. We have since ...Answered | 2 Replies | 314 Views | Created by mg101 - Thursday, December 5, 2019 12:42 PM | Last reply by mg101 - Thursday, December 5, 2019 3:56 PM -
0 Votes
An existing connection was forcibly closed by remote host
Hi All,<o:p></o:p> There is connection issue while trying to connect remote SQL server SQL 2016 hosted on Windows 2016 ...Answered | 7 Replies | 729 Views | Created by Lakshmipathi Machineni - Wednesday, November 20, 2019 4:11 PM | Last reply by Lakshmipathi Machineni - Wednesday, December 4, 2019 5:02 PM -
2 Votes
data is not replicating from publisher to subscriber.
I configured transactional replication. However, data is not replicating from publisher to subscriber. I have attached screenshots of errors. Could you please ...Proposed | 5 Replies | 348 Views | Created by juniorkiran - Tuesday, December 3, 2019 2:48 PM | Last reply by Hilary Cotter - Tuesday, December 3, 2019 4:24 PM -
0 Votes
Cannot generate a snapshot after removing articles
We've had a working publication in place for some years now. I started to receive this error after I unchecked 3 articles from the Publication Properties dialog. These 3 tables ...Answered | 3 Replies | 706 Views | Created by nycfdtd - Friday, November 29, 2019 3:17 PM | Last reply by nycfdtd - Monday, December 2, 2019 4:36 PM -
0 Votes
how to Add new columns to existing article in transactional replication without reinit
transnational replication already available for tableA with minimum column . now i need to add one more column to existing article tableA . shall i directly enable ...Proposed | 1 Replies | 475 Views | Created by KIRUBAKARAN J A - Thursday, November 28, 2019 6:27 AM | Last reply by Dedmon Dai - Friday, November 29, 2019 6:56 AM -
0 Votes
Replica for reporting in another location
Hello, I have a problem with users who refreshing SQL query in Excel few times per day. Some queries are heavy and it clog our SQL server. We have central ...Unanswered | 6 Replies | 843 Views | Created by Doomus - Sunday, November 24, 2019 1:04 PM | Last reply by Cris Zhan - Thursday, November 28, 2019 2:15 AM -
0 Votes
Question on Rebuilding existing DB Replication to New Servers
Fellow SQLers. I am looking for some suggestions for this scenario. We have Server A on SQL 2008 R2. It has the db and distributor. Server B is the subscriber - ...Unanswered | 6 Replies | 780 Views | Created by mg101 - Thursday, November 7, 2019 6:35 PM | Last reply by mg101 - Tuesday, November 26, 2019 3:43 PM -
0 Votes
Replication - servers host name change.
we have 1 publication server & subscription server. ( all are in same Vnet) we are going to change this Publication server & subscription server (hostname). is this affect ...Proposed | 3 Replies | 579 Views | Created by KIRUBAKARAN J A - Friday, November 22, 2019 1:44 PM | Last reply by Liweiyin - Tuesday, November 26, 2019 12:44 AM -
0 Votes
Best Way to Upgrade SQL Server Replication Servers
I have a 3 server transactional replication configuration: Server A (SQL 2008R2 and WinSvr 2008R2) is a publisher of database DB1. It is a business critical OLTP VM which is ...Unanswered | 2 Replies | 549 Views | Created by KathyGibson - Thursday, November 21, 2019 7:51 PM | Last reply by KathyGibson - Friday, November 22, 2019 6:31 PM -
0 Votes
Cannot drop server because it is used as a Subscriber to remote Publisher in replication.
Trying to remove replication from a test environment and have the pubs/subs all removed but when i try to remove the distributor by running sp_dropdistpublisher, I get the error above. I have tried ...Answered | 10 Replies | 4581 Views | Created by Abeljdang - Thursday, September 28, 2017 7:50 PM | Last reply by W.W. Anderson - Thursday, November 21, 2019 5:53 PM -
0 Votes
SQL Server 2019: Logreader broken
The transactional log reader seems to be broken in sql server 2019 RTM. I upgraded my test environment and run in the problem that the second step in the sql server agent job (run ...Discussion | 3 Replies | 682 Views | Created by AberleC - Tuesday, November 12, 2019 10:38 AM | Last reply by Liweiyin - Wednesday, November 20, 2019 5:35 PM -
0 Votes
Netbackup interfering with SQL server log shipping/replication
Hi We currently have Netbackup configured on our Production database and we can thereby shrink the logfile size so it does not keep ...Proposed | 1 Replies | 616 Views | Created by RajGulati - Tuesday, November 19, 2019 7:17 PM | Last reply by Cathy Ji - Wednesday, November 20, 2019 6:01 AM -
1 Votes
How does DBCC CHECKDB use tempdb?
I would like to know the working principle of DBCC regarding the tempdb. I want to know why it uses tempdb for what purpose. I didn't find any advanced article about that so maybe someone ...Answered | 1 Replies | 677 Views | Created by RaufDBA - Tuesday, November 19, 2019 6:52 AM | Last reply by Shanky_621 - Tuesday, November 19, 2019 7:25 AM -
0 Votes
Replication- table replication with filter
hi, we have transactional replication from serverA to ServerB , accounttable to accounttable. (publication contains 130 articles). as of now all ...Proposed | 4 Replies | 808 Views | Created by KIRUBAKARAN J A - Sunday, November 17, 2019 7:58 AM | Last reply by Cathy Ji - Tuesday, November 19, 2019 2:09 AM -
0 Votes
what is the difference between replication options proc exec and definition only?
I understand proc exec option as for example when you run a procedure which inserts 1000 records into table, those inserts afterwards (after they were ...Answered | 3 Replies | 702 Views | Created by RaufDBA - Monday, November 18, 2019 12:53 PM | Last reply by Hilary Cotter - Monday, November 18, 2019 7:49 PM -
1 Votes
Is subscription database considered as read-only?
I am not sure about that because while users implement SELECT from subscription database, publisher replicates data to the subscription server meaning that INSERT and UPDATE also take ...Answered | 2 Replies | 550 Views | Created by RaufDBA - Monday, November 18, 2019 12:57 PM | Last reply by Hilary Cotter - Monday, November 18, 2019 2:43 PM -
0 Votes
SQL application aware replication
Hello I have an on-prem SQL server 2016 which uses to my web application. This SQL server also has other databases/tables as well. So I want to replicate only the changes in my ...Proposed | 4 Replies | 855 Views | Created by Sin_diss - Wednesday, November 13, 2019 5:50 AM | Last reply by Dedmon Dai - Monday, November 18, 2019 7:31 AM -
0 Votes
Transactional Replication - Disaster Recovery Steps
Hi, We have SQL2016 server with multiple databases and we have some of the databases using the Transactional replication and the subscriber and distributor is in same data ...Unanswered | 3 Replies | 621 Views | Created by Kutty_123 - Thursday, November 14, 2019 4:45 PM | Last reply by Tom Phillips - Friday, November 15, 2019 5:59 PM - Items 1 to 20 of 11978 Next ›
