Hi -
I am an extremely novice user attempting to use transactional replication. I successfully ran the replication and then opted to remove the subscriptions, publications and so forth and start again. I did not remove the distributor. I may have removed
jobs associated with the distributor though. When i attempt to recreate the publication, I recieve error 14294 - indicating that a job name or id is desired. I am seeking suggestions as to how I can recover from the error.
Lily,
probably the best way is to start again. You can disable publishing which
removes the distribution database and any remaining jobs/alerts then enable
publishing and distribution which will add all the plumbing including any
alerts and jobs which have been deleted.
HTH,
Paul Ibison
|||Thanks you are the greatest!!
It worked and I am on my way again.
Thanks again!
sql
Wednesday, March 21, 2012
error 14294
Labels:
attempting,
database,
error,
extremely,
microsoft,
mysql,
novice,
opted,
oracle,
ran,
replication,
server,
sql,
successfully,
transactional,
user
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment