December 23, 2006 at 12:56 am
Hi ,
one of the article in transactional replication has got millions of records suddenly by business and distribution agent is not able to take those transaction (Pull Subscription) load,so it was advised to re-initialize the subscription and give the snapshot to fix the issue.
so looking advice if some body has better solution rather that re-initialize the subscription ,not sure if i can BCP the article Manually at subscriber and then run snapshot so it will match the LSN or not.
Thanks in advance.
December 23, 2006 at 10:57 pm
If you can efford to be table offline, I will prefer to use initialization of subscription...
If you don't want to initialize then try chaging the profile...
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx
MohammedU
Microsoft SQL Server MVP
December 23, 2006 at 11:19 pm
Thanks for your reply , changing profile like increasing time out and other settings did not work , sorry ,for taking table offline what does it mean ,please confirm if you mean to say drop the existing article and add it again back?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply