SQL Server 2019 subscriptions Error

Kelvin Shee 1 Reputation point
2022-02-16T07:50:50.983+00:00

hi all,

I facing subscriptions error as the picture.

how I can solve it? I have others DB is running good in same server.

thanks for help

174863-sub.jpg

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,914 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,451 Reputation points
    2022-02-16T08:33:07.373+00:00

    Hi @Kelvin Shee ,

    OS error 3 means path not found. You must specify a UNC network share such as \<computername>\snapshot rather than a local path when using pull subscriptions and/or a remote Distributor.
    Here is a similar thread which you can refer to.
    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/91bc83d3-9e63-4767-9451-2295bd895d70/sql-server-replication-os-error-3?forum=sqlreplication

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Vishal 1 Reputation point
    2022-02-16T08:49:38.287+00:00

    Hi @Kelvin Shee ,

    Please try to use UNC network share (such as \<computername>\snapshot) rather than a local path. Refer this documentation for more info.

    Please "Accept the answer" if this helps or let me know more details about your scenario.

    One more reference: Process could not read the file from SQL replication snapshot folder

    0 comments No comments

  3. Olaf Helper 41,496 Reputation points
    2022-02-16T09:20:44.683+00:00

    You got Windows OS error 3 = file not found; have you checked if the mentioned file exists?

    0 comments No comments