No announcements
Found 1236089 threads
-
0 VotesUpdation of subscriber tables in standard transaction replication
Hi, Does standard transaction replication will do any checksum comparision on subscriber data before replicating update statements?Answered | 1 Replies | 3869 Views | Created by SRIRED - Monday, September 19, 2011 6:29 PM | Last reply by Hilary Cotter - Monday, September 19, 2011 6:33 PM
-
0 Votes
Transactional Replication with 2 subscriber issue
I was able initialize from a backup and have pending transactions that occurred after the backup was taken delivered to the Subscriber with the following ...Answered | 7 Replies | 3109 Views | Created by Adminanup - Friday, August 24, 2012 4:53 AM | Last reply by Brandon Williams - Monday, August 27, 2012 1:05 AM -
0 Votes
Transactional Replication - Subscriber Identity Seed?
If the publisher goes offline, the subscriber should be failed over to queued updating where the changes will be queued on the subscriber, until the publisher ...Answered | 2 Replies | 1880 Views | Created by paullyie - Monday, February 22, 2016 3:45 PM | Last reply by Hilary Cotter - Wednesday, March 2, 2016 1:39 AM -
0 Votes
Open Transaction on the Subscriber Server - Transactional Replication
Yes, but notice the process status will be 'sleeping' when no transactions are being distributed and 'runnable' or 'running' when there are ...Answered | 3 Replies | 4200 Views | Created by Fazlu - Wednesday, July 11, 2012 10:24 AM | Last reply by Brandon Williams - Wednesday, July 11, 2012 4:43 PM -
0 Votes
Difference between peer-to-peer and updatable subscriber in Transactional replication
Updateable Subscribers is somewhat more scalable than p2p.Answered | 2 Replies | 1055 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
Transaction replication distributor to subscriber is pending status
Then we can add manually to subscriber site.Answered | 11 Replies | 2143 Views | Created by ashwan - Wednesday, February 27, 2019 11:31 PM | Last reply by AV111 - Thursday, March 21, 2019 3:40 PM -
0 Votes
synchronization between publisher and subscriber in Transactional replication
You should avoid publishing unnecessary tables and consider updating publications less frequently.Answered | 3 Replies | 2469 Views | Created by udhayan - Wednesday, July 17, 2013 2:56 PM | Last reply by Fanny Liu - Wednesday, July 24, 2013 10:57 AM -
2 Votes
Removing subscriptions from the subscriber at transactional push replication
But I'm interested in the query from the subscriber, which might not be accurate (after removing replication we still see it from the subscriber side).Answered | 8 Replies | 5870 Views | Created by Asi Pesa - Wednesday, May 2, 2012 6:38 AM | Last reply by Asi Pesa - Thursday, October 4, 2012 4:50 AM -
0 Votes
Conflict on transactional replication with subscriber updates; conflict_policy is 'pub wins'
Brandon Williams (blog | linkedin)Answered | 1 Replies | 2694 Views | Created by Gabriel Billington - Friday, October 5, 2012 8:25 PM | Last reply by Brandon Williams - Saturday, October 6, 2012 1:01 AM -
0 Votes
Transactional replication errored out as subscriber is corrupt
Hi Kamal, Restore with the latest backups and start replication, if there are any updates happened at Publisher end when the subscriber was ...Answered | 6 Replies | 1225 Views | Created by oleolehoohoo - Wednesday, July 16, 2014 11:12 AM | Last reply by SQL DBA1 - Thursday, July 17, 2014 4:13 PM -
0 Votes
Changing transactional replication subscriber settings
Hi, We have plenty of one way transactional replication publishers and pull subscribers.Answered | 2 Replies | 1163 Views | Created by jori5 - Monday, November 16, 2015 7:42 PM | Last reply by Hilary Cotter - Tuesday, November 17, 2015 3:34 PM -
0 Votes
Restore transactional replication subscriber database to different server
Restore subscriber using this method: http://technet.microsoft.com/en-us/library/hh882436.aspx Excellent transaction ...Answered | 6 Replies | 1860 Views | Created by Pixilated_1 - Tuesday, January 14, 2014 4:11 PM | Last reply by Pixilated_1 - Tuesday, January 21, 2014 11:58 AM -
1 Votes
Transactional replication very slow with indexes on Subscriber table
@Brandon: the Subscriber system is the same system as the previous replication set was on.Answered | 5 Replies | 2745 Views | Created by Megens75 - Wednesday, May 14, 2014 6:48 AM | Last reply by Ed at Hammar Technology - Thursday, May 15, 2014 5:23 PM -
1 Votes
SQL Server Transactional Replication (No Subscriber Update): DB Maintenance Question
So if I backup my tlog for my publication database, the log reader will read the transactions out of the publication database, mark the transactions as ...Answered | 3 Replies | 2500 Views | Created by JimAzSQL2 - Wednesday, October 10, 2012 9:10 PM | Last reply by Hilary Cotter - Friday, October 12, 2012 1:05 PM -
3 Votes
SQL Server Transactional Replication (No Subscriber Update): DB Restore Question
The KEEP_REPLICATION option is intended to restore replicated databases to other servers and preserve the replication settings, that is not going to help you in this case as ...Answered | 2 Replies | 2718 Views | Created by JimAzSQL2 - Wednesday, October 10, 2012 9:11 PM | Last reply by JimAzSQL2 - Wednesday, October 10, 2012 10:45 PM -
0 Votes
Replicating Views In Transactional Replication
No you cannot.Answered | 3 Replies | 7278 Views | Created by Roger9955 - Friday, July 23, 2010 3:04 PM | Last reply by sap99 - Saturday, July 24, 2010 10:19 PM -
0 Votes
Transactional Replication
Merge replication, like transactional replication, typically starts with a snapshot of the publication database objects and data.Answered | 2 Replies | 1228 Views | Created by sureshg.g26 - Monday, March 10, 2014 10:46 AM | Last reply by tracycai - Wednesday, March 12, 2014 2:30 AM -
0 Votes
MSSQL Transactional replication for HA
As you are using transactional replication with updateable subscriptions data movement will be both ways.Answered | 5 Replies | 1160 Views | Created by Aliasgar Lokhandwala - Monday, October 2, 2017 10:01 AM | Last reply by Hilary Cotter - Thursday, November 30, 2017 2:45 PM -
0 Votes
clustered columnstore Index on subscriber - replication - performance
the transactional replication performance went down and it seems, it was performing badly while doing updates.Answered | 11 Replies | 2003 Views | Created by Stan210 - Saturday, February 13, 2016 7:45 PM | Last reply by Stan210 - Tuesday, February 23, 2016 3:55 PM -
0 Votes
Transactional replication issue
Was there any issue which caused replication to stop for some time or was there any huge updates that happened at publisher..Answered | 1 Replies | 1174 Views | Created by subbu1987 - Tuesday, July 22, 2014 9:26 AM | Last reply by Ashwin Menon - Tuesday, July 22, 2014 11:34 AM - Items 1 to 20 of 1236089 Next ›
No announcements
