February 4, 2003 at 9:36 am
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.
February 5, 2003 at 3:10 pm
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
February 6, 2003 at 3:17 am
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