Publisher is sql server 2008 R2 SP2
Remote distrbutor is sql server 2008 R2 SP2
For snapshot folder I am using UNC path and all permissions are granted properly.
We have 92 tables for publication. I created test snapshot for 10 articles and synchronized subscription. It worked successfully. So, I added remaining 82 tables and reinitialized subscription with creating new snapshot.
It is consistently failing at 99%. I get the following error and snapshot agent retries and start all over, again reaches 99%, fails and retries.
I again brought the no of articles down to 20, created new snapshot and synchronized subscription. It worked successfully without issue. Again added remaining tables back, snapshot agent started retrying after reaching 99%.
So, at least I know that permissions are ok. Drive where UNC folder is 1TB. Total table size is less than 70 GB. So, we have plenty of space. we have other replication in the environmet with more than 1 TB data synchronizing. So, I know size is not an issue. It probably has something to do with time elapsed while snapshop agent bcp data out. But what?
Any idea what should I look for or what needs to be changed?
I came across some articles regarding 'Initial snapshot failes due to network caching redirect on snapshot folder' but they were applicable only to sql server 2000 and 7.0 vs I am on version 2008 R2.
Message: The specified network name is no longer available.
Stack: at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.ThrowNativeBcpOutException(CConnection* pNativeConnectionWrapper)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.NativeBcpOutProvider.BcpOut(String strBcpObjectName, String strBcpObjectOwner, String strBaseBcpObjectName, Boolean fUnicodeConversion, String strDataFile, String strLoadOrderingHint, String strWhereClause, Boolean useTableLockHint, Int32 bcpFileFormatVersion)
at Microsoft.SqlServer.Replication.Snapshot.SqlServer.BcpOutThreadProvider.DoWork(WorkItem workItem)
at Microsoft.SqlServer.Replication.AgentCore.BaseAgentThread.AgentThreadProcWrapper() (Source: MSSQLServer, Error number: 0)
Get help: http://help/0