I need to drop a few publications because they are located on the wrong hard
drive on the server. Before I republish these databases can I delete the
metadata tables? I would assume that if the publication is dropped then the
metadata tables become meaningless, is this correct? Which tables exactly can
I delete? I believe msmerge_contents and tombstone can be deleted, any others?
Thanks,
Pete
Can anyone help me?
Another problem, I am trying to delete a few subscriptions from a server so
that I can resubscribe the databases to the new publications but I keep
getting the error below. I have already dropped the publications and
recreated them in the new location, and the new subscriptions will not
synchronize, the error is "The process could not drop one or more tables
because the tables are being used".
The error I get when trying to delete the old subscriptions is:
"Error 14274: Cannot add, update, or delete a job (or its steps or
schedules) that originated from a MSX server. The subscription could not be
dropped at this time."
I have no idea what a MSX server is.
Please help,
Pete
"Pete" wrote:
> I need to drop a few publications because they are located on the wrong hard
> drive on the server. Before I republish these databases can I delete the
> metadata tables? I would assume that if the publication is dropped then the
> metadata tables become meaningless, is this correct? Which tables exactly can
> I delete? I believe msmerge_contents and tombstone can be deleted, any others?
> Thanks,
> Pete
No comments:
Post a Comment