Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error while creating Publication on sql server 2005 Expand / Collapse
Author
Message
Posted Saturday, March 9, 2013 3:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 31, 2013 2:00 AM
Points: 21, Visits: 150
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
Posted Monday, March 11, 2013 12:36 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 31, 2013 2:00 AM
Points: 21, Visits: 150
it is surprised for me that no one know solution of this problem.

Neel
Post #1429097
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse