Author |
Topic |
DBASlut
Yak Posting Veteran
71 Posts |
Posted - 2006-07-25 : 18:24:23
|
I'm trying to do a Merge Type Replication between 2 servers.. i'm following the instructions from BOK.. and I keep getting this:The schema script 'Table_1_2.sch' could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)Get help: http://help/MSSQL_REPL-2147201001The process could not read file 'D:\ReplData\unc\ECI1-REPL1$CHAOTIC_SAM_TESTMERGE\20060725143881\Table_1_2.sch' due to OS error 3. (Source: MSSQL_REPL, Error number: MSSQL_REPL0)Get help: http://help/MSSQL_REPL0The system cannot find the path specified. (Source: MSSQL_REPL, Error number: MSSQL_REPL3)Get help: http://help/MSSQL_REPL3Arghh....help please... |
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-07-25 : 18:52:14
|
that path looks weird. what is up with the '$' in the middle of it?-ec |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-25 : 22:00:41
|
my guess, you need to share the folder or make sure the publisher sqlserveragent service account has permission to write on the folderwhere is this directory d:\... located? shouldn't it be a unc path?\\servername\sharedfolder or \\servername\directory...--------------------keeping it simple... |
|
|
DBASlut
Yak Posting Veteran
71 Posts |
Posted - 2006-07-26 : 13:14:50
|
quote: Originally posted by eyechart that path looks weird. what is up with the '$' in the middle of it?-ec
that $ is from the instance. I just chose the defaults, changing the drive letter. |
|
|
DBASlut
Yak Posting Veteran
71 Posts |
Posted - 2006-07-26 : 13:16:58
|
quote: Originally posted by jen my guess, you need to share the folder or make sure the publisher sqlserveragent service account has permission to write on the folderwhere is this directory d:\... located? shouldn't it be a unc path?\\servername\sharedfolder or \\servername\directory...-------------------keeping it simple...
sqlserveragent has rights to the D:\ directory. it is on the DB Server.what i have is 2 servers that I want to setup to replicate. Each one would update the other with data. |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-07-26 : 14:01:17
|
As the error message says, the error is "Path not found".Verify that a) the path actually exists at the location given, and b) the account SQL Server Agent is running under has access to that location (not the SQL account, but the Windows account).Ken |
|
|
DBASlut
Yak Posting Veteran
71 Posts |
Posted - 2006-07-26 : 17:42:47
|
thanks all, during setup of Distribution, I replaced the D:\ with the \\servername\directory(shared folder) and its working..now what is the latency? how can I adjust this? |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-07-26 : 18:02:43
|
quote: Originally posted by DBASlut thanks all, during setup of Distribution, I replaced the D:\ with the \\servername\directory(shared folder) and its working..now what is the latency? how can I adjust this?
what exactly do you mean by adjusting the latency? See http://en.wikipedia.org/wiki/Latency_%28engineering%29 for a definition.-ec |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-07-27 : 02:33:53
|
you cannot adjust latency, that depends on your bandwidth and network trafficyou're probably referring to frequency of replication?--------------------keeping it simple... |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-07-27 : 04:30:36
|
"that depends on your bandwidth and network traffic"You might be able to improve it if you can reduce the "hops" - particularly if one or more of them are up-and-down to a satellite!!!But I agree that the question is probably about frequency of replication ...Kristen |
|
|
jeroena
Yak Posting Veteran
76 Posts |
Posted - 2006-07-27 : 10:06:24
|
LOL... interesting nick DBASlut. We only have DBANerds here |
|
|
DBASlut
Yak Posting Veteran
71 Posts |
Posted - 2006-08-07 : 14:39:36
|
yes... how can i adjust the frequency of the replication? In the job it looks like it will on run 1 every minute..i'd like to set it so when I change data on 1 db, it will automatically shoot the changes to other DB.. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-08-07 : 14:57:52
|
Select the option in the schedule to start automatically with the agent. When you setup replication, you also can take the default of continuous.Tara Kizer |
|
|
rajumella003
Starting Member
2 Posts |
Posted - 2013-02-11 : 05:04:04
|
I have resolved this issue.1. Dropped the constraints on subscriber2. Reapplied constraints3. Generated snapshot 2 timesNow replication is working fine.Thanks& RegardsRaju Mella |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2013-02-12 : 07:33:42
|
Why bring up a 7 year old post to tell us that you have fixed an issue that was fixed at the time? |
|
|
rajumella003
Starting Member
2 Posts |
Posted - 2013-03-26 : 02:50:32
|
If problem is resolved, why somany people asking for that issue?Thanks& RegardsRaju Mella |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2013-03-26 : 04:48:50
|
Try reading the rest of the thread, all issues were resolved for the OP. If you have a problem, please start a new thread rather than jumping on one that has been fixed. |
|
|
|