Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Quick Replication question Expand / Collapse
Posted Friday, May 31, 2013 8:19 AM


Group: General Forum Members
Last Login: Tuesday, February 3, 2015 8:25 AM
Points: 194, Visits: 432
Hey guys,

Quick question: Will running the distribution job for snapshot replication lock the Publisher tables?

Details: I have 2 SQL Server 2008 servers using Snapshot replication...I set this up 2 days ago and it has failed the past 2 nights...Last night when it failed, it completed the snapshot but the distribution job failed due to having a sorted timestamp column in one of the tables...I did some research and found a work around for that error that includes adding –UseInprocLoader at the end of the bcp command... So my question is: I know that I cant run the snapshot agent during peak hours due to putting a table lock on all the tables, but since the snapshot job completed, I was wondering if I can add that command and re run the distribution agent during peak hours? Not worried about it locking at the Subscriber level, but absolutely cannot run it if it will put a lock on at the Publisher level!

Thank you in advance!
Post #1458716
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse