 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Replication / October 2006FTP Snapshot errors
Hi, I'm hoping for some insight into this problem. We have Merge Replication setup over FTP and has been working without issues. The last database update we generated a new snapshot and has cause problems since. The snapshot generates fine. When we synchronize uses get the infamous "The schema script 'xxx.bcp" -hORDER([ID] ASC)' could not be propagated to the subscriber. This particular .bcp file is 10, 978 KB. When I watch the synch going, it creates a folder in windows\temp and I can see this file downloading, it stops at 10,976 and then for whatever reason strarts the whole download process from 0 of this file again to then stop at the same place. On the 3rd time it finally stops and I get that error. I've tried compressing the snapshot, same thing, on sych, it brings down the .cab file but it's as if it can't execute it. This is causing problems as only a selected few can synchronize. It's running on SQL Server 2005. Regards bcomeau the bcp operation in SQL 2005 will automatically restart on failure. Can you try to manually bcp the data in the subscriber and see what error message you are getting?  SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Hi, > [quoted text clipped - 16 lines] > > bcomeau Could you give me an example of the command line syntax, I've tried a few but unable to get it to work. "SQL Server does not exist or access is denied" > the bcp operation in SQL 2005 will automatically restart on failure. Can you > try to manually bcp the data in the subscriber and see what error message [quoted text clipped - 34 lines] > > > > bcomeau Locate the script xxx.bcp the do this bcp "MySubscriptionDatabase.Dbo.XXX" in xxx.bcp -S MySubscriber -T -n -E -hORDER([ID] ASC) The above will work if the account you are currently logged in with has rights to connect to the subscriber with. If not do this bcp "MySubscriptionDatabase.Dbo.XXX" in xxx.bcp -S MySubscriber -U AnAccountOnTheSubscriber -P ThePasswordforThatAccount -n -E -hORDER([ID] ASC) SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. Looking for a SQL Server replication book? http://www.nwsu.com/0974973602.html Looking for a FAQ on Indexing Services/SQL FTS http://www.indexserverfaq.com > Could you give me an example of the command line syntax, I've tried a > few but unable to get it to work. "SQL Server does not exist or access [quoted text clipped - 39 lines] >> > >> > bcomeau Could you give me an example of the command line syntax, I've tried a few but unable to get it to work. "SQL Server does not exist or access is denied" > the bcp operation in SQL 2005 will automatically restart on failure. Can you > try to manually bcp the data in the subscriber and see what error message [quoted text clipped - 34 lines] > > > > bcomeau I"m not sure if this is related, but everybody who applied the last round of Microsoft updates are having the problem, I know that people who haven't done a Windows update in a while is working without glitches > the bcp operation in SQL 2005 will automatically restart on failure. Can you > try to manually bcp the data in the subscriber and see what error message [quoted text clipped - 34 lines] > > > > bcomeau I"m not sure if this is related, but everybody who applied the last round of Microsoft updates are having the problem, I know that people who haven't done a Windows update in a while is working without glitches > the bcp operation in SQL 2005 will automatically restart on failure. Can you > try to manually bcp the data in the subscriber and see what error message [quoted text clipped - 34 lines] > > > > bcomeau |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.