November 9, 2009 at 2:05 am
Hello,
Working on transactional replication, pull replication
between two servers SQL1 and SQL2.
SQL1 is the Distributor, and SQL2 is the Subscriber node.
The Distribution agent always fails when running, with error message :
The process could not read file 'C:\Ariel\ReplData\unc\SQL1_REPMEIR_REPPUBMEIR\20091106111251\Mytable_2.pre' due to OS error 3.ErrorId = 4005, SourceTypeId = 1
ErrorCode = ''
I have defined the snapshot location as a share.
Somebody could help me ?
Meir
November 9, 2009 at 12:40 pm
Does the User that is running the distribution agent have permission to see the share and read the file?
-Roy
November 9, 2009 at 7:42 pm
The distribution agent for a pull subscription runs on the subscriber. For it to be able to read any file in the snapshot (which is on the publishing server), the snapshot must be in a folder that is shared. The publication must use the share name for the location of the snapshot (something like \\sql1\repldata), not a windows partition (i.e. something like \\sql1\repldata instead of c:\somefolder\)
The error message shows that you are not using a share for the snapshot folder. You must change this first.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply