SQLServer 2008 Replication Publication Re-Appear

Discussion in 'microsoft.public.sqlserver.replication' started by Terry Steyaert, May 20, 2010.

  1. We have transactional replication running between several SQLServer 2008
    databases. Distribution and publishers are the same computer, subscribers
    are remote computers. (Both to SQLServer 2008 Enterprise and SQLServer 2008
    Express subscribers.) Somehow (and I'm not remotely sure how), the original
    publications were deleted. The database was then restored (without
    replication on the source) and replication was re-added with slightly
    different names.

    Approximately ten minutes after re-creating all of replication, with
    replication working just fine, two of the three publications show up in
    Replication Monitor. They do NOT appear under the server's publication list
    (under Replication). They appear to ONLY appear in MSpublications and
    MSsnapshot_agents. (And the original should have been transactional
    replication, not snapshot.)

    We've even completely dropped and re-created the distribution database.

    Looking through the MSpublications table, the re-created replication objects
    are of publication_type 1 and a description of "6.x publication".

    Our software does not reference replication. We don't know of anything on
    the subscriber that could re-create the publication.

    Any help would be greatly appreciated,

    Terry Steyaert
    Terry Steyaert, May 20, 2010
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.