The schema script could not be propagated to the subscriber
-
Thursday, April 26, 2012 8:05 PM
Hello - We are testing out our DR plan and ofcourse everything that could go wrong is going wrong! We are trying to simulate Merge replication from a SQL Server 2008 R2 standard edition onto a SQL Server 2005 Compact edition and we get the following error message. The exact same test scenario works absolutely fine in our production environment! We have checked pretty much everything between PROD and DR server and things are exactly the same. Any ideas or thoughts?
TIA
A call to SQL Server Reconciler failed. Try to resynchronize.; The schema script 'F:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\ReplData\unc\ATLDBS02_VISION_ODS_DATA_RADLEY_BATCH_SECURITY_c3d6801\20120426160236\MND_DET_2.sch' could not be propagated to the subscriber.; The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write
Jagannathan Santhanam
All Replies
-
Thursday, April 26, 2012 8:20 PMModeratorIt looks like your sql ce client is trying to download the snapshot files from the local f drive. You need to make this snapshot a share so the merge agent can access is.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
-
Thursday, April 26, 2012 9:03 PMWell, I checked to make sure it is coming from a shared UNC folder. Not sure why it is working in PROD which has exact same settings.
Jagannathan Santhanam
-
Friday, April 27, 2012 2:21 PMModeratorThis message clearly says that it is being downloaded from a drive not a share "the schema script 'F:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\ReplData\unc\ATLDBS02_VISION_ODS_DATA_RADLEY_BATCH_SECURITY_c3d6801\20120426160236\MND_DET_2.sch' "
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
-
Friday, April 27, 2012 2:46 PM
Hi,
Could you able to locate the UNC path from Run?? if you can able to locate the UNC path by \\unc\<your path> , then you can say its being properly shared with relevant folder permissions.
Regards JakDBA Please Mark this as Answered if this solves your issue or satisfied with the response.
- Edited by SQLServer2k8 Friday, April 27, 2012 2:47 PM
.png)
