Replication via TSQL

  • Hi,

    Does anyone know of a site that provides step by step instructions of implementing transactional replication via TSQL? I have written a series of jobs to set it up, which seem to work, but I also get errors (usually stuff not exisitng), so I need to check what's what. The idea is that if we have a failure, we can resore from the secondary server, and then set up replication again, via a set of jobs run from say Control -M.

  • You can generate scripts from your existing publications and subscriptions in EM ("Generate SQL Script..." on the right-click menu). This will give you all the steps to recreate them.

    Jay


    Jay Madren

  • Thanks,

    I have done just that, although I did need to clean up the scripts (EM is not that great at scripts).

    However, when I ran them, the log reader did not start, so is there a command I can issue to start the log reader?

    Thanks again

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply