January 28, 2010 at 3:31 pm
I'm trying to build a transaction replication between a SQL2k5 server & a SQL2k8 server. I created the distribution data base & the publication on the SQL2k5 system. Then I created a pull subscription on the SQL2k8 system.
In the job that runs the initialization on the 2k8 system the job is failing. It has this message: The process could not read file 'D:\Microsoft SQL Server\MSSQL.1\MSSQL\ReplData\unc\ snapshot file' due to OS error 21.
Is the subscription trying to read the file from the D drive on the server running the subscription?
How do I instruct it to use the file on the publishing server? The agent has full access to the folder.
Thanks,
BigSam
February 1, 2010 at 6:46 am
It is probably the distributor trying to get the data from the snapshot directory. Usually everyone specifies a shared path for the Snapshot.
-Roy
February 1, 2010 at 3:41 pm
I found the problem. The snapshot was in the wrong folder & the permission to access it was on the wrong folder, too.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply