replication stopped please help

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

General SQL Server Forums

New to SQL Server Programming

replication stopped please help

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-19 : 18:04:17

Dear Experts,
i've tried to add two new articles to the publisher.i failed there. now i've dropped the articles, but still replication is not working. please let me know what should i do

Arnav
Even you learn 1%, Learn it with 100% confidence.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-19 : 18:05:04

What does replication monitor show?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-19 : 18:05:29

Tell us the steps what you did so we can help you.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-19 : 18:13:00

i've created two tables in publisher first...then i've used sp_addarticle to add the article(i've followed the article from http://www.replicationanswers.com/).

it has taken downtime for 20 min. but i got the below error. replication not working. so that i've dropped the articles.

the error is like this...
the process could not read the file...<path of the file> due to os error 1396...

please let me know what should i do...

Arnav
Even you learn 1%, Learn it with 100% confidence.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-19 : 18:15:20

Please post the entire error from replication monitor. Do not put ... to signify there is more to the error as we need to see the entire thing.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-19 : 18:16:10

After adding article, did you restart snashot agent ?

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-19 : 18:20:39

the exact error is like this...

the process could not read the file '\\emriap_db\replication_test\unc\emriap_db_cti_apps_to_cti_apps_live\20080620031894\voiceconversationtypes_64.pre' due to os error 1396

Arnav
Even you learn 1%, Learn it with 100% confidence.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-19 : 18:23:01

yes sodeep .... a snapshot of 64 articles created 100%

Arnav
Even you learn 1%, Learn it with 100% confidence.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-19 : 18:23:39

Did you verify that the path works when copied/pasted into Start..Run?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-19 : 18:25:31

What account SQL Server agent running on? It should run on domain account for replication.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-19 : 18:26:02

i've tried now....
i got the error stating that

logon failure the target account name is incorrect

Arnav
Even you learn 1%, Learn it with 100% confidence.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-19 : 18:28:25

dear sodeep, can you please let me know how can i check on which account it is running....

Arnav
Even you learn 1%, Learn it with 100% confidence.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-19 : 18:29:56

Go to SQL Config manager -services - SQL Agent-Right click properties

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-19 : 18:30:04

i've done that with sql server login account

Arnav
Even you learn 1%, Learn it with 100% confidence.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-19 : 18:34:14

Dear sodeep,
sql agent is not there

Arnav
Even you learn 1%, Learn it with 100% confidence.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-06-19 : 18:35:24

What?? Check services in Admin tool.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-19 : 18:41:19

i've registered the server instance here with admin previleges. here in this system agent is not there

Arnav
Even you learn 1%, Learn it with 100% confidence.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-19 : 18:48:06

i'm sure that the agent is running with domain account. but i did this adding article with sql server login account.
please guide me to work the replication as it is

Arnav
Even you learn 1%, Learn it with 100% confidence.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-19 : 18:54:54

the error in logs is
replication distribution system agent failed.

Arnav
Even you learn 1%, Learn it with 100% confidence.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-20 : 13:14:33

Dear Sodeep and tara, today i've taken the descktop of the server with terminal access so that all the details i can provide to you.....please help me to make the replication to work perfectly.
i'm planning to create this replication from cti_apps which is production server to cti_apps_live which is in the replication server. i dont know exactly with which user the distribution and publisher databases working. i'd like to create this transactional replication in a planned way and i'd like to document that for future reference. so please guide me in this regard

thank youv ery much

Arnav
Even you learn 1%, Learn it with 100% confidence.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-20 : 13:54:24

quote:
Originally posted by sodeep

Go to SQL Config manager -services - SQL Agent-Right click properties

i've taken the client terminal and checked the sqlserver agent.
it is built in account(local system)

Arnav
Even you learn 1%, Learn it with 100% confidence.

Next Page

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources