MS SQL 2005 SP 2 Merge Replication error - The process could not read file ... due to OS Error 3

Posted on 2008-11-19
Last Modified: 2012-05-05
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.
Question by:basiclife
    LVL 15

    Accepted Solution

    You can do it through the publication properties...
    LVL 5

    Author Comment

    Many thanks for the response - it should've worked but unfortunately it turns out that entries were incorrect on sysmergeschemachange which was causing the issue. I'm going to correct these entries and try again.

    I'll award points as the answer was correct - just not in my case.

    Thanks again
    LVL 5

    Author Closing Comment

    Many thanks :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
    Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now