SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Replication Hell.. Yikes...:(
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

DBASlut
Yak Posting Veteran

71 Posts

Posted - 07/25/2006 :  18:24:23  Show Profile  Reply with Quote
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  Show Profile  Reply with Quote
that path looks weird. what is up with the '$' in the middle of it?



-ec
Go to Top of Page

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 07/25/2006 :  22:00:41  Show Profile  Send jen a Yahoo! Message  Reply with Quote
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 - 07/26/2006 :  13:14:50  Show Profile  Reply with Quote
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 - 07/26/2006 :  13:16:58  Show Profile  Reply with Quote
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

USA
391 Posts

Posted - 07/26/2006 :  14:01:17  Show Profile  Reply with Quote
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 - 07/26/2006 :  17:42:47  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

USA
3575 Posts

Posted - 07/26/2006 :  18:02:43  Show Profile  Reply with Quote
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
Go to Top of Page

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts

Posted - 07/27/2006 :  02:33:53  Show Profile  Send jen a Yahoo! Message  Reply with Quote
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

United Kingdom
22403 Posts

Posted - 07/27/2006 :  04:30:36  Show Profile  Reply with Quote
"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

Netherlands
76 Posts

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

DBASlut
Yak Posting Veteran

71 Posts

Posted - 08/07/2006 :  14:39:36  Show Profile  Reply with Quote
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

USA
35954 Posts

Posted - 08/07/2006 :  14:57:52  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

India
2 Posts

Posted - 02/11/2013 :  05:04:04  Show Profile  Reply with Quote
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

United Kingdom
3603 Posts

Posted - 02/12/2013 :  07:33:42  Show Profile  Reply with Quote
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
Go to Top of Page

rajumella003
Starting Member

India
2 Posts

Posted - 03/26/2013 :  02:50:32  Show Profile  Reply with Quote
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

United Kingdom
3603 Posts

Posted - 03/26/2013 :  04:48:50  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000