February 22, 2005 at 9:23 am
I have replication set up between 2 servers to copy all databases from one to the other. All databases work fine except for one. The distribution agent shows up last command as:
exec dbo.sp_MSinit_subscription_agent @publisher = N'XXX',@publisher_db = N'YYY', @publication = ZZZ', @subscription_type = 0
and error as:
Invalid object name 'MSsubscription_agents'.
Is there an easy way to trace and find out what/where the error is?
Any help will be greatly appreciated.
TIA
February 22, 2005 at 6:22 pm
Normally the job step history have a bit more information than this, usually in a prior step...
I take you have checked the logs ??
I wonder if running a trace while close to this step would yield more clues?
maybe the subscription db is corrupt ?
Cheers
Adam
------------------------------
Life is far too important to be taken seriously
February 23, 2005 at 4:47 am
what type of server are you replicating too?
MySQL?
--
Hilary Cotter
Looking for a book on SQL Server replication?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply