Error while creating Publication on sql server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SS2K5 Replication » Error while creating Publication on sql...

Error while creating Publication on sql server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

neellotus07

Posted Saturday, March 09, 2013 3:48 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 5:54 AM
Points: 20, Visits: 143

Hi all,

i am re-creating new publication through New Publication Wizard but it showing Error :- "sp_MSreplagentjobexists can only be executed in the 'distribution' database.Object 'PUM_NM' does not exist or is not a valid object for this operation."

Re-creating because i deleted Replication in following manner:-
- Delete the subscriptions
- Delete the publications

after this i run following commands:-
alter database distribution set offline;
drop database distribution;

Then i realize alter & drop distribution db is very wrong so i re-attached distribution db on both server through SSMS then run following commands to remove replications:-

exec sp_removedbreplication @dbname='distribution'
exec sp_removedbreplication @dbname="STBData" (STBData :- from which articles to be publish).
Now i am creating again Publication on "STBData" Server but it is displaying above error.

i also tried Disable Publishing but it is showing error "Invalid object name 'dbo.syssubscriptons'

Pls help me how i can re-create publications,subscriptions & replication.
i will be very thankful to you.
Thanx

Post #1428866

neellotus07

Posted Monday, March 11, 2013 12:36 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, May 17, 2013 5:54 AM
Points: 20, Visits: 143

it is surprised for me that no one know solution of this problem.

Neel

Post #1429097

« Prev Topic | Next Topic »

Permissions