hi all,
our datbase was restore but the publications were all gone.
however replication monitor shows publication and subscription.
worst. can create the publication with the same name because
it raises an error saying that it can't drop publication becuase
there is a subscription in it.
how can i remove the publication when the are already gone in the publication
folder but exist in the replication monitor
thanks for the help
if you want to preserve replication when you restore a backup of a published database, specify "KEEP_REPLICATION" with your RESTORE command.
To remove replication from a published database, try sp_removedbreplication.
|||thanks, i already resolve the issue.
i disabled the publications in the rep monitor and then delete its contents
No comments:
Post a Comment