| Author |
 Topic  |
|
|
DBASlut
Yak Posting Veteran
71 Posts |
 Posted - 07/25/2006 : 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-2147201001
The 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_REPL0
The system cannot find the path specified.
(Source: MSSQL_REPL, Error number: MSSQL_REPL3)
Get help: http://help/MSSQL_REPL3
Arghh....
help please...
|
|
|
eyechart
Flowing Fount of Yak Knowledge
USA
3575 Posts |
Posted - 07/25/2006 : 18:52:14
|
that path looks weird. what is up with the '$' in the middle of it?
-ec |
 |
|
|
jen
Flowing Fount of Yak Knowledge
Sweden
4110 Posts |
Posted - 07/25/2006 : 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 folder
where 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 - 07/26/2006 : 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 - 07/26/2006 : 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 folder
where 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
USA
391 Posts |
Posted - 07/26/2006 : 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 - 07/26/2006 : 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
Flowing Fount of Yak Knowledge
USA
3575 Posts |
Posted - 07/26/2006 : 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 |
Edited by - eyechart on 07/26/2006 18:02:57 |
|
|
|
jen
Flowing Fount of Yak Knowledge
Sweden
4110 Posts |
Posted - 07/27/2006 : 02:33:53
|
you cannot adjust latency, that depends on your bandwidth and network traffic
you're probably referring to frequency of replication?
--------------------
keeping it simple... |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 07/27/2006 : 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
Netherlands
76 Posts |
Posted - 07/27/2006 : 10:06:24
|
LOL... interesting nick DBASlut. We only have DBANerds here  |
|
|
|
DBASlut
Yak Posting Veteran
71 Posts |
Posted - 08/07/2006 : 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
USA
35007 Posts |
Posted - 08/07/2006 : 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
India
2 Posts |
Posted - 02/11/2013 : 05:04:04
|
I have resolved this issue.
1. Dropped the constraints on subscriber
2. Reapplied constraints
3. Generated snapshot 2 times
Now replication is working fine.
Thanks& Regards
Raju Mella |
|
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
Posted - 02/12/2013 : 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? |
Edited by - RickD on 02/12/2013 07:33:59 |
|
|
|
rajumella003
Starting Member
India
2 Posts |
Posted - 03/26/2013 : 02:50:32
|
If problem is resolved, why somany people asking for that issue?
Thanks& Regards
Raju Mella |
|
|
|
RickD
Slow But Sure Yak Herding Master
United Kingdom
3560 Posts |
Posted - 03/26/2013 : 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. |
|
|
| |
Topic |
|
Replication Hell.. Yikes...:(
