May 28, 2009 at 6:12 am
My publisher database got corrupted , so i restored the publisher database from yesterdays backup.but now the replication monitor is showing
The process could not execute 'sp_repldone/sp_replcounters' on 'publisher name'.
please help me its urgent
May 28, 2009 at 6:24 am
When you restored publisher data did you use the option KEEP REPLICATION to retain the settings, if not afraid you might to re-configure from scratch.
-Sat
Cheer Satish 🙂
May 28, 2009 at 6:38 am
Why not script out all of the replication objects, drop replication and then re-implement?
May 28, 2009 at 8:06 am
[[[[ When you restored publisher data did you use the option KEEP REPLICATION to retain the settings, if not afraid you might to re-configure from scratch. ]]]]
I didnt set this option...how can i set this.....i run the command sp_replrestart,but now the replication monitor is showing green colour but under publication option nothing is there...pls help
May 28, 2009 at 8:06 am
this is production server we cant drop anything
May 28, 2009 at 8:10 am
You aren't dropping anything other than replication. You'll need to re-snapshot afterwads, but it replication isn't working anyway where is the harm?
May 28, 2009 at 8:15 am
now when i click the properties of a publication under replication monitor it is showing "ERROR 21776:[SQL-DMO].the publication was not found in the TransPublications collection.If the name is a qualified name,use [] to separate various parts of the name , and try again
May 28, 2009 at 8:18 am
If you attempt to generate scripts do you get the same error?
June 3, 2009 at 7:12 am
i am unable to take the script for the replication...publication now get vanished
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply