No announcements
Found 2389531 threads
-
0 Votestransactional replication locks
The first step in the snapshot application process is to drop all replicated tables which are part of that subscription.Answered | 6 Replies | 1943 Views | Created by Rani_Van - Friday, March 21, 2014 8:43 PM | Last reply by Rani_Van - Tuesday, March 25, 2014 2:43 PM
-
0 Votes
Stop Transactional Replication during/after Reinitialization from Snapshot
Basically before the first row of data comes over from the publisher the post snapshot script will run.Answered | 3 Replies | 7822 Views | Created by Bortiquai - Friday, October 21, 2011 4:24 PM | Last reply by Hilary Cotter - Monday, October 24, 2011 10:24 PM -
2 Votes
Initial snapshot in Transactional replication
First check Snapshot agent status, is snapshot generated with all articles?Answered | 2 Replies | 1016 Views | Created by The real Slartibartfast - Friday, February 27, 2015 11:15 AM | Last reply by The real Slartibartfast - Tuesday, March 3, 2015 10:37 AM -
0 Votes
Is it possible to converting Snapshot replication to Transactional replication
No, there is no way to convert Snapshot Replication to Transactional Replication on the fly.Answered | 5 Replies | 2426 Views | Created by Ali_Hum - Friday, February 7, 2014 9:09 PM | Last reply by Ali_Hum - Monday, February 10, 2014 3:11 PM -
0 Votes
Snapshot job usuage in transactional ( oneway) replication
Hello SQLDBA_1, The Distribution Agent is used with snapshot replication and transactional replication.Answered | 3 Replies | 1559 Views | Created by SQLDBA_1 - Saturday, October 12, 2013 7:55 AM | Last reply by udhayan - Sunday, October 13, 2013 8:34 AM -
1 Votes
Snapshot Error When Adding Article to Transactional Replication
After I getting rid of the offending rows via SQL script as you suggested, I was able to add tables to my transactional replication setup without issue.Answered | 6 Replies | 1674 Views | Created by John V. Barone - Friday, June 13, 2014 3:31 PM | Last reply by John Barone - Tuesday, June 17, 2014 7:02 PM -
0 Votes
Error: MS SQL Server Transactional Replication with Pull Subscription
SInce PULL distirbution agents run on the subscriber does the subscriber service account have access to the snapshot folder?Answered | 4 Replies | 9178 Views | Created by Senthil Kumar Palanisamy - Tuesday, October 4, 2011 5:00 AM | Last reply by Senthil Kumar Palanisamy - Monday, October 10, 2011 6:57 AM -
0 Votes
Snapshot replication pull model
The Snapshot Agent runs at the Distributor.Answered | 1 Replies | 2019 Views | Created by Asi Pesa - Sunday, June 2, 2013 2:08 PM | Last reply by Brandon Williams - Monday, June 3, 2013 4:31 AM -
0 Votes
Merge replication: Files in snapshot folder are locked
Hi Franky, Normally, if a process acquires an exclusive lock on a file, once it closes the file, the lock should be released.Answered | 3 Replies | 1321 Views | Created by Franky Piferoen - Tuesday, December 1, 2015 4:00 PM | Last reply by Franky Piferoen - Tuesday, December 22, 2015 9:09 AM -
0 Votes
Does initial snapshot process lock tables when setting up transactional replication?
You can follow the instructions in the below articles to set up transactional replication with T-SQL.Answered | 5 Replies | 3160 Views | Created by Sidney L - Wednesday, September 2, 2015 6:49 PM | Last reply by Lydia Zhang - Friday, September 4, 2015 5:20 AM -
0 Votes
Recreate Snapshot Job - Transactional Replication
Check out this, it may help you.Answered | 2 Replies | 4133 Views | Created by btrowdy19 - Friday, May 18, 2012 5:42 PM | Last reply by lindaEtechi - Saturday, May 19, 2012 9:37 AM -
0 Votes
Transactional Replication - SQL Server 2012
If it during snapshot application?Answered | 5 Replies | 2018 Views | Created by vensyd - Thursday, February 27, 2014 2:40 AM | Last reply by Hilary Cotter - Thursday, February 27, 2014 2:37 PM -
2 Votes
Transactional Replication - Slow running sp_MSget_repl_commands
We have three transactional replications, but this problem concerns only one.Answered | 7 Replies | 11806 Views | Created by Stuart R Fraser - Friday, August 16, 2013 2:23 AM | Last reply by db_admin23 - Tuesday, March 31, 2015 2:35 PM -
1 Votes
Skip snapshot delivery in transactional replication
I run into a situation where the schema generated by the snapshot agent was for all articles and this is not what we needed (we needed a snap just for 2 new ...Answered | 4 Replies | 1173 Views | Created by Yaniv Etrogi - Monday, February 9, 2015 3:49 PM | Last reply by Yaniv Etrogi - Tuesday, February 17, 2015 10:24 AM -
0 Votes
Replication doesnt update after rebuilding and new snapshot
If you are using Transactional Replication, please follwo the steps as described in below ...Answered | 1 Replies | 5994 Views | Created by dbomb01 - Tuesday, July 26, 2011 10:12 AM | Last reply by Srivastava Vishal - Tuesday, July 26, 2011 1:23 PM -
0 Votes
SQL 2005 Transactional Replication
Allow Pull is True Allow anonymous is False.Answered | 5 Replies | 6985 Views | Created by Matt Beach - Monday, July 26, 2010 10:00 PM | Last reply by Wissam Kosseifi - Wednesday, July 28, 2010 6:49 PM -
0 Votes
Minimizing Locks during Transactional replication Snapshots - I'm running out of hair to pull
Should I avoid moving DDL across so that the Snapshot does not have to meddle with FKs and triggers and keep a minimal footprint?Unanswered | 4 Replies | 1921 Views | Created by RayG - Monday, May 11, 2015 8:57 PM | Last reply by Xabier Ochotorena - Tuesday, April 7, 2020 6:18 PM -
0 Votes
Question on Snapshot replication.
If you made this change on the publisher and replicate_dll is set to true the change should be replicated to the subscriber the next time your log reader agent and distribution agent ...Answered | 2 Replies | 2426 Views | Created by Moug45 - Monday, July 22, 2013 1:27 PM | Last reply by Moug45 - Wednesday, July 24, 2013 3:47 PM -
0 Votes
Transaction replication blocking
Disabling lock escalation will help here - if table level locks are being held.Answered | 3 Replies | 5859 Views | Created by oleolehoohoo - Friday, October 3, 2014 6:11 PM | Last reply by Hilary Cotter - Sunday, October 5, 2014 3:53 PM -
0 Votes
Replication: periodic initial snapshot not yet available
We have a Transactional replication Push with updatable subscirber and then have Transactional replication.Answered | 35 Replies | 33500 Views | Created by Piotr Ignaczak - Thursday, August 10, 2006 9:12 PM | Last reply by Dinesh Asanka - Saturday, May 19, 2012 5:08 AM - Items 1 to 20 of 2389531 Next ›
No announcements
