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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Replication Hell.. Yikes...:(

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-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
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
Go to Top of Page

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 folder

where is this directory d:\... located? shouldn't it be a unc path?
\\servername\sharedfolder or \\servername\directory...



--------------------
keeping it simple...
Go to Top of Page

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.
Go to Top of Page

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 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.
Go to Top of Page

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
Go to Top of Page

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?
Go to Top of Page

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
Go to Top of Page

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 traffic

you're probably referring to frequency of replication?

--------------------
keeping it simple...
Go to Top of Page

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
Go to Top of Page

jeroena
Yak Posting Veteran

76 Posts

Posted - 2006-07-27 : 10:06:24
LOL... interesting nick DBASlut. We only have DBANerds here
Go to Top of Page

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..
Go to Top of Page

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
Go to Top of Page

rajumella003
Starting Member

2 Posts

Posted - 2013-02-11 : 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
Go to Top of Page

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?
Go to Top of Page

rajumella003
Starting Member

2 Posts

Posted - 2013-03-26 : 02:50:32
If problem is resolved, why somany people asking for that issue?

Thanks& Regards
Raju Mella
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -