Today, when the server does publish + subscribe, there is a problem, as follows:
The process could not read the file "D:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\repldata\unc\ because of operating system error 3 User-n18o5dgqu6_cloudtradb_gypt_gypt_f\20151127091512\fn_diagramobjects_129.pre ". (Source: MSSQL_REPL, Error number: mssql_repl20024)
Get help: http://help/MSSQL_REPL20024
The main reason for this problem is that subscribers access the subscription directory snapshot "D:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\repldata\unc\ User-n18o5dgqu6_cloudtradb_gypt_gypt_f\20151127091512\fn_diagramobjects_129.pre "failure caused.
How to resolve:
1. Set the directory hosting the snapshot to share, and set the Read permission;
1) Publishing Server settings:
In the publication properties, click the snapshot on the left and the location of the snapshot file in the right page defaults to D:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\repldata
Set the Repldata folder to shared, and in the security key, set user permissions
2) Subscriber Settings:
Then at the Subscriber, right-click the service name of the subscription, select Properties, set the property parameters as follows
A. Snapshot location modified to alternate folder
B. Snapshot folder modified to \ \ publisher Ip\repldata
2. The request subscription is changed to a push subscription;
The process could not read file D:\XXXX\X.pre (source: MSSQL_REPL, Error Number: mssql_repl20024) due to operating system error 3