Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
 Posted - 2010-08-10 : 08:15:07
|
| Hello I have two machines named ent-akhil2003 and oracle-2k3.I am trying to replicate a database from a SQL Server instance on ent-akhil2003 to another SQL Server instance on oracle-2k3.It is a pull type subscription and the snapshot is on ent-akhil2003 under location d:\replication.When I launch the replication monitor on subcriber i.e. ent-akhil2003, I see this error message:The process could not read file 'd:\replication\unc\ENT-AKHIL2003_QPS814_QPS814_PUB\20100806182719\AlphaNumericSort_100.pre' due to OS error 21. (Source: MSSQL_REPL, Error number: MSSQL_REPL20051)Is it mandatory to have snapshot on machine oracle-2k3 under location d:\replication? The book discusses the UNC path but I am not able to figure out where and how I should modify the directory path with the UNC path after creating the snapshot? |
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-08-10 : 09:50:06
|
| It seems to be that the subscriber machine is not able to access the path on the publisher machine. I don't know how I can configure the path after creating snapshots. I have to make this path a UNC path for subscriber but I don't know how. |
 |
|
|
mahajanakhil1985
Yak Posting Veteran
71 Posts |
Posted - 2010-08-11 : 05:34:36
|
| Hello I was able to resolve this issue by changing the default snapshot path in Distributor properties. Now, I am using the UNC path and everything is working fine. |
|
|
|
|
|
|
problems in replicating database