replication created but not started error

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 created but not started error

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-20 : 15:54:03

Dear All,
i've created replication between two databases, but while trying to view synchronization status, it is saying that

you must crate a job for this subscription.

what should i do now?

please guide me

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-20 : 16:06:20

Check the replication jobs on the distribution server.

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

Subscribe to my blog

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-20 : 16:16:38

got the error like this...
request to run job <myjob> from user accadmin refused because the job is already running from a request by user sa

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-20 : 16:22:09

I'm confused. Did you try to start a job that was already running? Have you tried restarting the agent?

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-20 : 16:31:48

What do you see in Replication monitor?

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-20 : 16:32:00

yes...

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

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-20 : 16:37:03

Dear sodeep,Tara
i've deleted and recreated again...
now i've seen in relication monitor that uninitilized subscription....
what should i do now?

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-20 : 16:39:34

While setting up replication, did you select the option to initialize?

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

Subscribe to my blog

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-20 : 16:43:17

i'm not sure madam....
but i've selected pull subscription(as that it self defaultly taken)

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

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-20 : 16:47:06

Dear sodeep and tara,
please help me here

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-20 : 16:47:59

I've only ever done push subscriptions, but I doubt that it matters.

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

Subscribe to my blog

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-20 : 16:50:07

please let me know how can i change that to push subscriptions.....
(this is first time i've succeeded to create replication)

please help me

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-20 : 16:50:58

Drop the subscription, then right click on the publication...

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

Subscribe to my blog

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-20 : 16:59:21

quote:
Originally posted by tkizer

Drop the subscription, then right click on the publication...

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

Subscribe to my blog

then right click at publisher or subscriber? i think i need to create the subscriber again....
please correct me if i'm wrong

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-20 : 17:01:52

What part of my last post wasn't clear?

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

Subscribe to my blog

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-06-20 : 17:04:17

then right click on the publication.....

shall i need to delete and create the publisher and subscriber? or need to drop only subscriber and create that again?

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

tkizer
Almighty SQL Goddess

38200 Posts

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

You asked how to do a push subscription, so that was what I was responding to. If you want to do a push subscription, do what I said (both steps) and you'll see the push option.

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

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources