MS SQL 2005 SP 2 Merge Replication error - The process could not read file ... due to OS Error 3
Posted on 2008-11-19
I am trying to reinitialize subscriptions with a new Snapshot and getting the following error:
The process could not read file '\\[server]\dist_plus\unc\[server]_TEMPESTIP_TEMPESTIP\20080708104631\KA_TextSearch_76.sch' due to OS error 3.
The folder name referred to does not exist - it has been replaced by a folder created at the time of creation of the new Snapshot. Additionally, there is not an equivalant file KA_TextSearch_??.sch within the new folder.
I've trawled the web all day and am not confident that setting up an addtional snapshot folder will not end up causing me more problems than solve.
What is causing the error? I would expect reinitialization to flush through any refrences to old folders. Can I do anything to prevent it? Is there a way of configuring replication to point at the new folders?
Any help would be very appreciated.