Cannot generate the replication script? 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

SQL Server 2005 Forums

Replication (2005)

Cannot generate the replication script? Help!!

Author

Topic

NJDba
Starting Member

31 Posts

Posted - 2008-03-17 : 11:10:32

Hi All Replication Experts,

I tried to generate a script for replication at the publisher server, but got this error message:

------------------------
Error 2812: Can not find the store procedure, distribution.sp_MSHelpSubscriptionJobName
------------------------

The distributor and subscriber are on the same server. So I tried to generate the script for replication from the subsciber side, but could not add publication information? What should I do?

Thanks a lot.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-17 : 11:17:57

Explain clearly what you did. Did you try with GUI ?

NJDba
Starting Member

31 Posts

Posted - 2008-03-17 : 11:26:50

Yes, from Enterprise Manager->Replication->Generate SQL Script

Thanks for your reply.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-17 : 11:28:26

So it didn't work from GUI ? Why are you generating Script for it?

NJDba
Starting Member

31 Posts

Posted - 2008-03-17 : 11:33:33

A replication created in test environment was broken last weekend because the published database was restored. The replication which I tried to script is in production environment and it is exactly same as the broken one. So I'd like to generate sql script and then modify some parameters to recover the broken one.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-17 : 11:49:25

How big is the database?

NJDba
Starting Member

31 Posts

Posted - 2008-03-17 : 11:51:44

70GB

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-03-17 : 11:56:52

This will help:

http://www.sqlservercentral.com/Forums/Topic252689-7-1.aspx